待機イベントの一覧を求める

忘れないようにメモ

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;