set pages 300
set lines 100
truncate table plan_table;
EXPLAIN PLAN
SET STATEMENT_ID = ‘pvm’ FOR
SELECT * FROM emp;
SELECT rpad(cardinality, 10, ‘ ‘) || ‘ ‘ || rpad(cost, 10, ‘ ‘) || ‘ ‘ ||
lpad(‘ ‘,level-1)||operation||’ ‘|| options||’ ‘||object_name “Rows Cost Plan”
FROM PLAN_TABLE
CONNECT BY prior id = parent_id
AND prior statement_id = statement_id
START WITH id = 0
AND statement_id = ‘pvm’
ORDER BY id;