enqueue lock info


select /*+ rule */  * from v$lock  
 where sid in 
 ( select s.sid
 from v$session_wait w , v$session  s
 where 
 w.sid=s.sid and
 s.status='ACTIVE' and
 w.event = 'enqueue' and
 s.type ='USER')
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: