Re: Completly different execution plans select vs. update with same where clause
- From: Michael Seiwert <mseiwert@xxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 29 Mar 2008 14:57:07 +0100
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@xxxxxxxxxxxx>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
