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
Shekhar_Mohol
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
modify.

Thanks in advance
Shekhar
Re: Top 5 Wait Events [message #223590 is a reply to message #223482] Fri, 09 March 2007 13:09 Go to previous message
nmacdannald
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: Mon Dec 05 19:20:02 CST 2016

Total time taken to generate the page: 0.11673 seconds