— chk_waits.sql
spool chk_waits.lst
set timi on pause on pages 32
col event form a40 wrap
col total_waits form 999999,999
col total_timeouts form 999999,999 head tot_timouts
select event,total_waits,total_timeouts,time_waited
from v$system_event
order by time_waited desc
/
clear colu
spool off