Re: adaptive cursor sharing and bind peeking

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Thu, 30 May 2013 06:35:33 -0400
Message-ID: <CAGzKQQeDdYN2B-3+RCo2+pURXFcbpVPR0hiK8=3ArF9dRO99eg_at_mail.gmail.com>

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_at_gmail.com> wrote:

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

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


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

Received on Thu May 30 2013 - 12:35:33 CEST