gc buffer busy acquire madness

From: Nadeem M. Khan <nadeem.m.khan_at_gmail.com>
Date: Mon, 9 Dec 2013 21:57:53 +0400
Message-ID: <CADOPRpC0o9SL3QqdE50N0a--NGj6LUSf_8UnHkyjbugBG9Bsnw_at_mail.gmail.com>

Oracle 11.1.0.7 RAC on Linux with two instances prod1 and prod2 When one instance is open, the second instance takes 40 minutes to open from the mount stage.
When both instances are open, queries take a long time to complete on prod1 When only one instance is open, queries run normally.

My top 5 waits are:

DAY EVENT_NAME
TOTAL_WAIT
--------- ----------------------------------------------------------------

---

09-DEC-13 gc buffer busy

acquire                                               265912
09-DEC-13 gc cr multi block
request                                            106042
09-DEC-13 read by other
session                                                 54826
09-DEC-13 gc cr block
lost                                                       9314
09-DEC-13 DB
CPU                                                                 5584
08-DEC-13 gc cr multi block
request                                            151110
08-DEC-13 library cache load
lock                                                9010
08-DEC-13 DB
CPU                                                                 5014
08-DEC-13 gc cr block
lost                                                       1668
08-DEC-13 control file sequential
read                                           1110
07-DEC-13 gc cr multi block
request                                            172730

Has anyone seen this before? Thanks in advance.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 09 2013 - 18:57:53 CET