Re: Completly different execution plans select vs. update with same where clause

From: Michael Seiwert <mseiwert_at_hbv.de>
Date: Sat, 29 Mar 2008 14:57:07 +0100
Message-Id: <200803291457.07956.mseiwert@hbv.de>


Hi all,

I'm having problems posting the 10046 & 10053 tracefiles to the list, so anyone interessed in this tracefiles please drop me a mail and I'll send you the traces. Does anyone have another idea where to upload the traces ?

Best,
Michael

Am Donnerstag, 27. März 2008 17:19:56 schrieb Jared Still:
> In addition you may want to execute the statements, then use v$sql_plan
> or a 10046 trace to get the execution plan that was used to execute the
> statement.
>
> 'explain plan' does not always provide that actual plan used.
>
>
> On Thu, Mar 27, 2008 at 8:03 AM, Bobak, Mark <Mark.Bobak_at_proquest.com>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Mar 29 2008 - 08:57:07 CDT

Original text of this message