Older Versions

'PLAN_TABLE' CREATION

@$ORACLE_HOME/rdbms/admin/xplainpl.sql

@$ORACLE_HOME/rdbms/admin/utlxplan.sql

Generating Execution Plan

EXPLAIN PLAN

SET statement_id = 'TEST'

FOR

  SELECT myinteger

    FROM mytable

   WHERE myvarchar = 'MIKE';

Viewing Execution Plan

SELECT LPAD(' ',2*LEVEL)||operation||' '||options||' '||object_name q_plan

  FROM plan_table

 WHERE statement_id = 'TEST'

CONNECT BY PRIOR id=parent_id

             AND statement_id = 'TEST'

      START WITH id=1;