SQL Performance (MOSC)

MOSC Banner

Plan not getting loaded from SQLSET

edited Aug 11, 2020 12:05PM in SQL Performance (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center