JAVA 程序pending 数据库锁

 

--SID OF THE SEESION
select sid from v$mystat where rownum<2;

--
select sid,sql_id,blocking_session,event,p1text,p1,p2text,p2,p3text,p3,wait_class,state from v$session where sid in (session);

--row lock records
select sid,sql_id,blocking_session,event,p1text,p1,p2text,p2,p3text,p3,wait_class,state from v$session where EVENT LIKE '%row lock%';

--
select * from v$lock WHERE TYPE='TX';


--
select * from V$LOCK_TYPE where type in ('TX','AE','TM','TO','OD');

 

                connection.setNetworkTimeout(Executors.newFixedThreadPool(2), 20000);