December 2002
Intermediate to advanced
928 pages
85h 29m
English
You can execute the EXPLAIN PLAN statement using the following syntax:
EXPLAIN PLAN [SET STATEMENT_ID = 'id_label'] [INTO [schema.]table[@dblink]] FORstatement
The STATEMENT_ID clause can be used to identify the plan for a particular statement. The INTO clause can target a table other than the PLAN_TABLE for storage of the plan information; that table must exist before you issue this command. statement is the SQL statement to be explained.
To display execution plans, you can create your own SQL statement on the PLAN_TABLE table or use the script UTLXPLS.SQL, for serial execution, or UTLXPLP.SQL, for parallel execution.