{パフォーマンスの管理その他}実行計画をmy_plan_tableに格納

 

https://docs.oracle.com/cd/F19136_01/tgsql/generating-and-displaying-execution-plans.html#GUID-E4ED3145-8ABD-4F40-B044-9AEFBD89409C

@?/rdbms/admin/catplan.sql

conn sh/sh

CREATE OR REPLACE PUBLIC SYNONYM my_plan_table for plan_table;

 

explain plan
for
select count(*) from sh.times;

SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

explain plan 
 set statement_id='st1'
 into my_plan_table
for 
select count(*) from sh.times;

SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY('my_plan_table', 'st1'));