Re: How Reliable is Explain Plan in 9.2

I haven't seen any problems yet.
On the contrary - there are facilities
in the EXPLAIN PLAN which are not
available through v$sql_plan , such
as recursive SQL for subquery
factoring, and a couple of columns
(but I can't remember which ones
at the moment).

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____UK_______April 8th
____UK_______April 22nd

____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 05 March 2003 16:35

> Just had a fellow tell me that explain plan in completely unreliable
in 9.2
> and getting accurate results requires direct SGA access on executing
SQL (he
> is working in a RAC environment). They are running Precise, a good
product,
> but this sounds like something a sales person told him. I can only
recall
> that occasionally the plan executed is not the plan you see in
explain plan.
> Anyone know the truth of this issue?
>
> - Ethan

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).