查找被锁对象的名称、sid，锁定的类型-1123

select lk.sid,lk_obj.object_id,obj.object_name,DECODE(LK.LMODE,0,'None',1,'Null',2,'Row-S (SS)',3,'Row-X (SX)',4,'Share',5,'S/Row-X (SSX)',6,'Exclusive') lmode from v$locked_object lk_obj,dba_objects obj,v$lock lk  where lk.sid=lk_obj.session_id and lk_obj.object_id=obj.object_id and lk.sid=142;   --version2    col obj.object_name for a15

col lmode for a15

 

select sess.sid,sess.SERIAL#,lk_obj.object_id,obj.object_name,DECODE(LK.LMODE,0,'None',1,'Null',2,'Row-S (SS)',3,'Row-X (SX)',4,'Share',5,'S/Row-X (SSX)',6,'Exclusive') lmode,to_char(sess.LOGON_TIME,'yyyy-mm-dd hh24:mi:ss') logon_time from v$locked_object lk_obj,dba_objects obj,v$lock lk ,v$session sess where lk.sid=lk_obj.session_id and lk_obj.object_id=obj.object_id  order by sess.LOGON_TIME desc;      

转载于:https://www.cnblogs.com/iyoume2008/p/6094278.html

相关资源：JAVA上百实例源码以及开源项目