Diff betn exec plan in appl and sqlplus

[jmodic]

I turned on tracing (10046) for that session and obtained the bind variable values for the query. Plugged these values into the query and ran it from sqlplus.

What do you mean by that exactly? Did you actually replaced the occurancess of bind variables in the query with their litteral values?

If you turned the original query that was something like that:

select * from emp where ename = :1;

into something like that (by replacing a bind with a litteral value):

select * from emp where ename = 'SCOTT';

then those two queries are totaly different things for the optimizer.

Or did you define a variable in SQL*Plus, assign it a value and run your query?