RE: tkprof & explain question
- From: amit.poddar@xxxxxxxx
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Sat, 21 May 2005 15:06:46 -0400
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@xxxxxxxxxxxx>:
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
