Re: adaptive cursor sharing and bind peeking

  • From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
  • To: ax.mount@xxxxxxxxx
  • Date: Thu, 30 May 2013 06:35:33 -0400

Once it is bind aware on every execution it looks at the values of binds
and compares to acs selectivity profile for this sql, if there is a match
it selects the plan of that child cursor, if there is no match it goes into
a hard parse. If after the hard parse it generates one plan that is already
on the selectivity profile it expands the profile to include the new
selectivity range. if the new plan is not in the profile the newly created
child cursor will record the selectivity profile of this execution.

On Thu, May 30, 2013 at 6:24 AM, amonte <ax.mount@xxxxxxxxx> wrote:

> Thanks Christian
> For all type of parses, hard, soft, softer?
>
> Thank you
>
>
> 2013/5/30 Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
>
> > Hi
> >
> >
> >
> > Yes, for bind-aware cursors it peeks the value(s) for every parse call.
> >
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Cheers -- Carlos Sierra
http://carlos-sierra.net/


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


Other related posts: