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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Identify patches installed
Next Topic: Oracle Holding Capacity
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 17:04:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.