sql_id_time_waited_awr

sql_id_time_waited_awr.sql

SELECT
    INSTANCE_NUMBER,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 INSTANCE_NUMBER,EVENT, SUM(TIME_WAITED) TIME_WAITED
        from dba_hist_active_sess_history a
        WHERE SQL_ID = ''
        AND DBID=''
        and snap_id BETWEEN  and  
        group by INSTANCE_NUMBER,event
    )
order by
    time_waited desc;