Active Session History (ASH)
Automatic Workload Repository (AWR)
I/O waits
lock waits
CPU waits
-- Shared Pool select event, time_waited "time_waited(s)", case when time_waited = 0 then 0 else round(time_waited*100 / sum(time_waited) Over(), 2) end "percentage" from ( select event, sum(time_waited) time_waited from v$active_session_history where sql_id = 'SQL_ID' --REPLACE THE SQL_ID HERE group by event ) order by time_waited desc;
v$active_session_history
-- AWR select event, time_waited "time_waited(s)", case when time_waited = 0 then 0 else round(time_waited*100 / sum(time_waited) Over(), 2) end "percentage" from ( select event, sum(time_waited) time_waited from dba_hist_active_sess_history where sql_id = 'SQL_ID' --REPLACE THE SQL_ID HERE group by event ) order by time_waited desc;
dba_hist_active_sess_history
'5auuumydvc0ym'