I am a situation where i have one query, that :
- in SQL*Plus does not have recost activity,
- through my application (Pro*C) does have that recosting (shown in 10053 trace : recost for ORDER BY).

The first one performs well, whereas the after degrades performance.

Any idea ? How can i saw NO RECOST or something like that ?