Re: High Version Count on Bind SQLs

  • From: Neil Chandler <neil_chandler@xxxxxxxxxxx>
  • To: "stalinsk@xxxxxxxxx" <stalinsk@xxxxxxxxx>
  • Date: Wed, 3 Nov 2010 06:52:26 +0000

Perhaps a problem with Bind Variables and adaptive cursor sharing? I have heard 
of tens of thousands if cursors in some scenarios. 

Neil.
sent from my phone

On 2 Nov 2010, at 05:30, Stalin <stalinsk@xxxxxxxxx> wrote:

> Nope we have it set to EXACT.
> 
> On Mon, Nov 1, 2010 at 9:42 PM, Michael Dinh <mdinh@xxxxxxxxx> wrote:
>> What is your cursor_sharing set to?
>> 
>> If it's SIMILIAR, then this might be the side effect.
>> 
>> Michael Dinh : XIFIN : 858.436.2929
>> 
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
> 
--
//www.freelists.org/webpage/oracle-l


Other related posts: