https://community.oracle.com/thread/2412777?start=0&tstart=0 Best regards Mohamed Houri 2014-10-07 12:01 GMT+02:00 Dominic Brooks <dombrooks@xxxxxxxxxxx>: > 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 > . > > -- 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>