오라클 19c 최근 ash event 확인 쿼리

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.3.0.0

 

방법 : 오라클 19c 최근 ash event 확인 쿼리

오라클 19c 최근 ash event 확인 쿼리

최근 몇시간, 몇분, 몇초를 where 절에서 조절하여 각각 확인가능함

SQL>
col wait_class for a12
col event for a50
select * from (
 select
 WAIT_CLASS ,
 EVENT,
 count(sample_time) as EST_SECS_IN_WAIT
 from v$active_session_history
 --where sample_time between sysdate - interval '1' hour and sysdate
 --where sample_time between sysdate - interval '1' minute and sysdate
 where sample_time between sysdate - interval '30' second and sysdate
 group by WAIT_CLASS,EVENT
 order by count(sample_time) desc
 )
where rownum <6;
 
WAIT_CLASS   EVENT                                              EST_SECS_IN_WAIT
------------ -------------------------------------------------- ----------------
                                                                               6
Other        oracle thread bootstrap                                           2
User I/O     external table read                                               2
Other        os thread creation                                                2
Other        control file heartbeat                                            2

 

 

참조 :