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" <[EMAIL PROTECTED]>
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>
<P><FONT SIZE=2>Ethan,</FONT>
</P>
<P><FONT SIZE=2>I am *shocked* we are running RAC 9202 ...</FONT>
<BR><FONT SIZE=2>I haven't seen anomalies ... does your friend have any
example?</FONT>
</P>
<P><FONT SIZE=2>Raj</FONT>
<BR><FONT
SIZE=2>-------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Rajendra dot Jamadagni at espn dot com</FONT>
<BR><FONT SIZE=2>Any views expressed here are strictly personal.</FONT>
<BR><FONT SIZE=2>QOTD: Any clod can have facts, having an opinion is an art
!!</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Post, Ethan [<A
HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, March 05, 2003 11:35 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: How Reliable is Explain Plan in 9.2</FONT>
</P>
<BR>
<P><FONT SIZE=2>Just had a fellow tell me that explain plan in completely
unreliable in 9.2</FONT>
<BR><FONT SIZE=2>and getting accurate results requires direct SGA access on
executing SQL (he</FONT>
<BR><FONT SIZE=2>is working in a RAC environment). They are running
Precise, a good product,</FONT>
<BR><FONT SIZE=2>but this sounds like something a sales person told him. I
can only recall</FONT>
<BR><FONT SIZE=2>that occasionally the plan executed is not the plan you see in
explain plan.</FONT>
<BR><FONT SIZE=2>Anyone know the truth of this issue?</FONT>
</P>
<P><FONT SIZE=2>- Ethan </FONT>
</P>
</BODY>
</HTML>
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
