Question on gc buffer busy waits
From: Krishna <krishna.setwin_at_gmail.com>
Date: Sun, 16 Sep 2012 21:24:09 -0400
Message-ID: <CAF6DRCoZ-qKdTMGbBf7Wh3d7oGsat6VujeRzhLe0F=PtrRGkSQ_at_mail.gmail.com>
Hi,
11.2.0.3.0
RAC - 4 node
Date: Sun, 16 Sep 2012 21:24:09 -0400
Message-ID: <CAF6DRCoZ-qKdTMGbBf7Wh3d7oGsat6VujeRzhLe0F=PtrRGkSQ_at_mail.gmail.com>
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.
- I updated all stats
- 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-lReceived on Sun Sep 16 2012 - 20:24:09 CDT