-- 
-- Show wait time for backround processes since instance startup
-- Based on idea of response_time_breakdown.sql by Steve Adams
-- (C) 2004 Dsvolk (http://dsvolk.msk.ru/oracle)
-- for Oracle 9i 
-- 

select 
    major "Process name", substr(minor, 3) "Event Class", wait_event "Event name",
    to_char(100*ratio_to_report (time_spend) over (), '999.00') || ' %' pct
from 
(
select  sum(total_waits) time_spend, 
s.program major, 
apt_event_class (e.event) minor, e.event wait_event 
from v$session_event e, v$session s
where s.type =  'BACKGROUND' and s.sid = e.sid
and e.event not in (select a.event_name from apt_idle_events a)
group by e.event, s.program
order by time_spend desc
)
order by   minor asc, time_spend desc