V$SQL.SQL_PLAN_BASELINE is Not Updated After SQL First Time Run

刘泽宇

现象：
When baseline is loaded to SPM from autotrace file, the baseline is used
But run the target sql only one time, the v$sql.sql_plan_baseline is null
After run again, the v$sql.sql_plan_baseline is updated


原因
This is due to following internal bug:

Bug 20453095 - AFTER BASELINE IS CREATED V$SQL.SQL_PLAN_BASELINE IS NULL AT FIRST TIME RUN


处理方法：
Baseline is used and the effect is only V$SQL.SQL_PLAN_BASELINE is not updated.

Running again, v$sql.sql_plan_baseline is updated.

And this issue can't reproduce after 12.1.0.2 version.