dbmsxplan oracle_用DBMS_XPLAN来展示执行计划。

PURPOSE

-------

To explain the new features of dbms_xplan.display

SCOPE & APPLICATION

-------------------

Support analysts and DBAs.

The function dbms_xplan.display

---------------------------------

In 9.2 we introduced a new function called dbms_xplan.display

to show  execution plans. This function has different option and

can display plans for serial and parallel queries.

This function is defiened in dbmsutil.sql, where you can find all

the different options.

In the scripts utlxpls.sql and utlxplp.sql we call this new function.

Arguments of the  function display

-----------------------------------

function display (table_name   varchar2 default 'PLAN_TABLE',

statement_id varchar2 default null,

format       varchar2 default 'TYPICAL')

- table_name:

speci