Re: Question on gc buffer busy waits

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 16 Sep 2012 22:09:36 -0500
Message-ID: <CAJvnOJYcy-0JhddoUZa9=O1=Ymr_zHzo6c4=NCPqwWkHK54M=A_at_mail.gmail.com>

Those may work, but it may also simply be a problem with application design. It could also be a problem with indices that are not sufficiently selective, or many other problems. We cant really tell from your description, at a high level the problem is caused by two different cluster nodes access the same data at the same time. One solution would be to partition your workload more effectively so that one set of data is only accessed from one node.

On Sun, Sep 16, 2012 at 8:24 PM, Krishna <krishna.setwin_at_gmail.com> wrote:

> Hi,
> 11.2.0.3.0
> RAC - 4 node
>
> we are facing "gc buffer busy acquire waits" in our database
> intermittently. This is an OLTP system.
> we are getting lot of blocking on our system. for example: 54 seconds in DB
> Time is spent waiting for TX lock
>
> we are updating same table from all services that are on all nodes..this is
> our primary table..
> the primary key on the table is auto-generated.
>
> 1. I updated all stats
> 2. re-indexed indexes..
>
> Did anybody face the same problem???
>
> will creating a reverse key index on primary solve our problem?? (table has
> abt 2 million records)
>
> Thanks in advance..
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l

Received on Sun Sep 16 2012 - 22:09:36 CDT