[Oracle]如何查看SQL的执行计划 - DBMS_XPLAN Package

查看执行计划除了AUTOTRACE的方法外，还可以使用DBMS_XPLAN Package来查看

1.执行"explain Plan"

语法:
SQL> Explain plan for

Try this command:
SQL> explain plan for select * from mtl_system_items_b where inventory_item_id = 149 and organization_id = 207;
Explained

这个命令会产生执行计划，并把执行计划保存到"PLAN_TABLE"中。

2.查看执行计划
SQL> select * from table(dbms_xplan.display);

(dbms_xplan.display() is a packaged function used to view the execution plan generated.)

Output like:

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
---------------