Re: Explain plan in trace file

Which version of DB are you using?

Starting from 8.1.7 I think, the exec plan is put to trace automatically. And when you tkprof *without* explain command, the exec plan is taken from .trc file.

Also, if you're on 9i, v$sql_plan view might interest you..

Tanel.

"Miha" <miha.znidarsic_at_ixtlan-team.si> wrote in message news:8c69a0da.0303040434.3b52c82e_at_posting.google.com...
> Hello.
>
> Does anybody know how order Oracle to put explain plan in trace file
> when trace file is generated.
>
> Problem is bc we are using Row Level Security and explain plan can
> change depending on application settings, so if we transform trace
> file with tkprof using "explain" option, we may get different explain
> plan than one realy used when sql was executed.
>
> In this moment some sql have explain plan already in trace file and
> some others not.
>
> Thank you for any advice.
> Greetings from Slovenia
Received on Tue Mar 04 2003 - 08:07:27 CST