Name

EXPLAIN PLAN

Synopsis

EXPLAIN PLAN
SET STATEMENT_ID = 'text'
[INTO [schema.]table_name[@dblink]]
FOR SQL_statement

Creates an explanation of the execution plan for a SQL statement.

You must have 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 appears in the STATEMENT_ID column of the destination table

Keywords

SET STATEMENT_ID

Specifies a text string used to identify the result of this EXPLAIN PLAN statement. The default is NULL.

INTO

Specifies the name and location of the plan table. The default is to use a table named PLAN_TABLE in your current schema.

FOR

Specifies the SQL statement for which the plan is to be generated.

Common keywords and clauses: dblink, schema, table_name.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial