James's Blog

Oracle Plan Table

use UTLXPLAN.SQL to create PLAN_TABLE
use UTLXPLS.SQL to generate report.
use command "explain plan for my-sql-statement"
or "explain plan into table_name for my-sql-statement" to generate execution plan

The fields (attributes) within the plan table
- the most important fields with in plan table are:
operation, option, object_name, id and parent_id

select substr (lpad(' ', level-1) operation ' (' options ')',1,30 ) "Operation", object_name "Object"
from plan_table
start with id = 0
connect by prior id=parent_id;

posted by James Pei @ 4:30 PM