1. Home
  2. Knowledge Base
  3. Performance Tuning
  4. Script – What Wait Events Are Sessions Waiting On
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Script – What Wait Events Are Sessions Waiting On

Script – What Wait Events Are Sessions Waiting On

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
;
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment