dynamic sampling precedence [message #644365] |
Tue, 03 November 2015 14:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kal_youssef
Messages: 25 Registered: September 2005 Location: canada
|
Junior Member |
![kal_youssef](/forum/theme/orafaq/images/yahoo.png)
|
|
I would like to know if I have the following set then which takes precedence?
OPTIMIZER_DYNAMIC_SAMPLING=2
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
OPTIMIZER_ADAPTIVE_REPORTING_ONLY=FALSE
I tried searching in the oracle documents but there is no mention of which parameter takes precedence in adaptive plans / dynamic sampling
thanks
Kal
|
|
|
|
Re: dynamic sampling precedence [message #644367 is a reply to message #644365] |
Tue, 03 November 2015 16:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Using baselines should stabilize the system: no new exec plans will be used (until successfully evolved). That effectively precludes re-optimization, no matter you do with the other parameters.
|
|
|