Re: Slow UPDATE
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 May 2004 09:23:32 -0700
In Thomas' original post, he included the tkprof explain plan, but not the
Row Source Operation. The explain plan claims that the unique key is being
used, but the wait events show clearly that full scans are occurring.
The Row Source Operation info is the one to rely on to determine what
actually happened during the trace.
--Terry
----- Original Message -----
From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, May 18, 2004 8:30 AM
Subject: RE: Slow UPDATE
Note that regardless of whether the EXPLAIN=3D option is passed to
tkprof, the execution plan from the STAT lines in the tracefile
will be reported under "Row Source Operation" in the tkprof=20
output. If EXPLAIN=3D option is specified, then in addition to
"Row Source Operation", you'll have "Execution Plan" followed
by the explain plan that was executed at tkprof runtime, using
the userid/password specified.
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tanel P=F5der
Sent: Tuesday, May 18, 2004 11:12 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Slow UPDATE
But if you don't specify EXPLAIN=3D option then tkprof will read the
execution plans directly from STAT lines in the tracefile.=20
...some stuff deleted....
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
