Database Tuning (MOSC)

MOSC Banner

Sql Baseline queries

Q1. If a baseline is Enabled, Accepted but not Fixed will the optimiser swap to a better plan if it generates ones ?

Q2. If a baseline is Enabled, Accepted and Fixed will the optimiser swap to a better plan if it generates one ?

Q3. So what happens if you have Fixed and Adaptive set ? Will the optimiser generate and change to a better plan if it can create one ?

Q4. So the purpose of a baseline is to guarantee no degradation in performance, to guarantee a minimum level of performance but how does it guarantee this if the baseline is dependent on the underlying components eg indexes, fresh stats etc?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center