Dba_* view to check for sql plan baseline usage in historical AWR
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...