Re: Library Cache and Share wait on Latch - Version Count Huge

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 17 Mar 2010 20:01:48 -0400
Message-ID: <04CA1C3B-32F8-496B-8AEE-27AF2F27EA0F_at_proquest.com>



Start by looking at v$SQL_shared_cursor to understand why your child cursors are not shareable.

It's possible that it's due to stats generation, but there are many other possibities, and it would be impossible to speculate.

-Mark

Sent from my iPhone

On Mar 17, 2010, at 19:40, "Mudhalvan Moovarkku" <moovarkku.mudhalvan_at_axa-direct.co.jp<mailto:moovarkku.mudhalvan_at_axa-direct.co.jp>> wrote:

Dear DBAs

      Greetings. When I check the wait events recently for few days Library Cache and Share Pool wait got the very huge value.

      When i check the V$SQLAREA few sql have very huge versions more than 3000.

       My Database version is 10g Rel2 10.2.0.4 on Redhat Linux AS4 with update 4.

       CURSOR_SHARING set to SIMILAR and OPTIMIZER_MODE=CHOOSE.

       This is happening only recently and is it related to Automatic Statistics done on 10g Rel 2.

      Please let me know how to check and avoid it.

Regards
Mudhalvan M.M

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 17 2010 - 19:01:48 CDT

Original text of this message