December 2002
Intermediate to advanced
928 pages
85h 29m
English
FUNCTION DBMS_XPLAN.DISPLAY
(table_name IN VARCHAR2 DEFAULT 'PLAN_TABLE',
statement_id IN VARCHAR2 DEFAULT NULL,
format IN VARCHAR2 DEFAULT 'TYPICAL');
Displays information from EXPLAIN PLAN stored in table_name with an optional statement_id for the plan. Valid values for format are BASIC, TYPICAL, and ALL, which offer increasing levels of information, and SERIAL, which excludes information about the parallelism of the plan.