Re: High Version Count on Bind SQLs

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Wed, 3 Nov 2010 06:52:26 +0000
Message-ID: <BLU0-SMTP1004880417C846C2FFA31FE854A0_at_phx.gbl>

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

> Nope we have it set to EXACT.
>
> On Mon, Nov 1, 2010 at 9:42 PM, Michael Dinh <mdinh_at_xifin.com> 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
>> 

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

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

Received on Wed Nov 03 2010 - 01:52:26 CDT