SELECT sql_text,plan_name
FROM DBA_SQL_PLAN_BASELINES
WHERE sql_text LIKE '%
2. Use the dbms_xplan package to generate information + execution plan about this specific SQL plan:
SET LONG 10000 SET LINES 200 SET PAGES 300 SELECT * FROM TABLE(DBMS_XPLAN.display_sql_plan_baseline(plan_name=>'SYS_SQL_PLAN_2f5ea4968dd47f8f'));
No comments:
Post a Comment