-- 
-- Show Responce time for instance  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 
    substr(major, 3) "Major", substr(minor, 3) "Event Class",  wait_event "Event name",
    to_char(100*ratio_to_report (time_spend) over (), '999.00') || ' %' pct
from 
(
select  sum(vs.value) time_spend, 'n/a' wait_event, '1 CPU used' minor, '1 CPU time' major  
from v$sysstat vs
where vs.name = 'CPU used when call started'

union 
-- Waits for foreground and background events 
select  vs.time_waited time_spend, vs.event wait_event, 
apt_event_class ( vs.event)  minor, 
'2 Waits ' major from v$system_event vs 
where  vs.event not in (select a.event_name from apt_idle_events a)
-- order by time_spend desc
)

 order by  major asc, minor asc,  time_spend desc