Home » RDBMS Server » Server Administration » Top 5 Wait Events
Top 5 Wait Events [message #223482] Fri, 09 March 2007 02:26 Go to next message
Messages: 2
Registered: February 2007
Location: PUNE
Junior Member
We are taking daily awr report from last 15 days.

we Observer the following top 5 wait events in each reports.

log file sync
CPU time
log file parallel write
db file sequential read
db file parallel write

Refer attached report for you reference..

Do you is there anything at parameter file which we need to

Thanks in advance
Re: Top 5 Wait Events [message #223590 is a reply to message #223482] Fri, 09 March 2007 13:09 Go to previous message
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Perhaps spreading the i/o between more devices. Take the 'hot' devices and move some of the datafiles.
Previous Topic: Identify patches installed
Next Topic: Oracle Holding Capacity
Goto Forum:

Current Time: Thu Jul 20 11:28:00 CDT 2017

Total time taken to generate the page: 0.11956 seconds