RE: tkprof & explain question

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <breitliw@xxxxxxxxxxxxx>, <amit.poddar@xxxxxxxx>
  • Date: Sat, 21 May 2005 20:14:22 +0200


>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


>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

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.


Other related posts: