Re: 11.2 ACS for DMLs that use Binds

Best regards
Mohamed Houri

2014-10-07 12:01 GMT+02:00 Dominic Brooks <dombrooks_at_hotmail.com>:

> 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
> .
>
>

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Member of Oraworld-team <http://www.oraworld-team.com/>

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

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