待機イベント一覧SQL

忘れないようにメモ

 SELECT
e.event
, e.total_waits as "イベントの合計待機数"
, e.total_timeouts as "タイムアウト合計数 "
, e.time_waited / 100 as "イベントの合計待機秒"
, e.average_wait / 100 as "イベントの平均待機秒"
FROM
v$system_event e
, v$event_name n
WHERE
e.event = n.name
AND e.wait_class != 'Idle'
ORDER BY
e.time_waited DESC;