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
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Other related posts: