Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id h241ZNu10855
 for <oracle-l@orafaq.net>; Mon, 3 Mar 2003 19:35:23 -0600
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h241ZN310850
 for <oracle-l@orafaq.net>; Mon, 3 Mar 2003 19:35:23 -0600
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA41321;
 Mon, 3 Mar 2003 14:12:29 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0055EF7C; Mon, 03 Mar 2003 13:54:09 -0800
Message-ID: <F001.0055EF7C.20030303135409@fatcity.com>
Date: Mon, 03 Mar 2003 13:54:09 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: <Govind.Arumugam@alltel.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: <Govind.Arumugam@alltel.com>
Subject: Oracle 9.2.0.2 bugs
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/alternative;	boundary="----_=_NextPart_001_01C2E1CF.58CAF5AA"
------_=_NextPart_001_01C2E1CF.58CAF5AA
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

List,
=20
We recently upgraded our Production system to 9i and got burnt by these =
bugs.
=20
Installed Patch List:
2785282 [ Base Bug(s): 2442125 ]=20
=20
Bug # 2808431 WRONG RESULTS FOR PARALLEL QUERY WITH HASH AND INDEX JOIN

Bug # 2783229 Base bug : 2442125 INCORRECT DATA RETURNED FROM DATABASE =
WHEN QUERIED FROM PROC
=20
I would greatly appreciate if we can share among ourselves the various =
bugs noted in 9i along with possible fixes. =20
=20
Our version info.
=20
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.0.2.0 - Production

Sun Solaris 2.8
=20
TIA,
Govind

------_=_NextPart_001_01C2E1CF.58CAF5AA
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE></TITLE>

<META content=3D"MSHTML 5.50.4915.500" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003>List,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D531513621-03032003>We=20
recently upgraded our Production system to 9i and got&nbsp;burnt by =
these=20
bugs.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT size=3D2><FONT color=3D#0000ff>Installed =
Patch=20
List:<BR>2785282 [ Base Bug(s): 2442125 ]<SPAN=20
class=3D531513621-03032003>&nbsp;</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><SPAN class=3D531513621-03032003><FONT face=3DArial><FONT =
color=3D#0000ff=20
size=3D2>Bug # 2808431&nbsp;WRONG RESULTS FOR PARALLEL QUERY WITH HASH =
AND INDEX=20
JOIN<BR></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D531513621-03032003><FONT face=3DArial><FONT =
color=3D#0000ff=20
size=3D2>Bug # 2783229 Base bug : 2442125 INCORRECT DATA RETURNED FROM =
DATABASE=20
WHEN QUERIED FROM PROC</FONT></FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D531513621-03032003>I=20
would greatly appreciate if we can share among ourselves the various =
bugs noted=20
in 9i along with&nbsp;possible fixes.&nbsp; </SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><SPAN class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D531513621-03032003>Our=20
version info.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003>Oracle9i Enterprise Edition Release 9.2.0.2.0 =
- 64bit=20
Production<BR>With the Partitioning and Real Application Clusters=20
options<BR>JServer Release 9.2.0.2.0 - =
Production<BR></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D531513621-03032003>Sun=20
Solaris 2.8</DIV></SPAN></FONT>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003>&nbsp;</DIV></SPAN></FONT>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003>TIA,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D531513621-03032003>Govind</SPAN></FONT></DIV></BODY></HTML>

------_=_NextPart_001_01C2E1CF.58CAF5AA--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Govind.Arumugam@alltel.com
  INET: Govind.Arumugam@alltel.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@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).

