SQL Performance (MOSC)

MOSC Banner

Dba_* view to check for sql plan baseline usage in historical AWR

edited Nov 22, 2018 5:45PM in SQL Performance (MOSC) 1 commentAnswered ✓

Hello All,

We get lot of performance issues in our environment and use sql plan baselines extensively..I am checking if there is any Dba_* view to check for usage of  sql plan baseline when looking in historical AWR in conjunction with dba hist sqlstat view.

v$sql has sql profile and sql plan baseline columns but dba hist sqlstat view only has column sql_profile but not baseline which make it hard to see if a baseline is used in all the runs especially if there are lot of PHVs for the sql and baselines enabled.

I am aware that we can check it from the dbms_xplan.display_awr from 'NOTE' section but if the sql has multiple baselines enabled its hard to check...

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