ASH関連の隠しSQL

軍鶏/ 7月 7, 2020/ 未分類

過去１時間の待機イベント
select distinct to_char(sample_time,’HH24:MI’) end_time,
event,
count(*) sample_count
from gv$active_session_history
where
— (sample_time > localtimestamp – INTERVAL ’60:00′ MINUTE TO SECOND )
sample_time > sysdate – 1/24
and event is not null
and wait_class=:WAIT_CLASS
group by (sample_time,’HH24:MI’),event
order by end_time;