Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C83369.5643772A"
Subject: RE: _gby_hash_aggregation_enabled=false
Date: Fri, 30 Nov 2007 08:54:48 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450987F652@NT15.oneneck.corp>
In-Reply-To: <486b2b610711300021h68d062f6kb00974dfbacc5a85@mail.gmail.com>
Thread-Topic: _gby_hash_aggregation_enabled=false
Priority: normal
References: <04DDF147ED3A0D42B48A48A18D574C450987F2E1@NT15.oneneck.corp> <486b2b610711300021h68d062f6kb00974dfbacc5a85@mail.gmail.com>
From: "Allen, Brandon" <Brandon.Allen@OneNeck.com>
To: "Stefan Knecht" <knecht.stefan@gmail.com>,
 "oracle-l" <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Brandon.Allen@OneNeck.com
------_=_NextPart_001_01C83369.5643772A
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thanks, but in my case, there isn't any specific query that I know of
currently having problems - I just want to disable this feature
proactively since it is known to return the wrong results in some cases.
With most bugs, I don't tend to take proactive action if we haven't
encountered them, however with these "wrong results" bugs I think you
have to take a more proactive approach since you could be encountering
them for a while and not even know it.  In this case, as I understand
it, the results simply come out with missing values from the aggregated
total so, for example - you could have a sales order with ten $100 line
items and instead of totaling $1000, it might come out to something
short of that.  This could go on for a long time before someone noticed
it.  You'd probably have some happy customers, but not such happy
finance folks :-)

________________________________

From: Stefan Knecht [mailto:knecht.stefan@gmail.com]=20

I don't remember the name of the hint off hands, but AFAIK there is one
that lets you set the optimizer features enabled per statement.


Privileged/Confidential Information may be contained in this message or =
attachments hereto. Please advise immediately if you or your employer do =
not consent to Internet email for messages of this kind. Opinions, =
conclusions and other information in this message that do not relate to =
the official business of this company shall be understood as neither =
given nor endorsed by it.


------_=_NextPart_001_01C83369.5643772A
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16544" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D788574915-30112007><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Thanks, but in my case, there isn't any =
specific query that=20
I know of currently having problems - I just want to disable this =
feature=20
proactively since it is known to return the wrong results in some =
cases.&nbsp;=20
With most bugs, I don't tend to take proactive action if we haven't =
encountered=20
them, however with these "wrong results" bugs I think you have to=20
take&nbsp;a&nbsp;more proactive&nbsp;approach since you could be =
encountering=20
them for a while and not even know it.&nbsp; In this case, as I =
understand it,=20
the results simply come out with missing values from the aggregated =
total so,=20
for example - you could have a sales order with ten $100 line items and =
instead=20
of totaling $1000, it might come out to something short of that.&nbsp; =
This=20
could go on for a long time before someone noticed it.&nbsp; You'd =
probably have=20
some happy customers, but not such happy finance folks=20
:-)</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Stefan Knecht=20
[mailto:knecht.stefan@gmail.com] </FONT><BR><BR>I don't remember the =
name of the=20
hint off hands, but AFAIK there is one that lets you set the optimizer =
features=20
enabled per =
statement.<BR><BR></DIV></BODY><!--[object_id=3D#oneneck.com#]--><FONT =
face=3DTahoma size=3D2><FONT color=3D#0000ff>
<P>Privileged/Confidential Information may be contained in this message =
or attachments hereto. Please advise immediately if you or your employer =
do not consent to Internet email for messages of this kind. Opinions, =
conclusions and other information in this message that do not relate to =
the official business of this company shall be understood as neither =
given nor endorsed by it.</P></FONT></FONT></HTML>

------_=_NextPart_001_01C83369.5643772A--
--
http://www.freelists.org/webpage/oracle-l