Okay, 2 things.

1) I can't tell if you are selecting the plan in the correct order or not. Just in case, run a query that looks like:

SELECT
---LPAD('-',3*(LEVEL-1))||PT.OPERATION||' '||PT.OPTIONS||' '||PT.OBJECT_NAME AS FormattedText,
---PT.COST, PT.CARDINALITY, PT.BYTES
FROM
---PLAN_TABLE PT
START WITH
---ID = 0 AND
---STATEMENT_ID = 'WHATEVER'
CONNECT BY
---PRIOR ID = PARENT_ID AND
---STATEMENT_ID = 'WHATEVER'

to get the output. KEEP the daashes, as everything is left-justified in this forum - spaces are eliminated.

Then we'll have a better shot at reading the plan


2) Include the original statement. Kind of hard to pick apart a plan in isolation. With the statement, at least we have a shot to see what you might be doing.

- Chris