Plan not getting loaded from SQLSET
Hello Gurus,
OS RHEL 7
DB Version:12102,OFE 11203
Why is the plan not getting loaded into the baseline from sqlset? i can see the plan(PHV 3753493193)in AWR snapid 62337 and i can see the plan in SQLSET too.
SQL> declare 2 baseline_ref_cursor DBMS_SQLTUNE.SQLSET_CURSOR;beginopen baseline_ref_cursor for 3 4 5 select VALUE(p) from table(DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY(62336, 62338,'sql_id='||CHR(39)||'4nz1cpy4k6tk7'||CHR(39)||' and plan_hash_value=3753493193',NULL,NULL,NULL,NULL,NULL,NULL,'ALL')) p;DBMS_SQLTUNE.LOAD_SQLSET('4nz1cpy4k6tk7_3753493193', baseline_ref_cursor);end;/ 6 7 8PL/SQL procedure successfully completed.SQL> select sql_id, substr(sql_text,1, 15) textfrom dba_sqlset_statementswhere sqlset_name = '4nz1cpy4k6tk7_3753493193'order by sql_id; 2 3 4SQL_ID-------------TEXT--------------------------------------------------------------------------------4nz1cpy4k6tk7With usrDtl as
0