set linesize 120
col event format a40
col time_waited format 9999999999999999
select * from (select event, total_waits, total_timeouts, time_waited
from v$system_event
where event not like 'SQL*Net%'
order by time_waited desc) where rownum < 6;
Sample Output:
Code: Select all
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
---------------------------------------- ----------- -------------- -----------------
rdbms ipc message 6626 6327 1729184
jobq slave wait 825 799 241282
pmon timer 683 680 194003
dispatcher timer 33 33 193334
virtual circuit status 66 65 191560