Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Buffer Busy Waits for Indexes

    Hi,
    How do I tackle too many Buffer Busy Waits observed for two indexes of a table which undergoes lots of Full Table Scans.
    Let me know if any particular information is required.
    Thanks for any help.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    1. Separate ‘hot’ data; use reverse key indexes; smaller blocks
    2. Add freelists or freelist groups
    3. Increase initrans and/or maxtrans

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •