1 Reply Latest reply: Feb 29, 2012 3:23 AM by Billy~Verreynne RSS

    solution for :SIGNIFICANT "BUFFER BUSY WAITS" FOR AN PARTICULAR AQ TABLE

    909751
      Hi,
      My customer is observing buffer busy waits for a particular table we have these options to remove this:

      Buffer busy waits are common in high volume AQ systems (just the way the
      AQ works),
      so what options do we have to reduce this contention
      1. Iis partitioning supported
      2. should we unlock the stats and gather them
      3. any custom indexes that can be used to help reduce
      4. any changes to segment storage options


      WE require answer very fast. Many thanks in advance!!!
        • 1. Re: solution for :SIGNIFICANT "BUFFER BUSY WAITS" FOR AN PARTICULAR AQ TABLE
          Billy~Verreynne
          906748 wrote:
          Hi,
          My customer is observing buffer busy waits for a particular table we have these options to remove this:

          Buffer busy waits are common in high volume AQ systems (just the way the
          AQ works),
          so what options do we have to reduce this contention
          1. Iis partitioning supported
          2. should we unlock the stats and gather them
          3. any custom indexes that can be used to help reduce
          4. any changes to segment storage options
          How does this performance issue relate specifically to the o-o tehnology of PL/SQL and SQL?
          WE require answer very fast. Many thanks in advance!!!
          Then use Oracle Support. That is what PAID support is for.

          Or do you expect professionals with jobs, spending their free time to assist others here, to simply stop doing what they get paid to do, and jump to your demands for an urgent resolution for you problem... for free?

          Think again.