-
Hi
I've got statistic results (by STATSPACK) as follows:
Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Event Waits
-------------------------------------------- ------------
SQL*Net more data to client 32,837
log file parallel write 10,077
log file sync 9,833
SQL*Net break/reset to client 5,752
direct path read 3,626
-------------------------------------------------
and (in another snapshot set):
Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Event Waits
-------------------------------------------- ------------
control file parallel write 484
control file sequential read 48
file open 45
direct path read 17
direct path write 14
-------------------------------------------------
looks like there is a bottleneck writing to
logs/control files.
Do you have any idea on how to correct this situation?
Thanks
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|