Re: 11.2 ACS for DMLs that use Binds

I have been able to use the BIND_AWARE Hint to make the DML "aware" from the first execution.

I've updated my blog post at
http://hemantoracledba.blogspot.com/2014/10/11g-adaptive-cursor-sharing-does-it.html

On Tue, Oct 7, 2014 at 4:55 PM, Stefan Koehler <contact_at_soocs.de> wrote:

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

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com

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