标题: V$SQL.SQL_PLAN_BASELINE is Not Updated After SQL First Time Run [打印本页] 作者: 刘泽宇 时间: 2025-7-20 12:42 标题: 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.