Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Script – Top database wait events | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – Top database wait events

  • Posted by Gavin Soorma
  • On July 6, 2009
  • 0 Comments

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;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *