Re: Query with Bind variables hangs but hard coded literals works fine
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- Date: Tue, 26 Nov 2019 10:27:07 -0500
On Tue, Nov 26, 2019 at 9:46 AM Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
NOTE: These require access to the SQL Tuning & Diagnostics pack so if
you're org didn't pay for that pack, I wouldn't recommend these.
Good stuff, but SQL Profiles also require Enterprise Edition :(
Baselines, however, don't. I'd be interested to see if just rolling back
the optimizer version (optimizer_features_enable) to 12.1.0.2 produces the
same old "good" plan. And if it does, perhaps a baseline could be "faked".
Andy K
PS. If this has already been suggested, apologies for the repeat.
Other related posts: