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;