Hi

Can you please collect stats on all the tables using dbms_stats and then post the plan here without any changes to the sql and without any hints.

regards
Hrishy