RE: tkprof & explain question

Wolfgang

>However, unless you are dealing with traces=20
>of Oracle 7 systems, there should be no need=20
>to use the explain option on tkprof. The=20
>trace already contains the execution plan=20
>in the form of STAT lines and tkprof will=20
>format them.=20

Amit

>But why do you need to run it with explain
>parameter. The actual plan used would be=20
>present in tkprof as row source operations=20
>anyway

If Jaffar is working on a system where the=20 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