buffer waits. questions for GURU's
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: buffer waits. questions for GURU's

  1. #1
    Join Date
    Mar 2001

    Red face

    Does very high buffer gets always mean low busy buffer waits?

    Please explain why

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    Buffer wait occours when you don't have sufficient number of buffers available to load the data. Busy wait occours when the buffer need is dirtied and the system is awaiting DBWR to write to the disk. Now Comming to the point, I don't see how a low busy wait could trigger a high buffer wait. Normally, its the high busy wait that would trigger the buffer wait. I could be wrong ...


    Life is a journey, not a destination!

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