Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Jun 30, 2009

Determine Which Session Is Blocking All Users in Oracle

You can find out which session is causing blocking problems using this SQL command:
SELECT blocking_session, sid, serial#, 
   wait_class, seconds_in_wait 
FROM v$session  
WHERE blocking_session IS NOT NULL
ORDER BY blocking_session;
Srinath MS
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap