RE: tkprof & explain question

Agreed

But there is no guarantee that
the plan showed in explain plan (by using explain=<>) was really used by the process.

amit

Quoting Christian Antognini <Christian.Antognini_at_trivadis.com>:

> Wolfgang
>
> >However, unless you are dealing with traces
> >of Oracle 7 systems, there should be no need
> >to use the explain option on tkprof. The
> >trace already contains the execution plan
> >in the form of STAT lines and tkprof will
> >format them.
>
> Amit
>
> >But why do you need to run it with explain
> >parameter. The actual plan used would be
> >present in tkprof as row source operations
> >anyway
>
> If Jaffar is working on a system where the
> cursors are "never" closed, the STAT line
> will not be in the tracefile. Thus the
> parameter explain could be interesting.
>
> If it's not the case, I agree with you.
>
>
> Regards,
> Chris
>

--
http://www.freelists.org/webpage/oracle-l