Explain Plan

rem
-----------------------------------------------------------------------
rem Filename: x_plan.sqlrem Purpose: Explain SQL Execution plan
rem Date: 12-Apr-1998r
em Author: Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------
DELETE FROM plan_table WHERE statement_id = 'XXX';COMMIT;
EXPLAIN PLAN SET STATEMENT_ID = 'XXX'
FOR
my sql
/
-- Oracle 9.2 and above:
set linesize 132
SELECT * FROM TABLE(dbms_xplan.DISPLAY('PLAN_TABLE','XXX'));
set doc off