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