oracle执行计划

执行计划一：

explain plan set statement_id ='test1' into plan_table for …

select operation,options,object_name,object_type,id,parent_id,position,cost,cardinality,cpu_cost,io_cost

from plan_table where statement_id='test1'

 

执行计划二：

explain plan set statement_id ='test2' into plan_table for …

 

select * from table(dbms_xplan.display('plan_table','test2'))