Re: ((Re)): Really Wierd Query tuning issue
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Aug 2004 15:44:57 +0300
> What does the 10046 trace use to get the explain plan? I thought it used
the same stuff as autotrace? I had thought that only 'explain plan for'
could be inaccurate?
10046 trace (also KST trace) is the ultimate source for information, since
it is a trace - the actual operations are logged instead of simulated or
replayed in possibly different environment like with explain plan and
autotrace (yes, autotrace uses explain plan)
So, trust 10046 and forget about explain plan, this is mostly for
development & experimental environments...
Tanel.
----------------------------------------------------------------
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:
