; Sent: Monday, October 14, 2002 1:32 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Interpretation of TKPROF output
>
>
> Actually two things can cause differences between tkprof output and
> "explain plan" output:
>
> 1. Schema changes between when the
Actually two things can cause differences between tkprof output and
"explain plan" output:
1. Schema changes between when the trace output was collected and when
the tkprof was executed.
2. tkprof bugs. Tkprof often produces incorrect execution plans from the
STAT lines in the trace file. You ca
IL PROTECTED]>
hgrum.com> cc:
Sent by: Subject: Interpretation of TKPROF
output
Peter,
"Row Source Operation" is what Oracle actually did, or, at least what
was recorded in the trace file. "Execution Plan" is what TkProf did in
response to you specifying "explain=" option. They can differ if things
changed from the time the trace was done to the time the explain was
execut
Hello;
Somebody knows how to connect to a Oracle DB,
In a Solaris 8 Server, and insert data
With Visual Basic, through internet?
Thank you.
Francisco Murillo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Francisco Murillo Montoya
INET: [EMAIL PROTECTED]
Fat Cit
I am running tkprof on some trace files with the following options:
(Oracle 8.1.7)
explain=/ sort=exeqry,fchqry,execu,fchcu
Output after each query includes the following two tables:
Rows Row Source Operation
--- ---
36 INLIST ITERA