RE: 11.2 ACS for DMLs that use Binds
Date: Tue, 7 Oct 2014 17:07:05 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB6026E4918_at_HKJUMXMB103B.zone1.scb.net>
My test case is on a VM at home. I'll try the BIND_AWARE hint.
Hemant K Chitale
-----Original Message-----
From: Stefan Koehler [mailto:contact_at_soocs.de]
Sent: Tuesday, October 07, 2014 4:56 PM
To: ORACLE-L; Chitale, Hemant K
Subject: Re: 11.2 ACS for DMLs that use Binds
Hi Hemant,
i just run a quick test and it worked with /*+ BIND_AWARE */ hint for DML (INSERT) in my case (Oracle 11.2.0.3.6). Without that hint the DML cursor is marked as bind sensitive and shareable, but not marked as bind aware. I run out of time so maybe you can work with that at first.
MOS ID #740052.1 describes various scenarios when each of the features kicks in or not. However ACS may not monitor the row sources for DMLs by default the same way which would make sense (in various situations), but i would need to research furthermore or some other guys already did.
Best Regards
Stefan Koehler
Oracle performance consultant and researcher http://www.soocs.de
> "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com> hat am 7. Oktober 2014 um 09:31 geschrieben:
>
>
> 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. †Ûiÿü0ÁúÞzX¬¶Ê+ƒü n– {ú+iÉ^ Received on Tue Oct 07 2014 - 11:07:05 CEST