Locking Session
Hi Guru's,
Today i run the script to find locked session detail.
SELECT DISTINCT s.sid "SID",serial# "SERIAL#",s.username "USER NAME",o.object_name "OBJECT NAME" ,o.owner "OBJECT OWNER" , DISTINCT s.sid "SID",serial# "SERIAL#",s.username "USER NAME",o.object_name "OBJECT NAME" ,o.owner "OBJECT OWNER" ,s.status,s.osuser,s.machine,s.terminal,s.program,s.TYPE,s.logon_time ,l.ctime " LOCKED TIME (in Seconds)"
FROM v$SESSION s,v$LOCK l,v$locked_object q, dba_objects o WHERE l.sid=s.sid AND q.session_id=l.sid AND o.object_id0