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 -----------------------------------------------------------------