Re: 11.2 ACS for DMLs that use Binds
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "Hemant-K.Chitale@xxxxxx" <Hemant-K.Chitale@xxxxxx>
- Date: Tue, 7 Oct 2014 11:01:59 +0100
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@xxxxxx> 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.
Other related posts:
