wait event is control file sequential read
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: wait event is control file sequential read

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    speed up access to your control files, your disks are too slow

  3. #3
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Quote 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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    provide faster disks, spread out your io

  5. #5
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Quote 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.

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  


Click Here to Expand Forum to Full Width