rem   
rem   Dan Hotka Pinnacle Professional article
rem   Show_Plan.sql   - used to print contents from Plan_Table
rem
rem   Install utlxplan.sql for each user, then put this line in front of sql statement
rem   --> explain plan  for <SQL statement>
rem   -->  run this script --> sqlplus userid/pwd @show_plan <some name>
rem
set pagesize 20
set linesize 80
column id format 999 heading 'ID'
column parent_id format 999 heading 'P_ID'
column cost format 999 heading 'Cost'
column access_plan format a30 heading 'Access|Plan'
column access_path format a15 heading 'Access|Path'
column object_name format a15 heading 'Object|Name'
select cost,id, parent_id, lpad (' ', 2 * level) || operation Access_Plan, options Access_Path,
object_name 
from plan_table
connect by prior id = parent_id
start with id = 0; 
delete from plan_table;