Home » RDBMS Server » Performance Tuning » dynamic sampling precedence (Oracle DB
dynamic sampling precedence [message #644365] Tue, 03 November 2015 14:48 Go to next message
Messages: 25
Registered: September 2005
Location: canada
Junior Member

I would like to know if I have the following set then which takes precedence?


I tried searching in the oracle documents but there is no mention of which parameter takes precedence in adaptive plans / dynamic sampling

Re: dynamic sampling precedence [message #644366 is a reply to message #644365] Tue, 03 November 2015 14:53 Go to previous messageGo to next message
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
If you really want to learn the answer, trace CBO decision making using below

Re: dynamic sampling precedence [message #644367 is a reply to message #644365] Tue, 03 November 2015 16:12 Go to previous message
John Watson
Messages: 7212
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.
Previous Topic: Please help for tuning .sql query
Next Topic: SQL*Net roundtrips
Goto Forum:

Current Time: Wed Jan 17 15:12:48 CST 2018

Total time taken to generate the page: 0.01692 seconds