1) Generate the execution Plan

explain plan set statement_id='ID1' for Select ....

2) Get the execution Plan providing the same statement_id when prompted for

SET VERIFY OFF
SET PAGESIZE 100
set lines 130

ACCEPT stmt_id CHAR PROMPT "Enter statement_id: "

COL id FORMAT 999
COL parent_id FORMAT 999 HEADING "PARENT"
COL operation FORMAT a35 TRUNCATE
COL object_name FORMAT a30
COL cost FORMAT 999

SELECT distinct id, parent_id, LPAD (' ', LEVEL - 1) || operation || ' ' ||
options operation, object_name,cost
FROM plan_table
WHERE statement_id = '&stmt_id'
START WITH id = 0
AND statement_id = '&stmt_id'
CONNECT BY PRIOR
id = parent_id
AND statement_id = '&stmt_id' order by id;

CLEAR COLUMNS