Top 10 Wait Events

Post date: May 20, 2014 2:40:7 PM

select inst_id, event, time_waited, total_waits, total_timeouts 

from (select inst_id, event, time_waited, total_waits, total_timeouts 

from gv$system_event where event not in ('rdbms ipc message','smon timer', 

'pmon timer', 'SQL*Net message from client','lock manager wait for remote message', 

'ges remote message', 'gcs remote message', 'gcs for action', 'client message', 

'pipe get', 'null event', 'PX Idle Wait', 'single-task message', 

'PX Deq: Execution Msg', 'KXFQ: kxfqdeq - normal deqeue', 

'listen endpoint status','slave wait','wakeup time manager') 

order by time_waited desc) 

where rownum < 11 

order by time_waited desc;