待ちイベントの検索

http://perfopy.ashisuto.co.jp/oracle_performance_educ/taiki_event.html

SELECT e.event,e.total_waits,e.time_waited,e.average_wait
FROM v$system_event e,v$event_name n
WHERE e.event = n.name
AND n.wait_class != 'Idle'
ORDER BY e. time_waited DESC;

めも