Re: 11.2 ACS for DMLs that use Binds
- From: Stefan Koehler <contact@xxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>, Hemant-K.Chitale@xxxxxx
- Date: Tue, 7 Oct 2014 10:55:31 +0200 (CEST)
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@xxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
