COLUMN OBJECT_OWNER FORMAT A20
COLUMN OBJECT_NAME FORMAT A20
COLUMN ACCESS_PREDICATES FORMAT A20
COLUMN FILTER_PREDICATES FORMAT A20
COLUMN OPS FORMAT A30
COLUMN OPTIMIZER FORMAT A10
COLUMN CHILD# FORMAT 9999


SELECT CHILD_NUMBER CHILD#, LPAD(' ',6*DEPTH)||OPERATION|| '-' ||OPTIONS OPS, OBJECT_OWNER, OBJECT_NAME,OPTIMIZER,COST,CARDINALITY, CPU_COST,
       IO_COST, ACCESS_PREDICATES,FILTER_PREDICATES
FROM V$SQL_PLAN
WHERE HASH_VALUE = &1
ORDER BY CHILD_NUMBER DESC
/
