-
wait event is control file sequential read
If you have
control file sequential read as your top wait event,
what does it mean?
and what to do about it?
how do i find out which of the control files is the culprit?
Thanks
Looking for the greatest evil in the world? Look in the mirror.
-
speed up access to your control files, your disks are too slow
-
Originally Posted by davey23uk
speed up access to your control files, your disks are too slow
Thanks
But how do you speed up access to your control files?
Looking for the greatest evil in the world? Look in the mirror.
-
provide faster disks, spread out your io
-
Originally Posted by davey23uk
provide faster disks, spread out your io
Thanks Davey,
But disks take time and my files are already on different disks...The issue has gone away but may show up again.
Looking for the greatest evil in the world? Look in the mirror.
-
You have 2 options:
1. Store the control file on the outer edge of the disk platter.
2. Use RAW device
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
|