[ORACLE] dbms_xplan reference - 10g (ing)

[dbms_xplan]

- Display (Oracle 9i ~)
---------------------------------------------------------
DBMS_XPLAN.DISPLAY(
   table_name    IN  VARCHAR2  DEFAULT 'PLAN_TABLE',
   statement_id  IN  VARCHAR2  DEFAULT  NULL,
   format        IN  VARCHAR2  DEFAULT  'TYPICAL',
   filter_preds  IN  VARCHAR2 DEFAULT NULL);
---------------------------------------------------------
---------------------------------------------------------
Usage
---------------------------------------------------------

explan plan for
[sql];

select * from table(dbms_xplan.display);

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