Locked Objects

----------------
-Locked Objects
----------------

set pages 100
set line 200
col "User Name" for a10
col owner for a10
col Object_type for a10
col "Lock Type" for a15
select substr(lpad(' ',decode(l.xidusn,0,3,0))||l.oracle_username,1,10) "User Name",substr(l.session_id,1,5)Sid,substr(S.SERIAL#,1,5) serial#,
s.status,to_char(s.logon_time,'dd-mon-yy hh24:mi') logon_time,substr(o.owner,1,10) Owner, o.object_name,substr(o.object_type,1,10) Object_type,
substr(decode(l.locked_mode,2,'Row Share',3,'Row exclusive',4,'Share mode',5,'Share row exclusive',6,'Exclusive mode'),1,15) "Lock Type" from 
gv$locked_object l ,all_objects o,gv$SESSION S where l.object_id=o.object_id and s.sid=l.session_id order by logon_time
/