News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – What Wait Events Are Sessions Waiting On

  • Posted by Gavin Soorma
  • On July 2, 2009
  • 0 Comments
set linesize 120
col username format a10
col event format a30
 
select sid, serial#,username, event,
seconds_in_wait, wait_time
from v$session where state = 'WAITING'
and wait_class != 'Idle'
order by event
;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *