Database Administration (MOSC)

MOSC Banner

Locking Session

edited Feb 24, 2010 6:23PM in Database Administration (MOSC) 5 commentsAnswered
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_id

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center