Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Top Wait Events

573141Dec 21 2009 — edited Dec 21 2009
hi gurus,

3 node rac 10.2.0.4 serving a packaged application.

Top 5 timed events in awr shown as


Event=CPU time
Waits=
Time(s)=1,950
Avg Wait(ms)
% Total Call Time=45.3
Wait Class

Event=gc cr multi block request
Waits= 6,551,055
Time(s)= 1,396
Avg Wait(ms)=0
% Total Call Time=38.9
Wait Class= Cluster

Event=db file scattered read
Waits= 186,295
Time(s)= 719
Avg Wait(ms)=4
% Total Call Time=18.2
Wait Class= User I/O

Event=db file parallel read
Waits= 43,383
Time(s)= 241
Avg Wait(ms)=6
% Total Call Time= 5.9
Wait Class= User I/O
Event= log file sync
Waits= 71,064
Time(s)= 83
Avg Wait(ms)=1
% Total Call Time= 3.1
Wait Class= Commit



db_block_size=8KB
db_file_multiblock_read_count = default setting of 128

question:
are the high wait values of gc cr multi block request and db file scattered read are due to db_file_multiblock_read_count?
if that's the case, is there a way to find optimum value for db_file_multiblock_read_count?
or any other findings please?

experts, appreciate your valuable help

thanks in advance,
charles
This post has been answered by Jonathan Lewis on Dec 21 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2010
Added on Dec 21 2009
7 comments
1,311 views