Oracle-L: Re:RE: How Reliable is Explain Plan in 9.2

From: <dgoulet_at_vicr.com>
Date: Wed, 05 Mar 2003 10:39:17 -0800
Message-ID: <F001.00560FF3.20030305103917@fatcity.com>

Ethan,

Seeing as your friend is running Precise & I have heard similar pronouncements from them about the "accurracy" of explain plan for several versions of Oracle I'm not suprised. True, they make a very nice product, but them again explain plan is something they do themselves. Yup, sounds like a sales droid got to him.

Dick Goulet

____________________Reply Separator____________________
Author: "Jamadagni; Rajendra" <Rajendra.Jamadagni_at_espn.com>
Date:       3/5/2003 9:59 AM

Ethan,

I am *shocked* we are running RAC 9202 ... I haven't seen anomalies ... does your friend have any example?

Raj

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
Sent: Wednesday, March 05, 2003 11:35 AM To: Multiple recipients of list ORACLE-L

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: How Reliable is Explain Plan in 9.2</TITLE>
</HEAD>
<BODY>

Ethan,


I am *shocked* we are running RAC 9202 ...
 I haven't seen anomalies ... does your friend have any
example?


Raj
 <FONT

SIZE=2>-------------------------------------------------------------</FONT>


<BR><FONT SIZE=2>Rajendra dot Jamadagni at espn dot com</FONT>

 Any views expressed here are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art
!!

 

-----Original Message-----
 From: Post, Ethan [<A

HREF="mailto:Ethan.Post_at_ps.net">mailto:Ethan.Post_at_ps.net</A>]
 Sent: Wednesday, March 05, 2003 11:35 AM
 To: Multiple recipients of list ORACLE-L
 Subject: How Reliable is Explain Plan in 9.2

 

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 


</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: dgoulet_at_vicr.com

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



text/basic attachment: MS-DOS text file

Received on Wed Mar 05 2003 - 12:39:17 CST