Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Buffer Busy Waits

Buffer busy waits occur when a session cannot access a needed block because it is in use by another session. The two most common causes are:

  • insufficient free lists for a table, or
  • too few rollback segments.

If buffer busy waits are significant, check the category of events being waited for on the Wait Activity Page.

If most buffer waits are for data blocks, it is likely that you need to create multiple free lists (using the FREELIST clause of the CREATE TABLE statement) for tables that are subject to very heavy concurrent inserts. If the leading category is for Undo Header or Undo Block, you may need to create additional rollback segments.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating