set lines 200
set pages 30000

--lista de sql plan
select * from DBA_SQL_PLAN_BASELINES

-- crear sqlset
-- añadir sql de awr al sql set con 

DECLARE
cur sys_refcursor;
BEGIN
OPEN cur FOR
SELECT VALUE (P) FROM table(dbms_sqltune.select_workload_repository(1,2)) P;
-Process each statement (or pass cursor to load_sql set)
CLOSE cur;
END;
/

user dbms_spm.LOAD_PLANS_FROM_SQLSET para cargar las sql del sql set



