Unable to load sql plans to baseline using sqlset
Hi guys,
I'm unable to load all the sql plans into the baseline from the sqlset.
want to ask. anyone faced this issue before? and how you solve it.
select sqlset_name,SQL_ID, PLAN_HASH_VALUE,ELAPSED_TIME,OPTIMIZER_COST,BIND_DATA from DBA_SQLSET_STATEMENTS where upper(sql_id) = upper('XX8hmghX9v1x')
SQLSET_NAME | SQL_ID | PLAN_HASH_VALUE | ELAPSED_TIME | OPTIMIZER_COST |
XXJ8HMGHA9V1X_SET | XXj8hmghX9v1x | 863,359,580 | 1,242,023,471 | |
XXJ8HMGHA9V1X_SET | XXj8hmghX9v1x | 1,762,480,349 | 16,140,092 | |
XXJ8HMGHA9V1X_SET | XXj8hmghX9v1x | 2,710,829,607 | 74,799,855,313 | 40 |
SET SERVEROUTPUT ON
DECLARE
my_plans pls_integer;