Re: Auto trace is giving wrong plan.

On 22 Jan 2006 05:16:58 -0800, "Jagjeet Singh" <jagjeet.malhi_at_gmail.com> wrote:

>Hi Friends,
>
>Hi,
>
>
>
>In this case "set autot on" is telling false plan with binding.
>
>
>
>Can you put some light on this ...
>

No, not really, as you didn't include one tiny little thingy, called the version (that string consisting of 4 digits and three dots), as this might be a 'feature' of a specific version (in which case Metaclack would also be a better source). The only recommendation right now is to use event 10053, to have the CBO dump information about it's decisions to a trace file. alter session set event='10053, trace name context forever, level 1' It looks like there is some sort of implict conversion (ie the bind variable is treated as a varchar2).
You could also try to see what happens if you wrap the :n variable in a to_number.

Could you please tidy up the trace file prior to posting? Currently it is quite hard to read, as there is text all over the place.

--
Sybrand Bakker, Senior Oracle DBA