My Works/Oracle

[ORACLE] dbms_xplan reference - 10g (ing)

proud0 2009. 2. 6. 14:42
[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);

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