Re: 11.2 ACS for DMLs that use Binds

I have been able to use the BIND_AWARE Hint to make the DML "aware" from the first execution.

I've updated my blog post at
http://hemantoracledba.blogspot.com/2014/10/11g-adaptive-cursor-sharing-does-it.html

On Tue, Oct 7, 2014 at 6:01 PM, Dominic Brooks <dombrooks_at_hotmail.com> wrote:

> Difficult to prove something never works.
>
> I've a couple of test cases which I tend to use for ACS and it doesn't
> kick in if I change these to insert selects.
>
> However if I hint /*+ bind_aware */ it does.
>
> So... I'm not sure if that's much help apart from to say ACS can work with
> inserts but it doesn't seem as easy to get the optimiser to comply.
>
> Sent from my iPhone
>
> On 7 Oct 2014, at 08:33, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com>
> wrote:
>
> Does anyone have evidence / notes / documentation on whether and how
> Adaptive Cursor Sharing can kick in for **DML** that uses Binds ?
>
> I’ve run a few tests where a SELECT statement does show Adaptive Cursor
> Sharing but when I include the SELECT in an INSERT ... SELECT, I don’t
> see Adaptive Cursor Sharing happening.
>
> Hemant K Chitale
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com

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