Re: gc buffer busy acquire madness
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: nadeem.m.khan@xxxxxxxxx
- Date: Mon, 9 Dec 2013 10:18:50 -0800
Nadeem
Data you have provided is not complete enough, but, I think, the database
is suffering from dropped packets. You might want to share AWR or statspack
reports, CPU, and network statistics. Dropped network packets can lead to
reassembly failures, which can lead to the symptoms that you have posted
here.
Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance,
RAC and EBS
Blog: http://orainternals.wordpress.com/
Oracle ACE Director and OakTable member <http://www.oaktable.com/>
Co-author of the books: Expert Oracle
Practices<http://tinyurl.com/book-expert-oracle-practices/>
, Pro Oracle SQL, <http://tinyurl.com/ahpvms8>
<http://tinyurl.com/ahpvms8>Expert
RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL
practices <http://tinyurl.com/book-expert-plsql-practices>
<http://tinyurl.com/book-expert-plsql-practices>
On Mon, Dec 9, 2013 at 9:57 AM, Nadeem M. Khan <nadeem.m.khan@xxxxxxxxx>wrote:
> 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:
