EXPLAIN PLAN
EXPLAIN PLAN SET STATEMENT_ID = 'text
' [INTO [schema
.]table_name
[@dblink
]] FORsql_statement
Creates an explanation of the execution plan for a SQL statement.
Specifies a text string (`text ') to be used to identify the result of this EXPLAIN PLAN statement. The default is NULL.
Specifies the location of the PLAN_TABLE (table_name). If you omit schema, the default is a PLAN_TABLE in your own schema. Specify @dblink to indicate a remote database.
Specifies the SQL statement for which the plan is to be generated.
You must have the INSERT privilege on the destination table (specified by INTO) before issuing this command. The destination table is usually called PLAN_TABLE, and can be created by running the script utlxplan.sql. The value specified in the SET clause will appear in the STATEMENT_ID column of the destination table.