gc buffer busy acquire madness
- From: "Nadeem M. Khan" <nadeem.m.khan@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Dec 2013 21:57:53 +0400
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.
Other related posts:
