Re: gc buffer busy acquire madness

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Mon, 9 Dec 2013 10:18:50 -0800
Message-ID: <CAA2Dszzvsyhu1-izuqF6vB4BQwZ8FjNsvjiq=jVQ3ai3hOvfFw_at_mail.gmail.com>

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_at_gmail.com>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.
>

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

Received on Mon Dec 09 2013 - 19:18:50 CET