sql_id_time_waited

sql_id_time_waited.sql

SELECT
    INST_ID,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 INST_ID,EVENT, SUM(TIME_WAITED) TIME_WAITED
        FROM gV$ACTIVE_SESSION_HISTORY
        WHERE SQL_ID = 'SQL_ID'
        group by INST_ID,event
    )
ORDER BY
    time_waited desc;