Re: Bind Sensitivity and PL/SQL cursor caching
Date: Wed, 29 Mar 2017 10:14:17 -0400
Message-ID: <CADo_RaMfdXyxLonODnJJvD1q=PxhKF-DtV7Q=hHtLYJpnngZvA_at_mail.gmail.com>
Hi Patrick,
Session cached cursors are awesome and would be a shame to lose them. I know you've simplified your use case, but is it possible that you already know what the skewed inputs are at run time? If so, depending on the inputs you could call a different _hinted_ SQL to produce the plan you want. Then the rest could use a different plan.
No school like the old school.
Andy K
On Wed, Mar 29, 2017 at 4:34 AM, Patrick Jolliffe <jolliffe_at_gmail.com> wrote:
> Hi List,
> ...
> What I really want is somehow to get this bind_aware/sensitivity stuff
> working with PL/SQL, but without having set/reset session_cached_cursors.
> A /*+NO_SESSION_CACHE*/ hint would be ideal I think (any downsides or
> complexities for implementation?)
> Any other ideas? (btw Oracle 12.1.0.2)
> Thanks in advance
> Patrick
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 29 2017 - 16:14:17 CEST