SQL_PLAN.sql for checking real execution plan

set lines 132

set pages 1400

SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position)

“Query Plan”

FROM v$sql_plan

START WITH id = 0 and sql_id=’4ftvbpzhwkfd8′ and child_number=0

CONNECT BY PRIOR id = parent_id and sql_id=’4ftvbpzhwkfd8′ and child_number=0;