I may guess that the explain plan in sqlplus differs from the tkprof which tells correct execution plan.
You can post the tkprof output here.

Also, post the statspack report.

Tamil