This script will list the top 5 database wait events since instance startup sorted by time waited
set linesize 120
col event format a30
select * from (
select event, total_waits, total_timeouts, time_waited
from v$system_event
where event not like 'SQL*Net%'
and event not in ('pmon timer','rdbms ipc message','dispatcher timer','smon timer')
order by time_waited desc )
where rownum < 6;
The following two tabs change content below.
Gavin Soorma
