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'))


版权声明:本文为weixin_41126842原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。