Re: Library Cache and Share wait on Latch - Version Count Huge
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