Re: 11.2 ACS for DMLs that use Binds

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 7 Oct 2014 10:55:31 +0200 (CEST)
Message-ID: <1922941178.216622.1412672131389.open-xchange_at_app09.ox.hosteurope.de>

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

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

Received on Tue Oct 07 2014 - 10:55:31 CEST