Hi,
My database version is 11.2.0.03 quarter rack exadata 64 bit machine
I created a baseline for a poorly performing SQL and then added used hints to fix the plan and associated the new plan with the sql_handle of the old plan. I am able to see both the plans (good and bad) present in dba_sql_plan_baselines table as shown below
Old
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_fgky3z20smxzve27462bc Plan id: 3799278268
Enabled: YES Fixed: NO Accepted: YES Origin: AUTO-CAPTURE
--------------------------------------------------------------------------------
Modified
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_fgky3z20smxzve307ad0f Plan id: 3808931087
Enabled: YES Fixed: YES Accepted: YES Origin: MANUAL-LOAD
--------------------------------------------------------------------------------
When I query the dba_sql_plan_baselines with the signature below is the output
SIGNATURE SQL_HANDLE PARSING_SCHEMA_NAME ENABLED ACCEPTED FIXED
--------- ------------------------------ ------------------------------ ------- -------- -----
16702659115126224891 SQL_e7cbc3f88189f7fb SSO307010265 YES YES NO
16702659115126224891 SQL_e7cbc3f88189f7fb SSO307010265 YES YES YES
I then verified gv$sql and found that the signature is showing up in the EXACT_MATCHING_SIGNATURE but the sql_plan_baseline is NULL.
I am not able to figure out what is it that I am missing.
Can anyone please help
Thanks,
Jayadeep