Hi,
I observed many sqls having null value against sql_plan_baseline field in v$sql view, even if they have been executed several times. Database version is 11.2.0.3 and optimizer_capture_sql_plan_baselines and optimizer_use_sql_plan_baselines are both set to TRUE.
As per my understanding I was expecting baselines against sqls executed more than once. There must be something I am missing. Thanks in advance for any help in this regard.
SQL> select sql_id, executions, sql_plan_baseline,sql_profile
from v$sql
where sql_id='708ttsyv645s4';
SQL_ID EXECUTIONS SQL_PLAN_BASELI SQL_PROFILE
------------- ---------- --------------- ---------------
708ttsyv645s4 45603
Regards,
Joy