Poll: SQL Plan Management
May 4, 2012 1 Comment
I’m interested in what SQL Plan Management features people are actively using.
For example on one system I’m working on, we use SQL Plan Baselines selectively, we have a couple of sql profiles as they were originally intended (i.e. as mechanisms for adjusting the optimizer’s estimates) and at least one sql profile created via the SQLT/COE method (i.e. outline-style hints). And, instead of hinting problem statements manually and inadequately, I’m pushing people towards using more and more of all three of these approaches depending on the scenario.
Another system has baselines off completely whilst another has pretty much everything baselined.
It very much depends on the system, who implemented it and what exact version the system was originally implemented on or upgraded to, and what problems they had during the implementation
If you have had any interesting experiences with any of these features then please add a comment.
For example, there was a nasty performance bug with baselines in 11.2.0.2 which is the version we did one initial upgrade to. Even though there was a patch for this bug, it put the kibosh on any plans to use baselines extensively to safeguard performance through the upgrade.