Re: Oracle 8.0.5

From: Tom Pall <tom_at_cdproc.com>
Date: Wed, 13 Sep 2000 17:54:59 -0500
Message-Id: <10618.116912@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_012A_01C01DAB.BBBD91B0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

RE: Oracle 8.0.5Your bugs may vary, but mine revolve around:

"Database xyz does not support function abc in this context" when doing = a distributed
(dblink) query in two 8.1.6 databases when running in CBO. These are = queries created by
Discoverer, over which we have no control. Running in CBO is a real = drag. Of course it's fixed
in 8.1.7.

Ora-600 when accessing partitioned tables with one or more empty = partitions and statistics.
Ora-600 on partitioned tables which aren't empty but have statistics.

These are both fix in Oracle 8.1.7.

You betcha!

Original Message -----=20 From: Alex Hillman=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, September 12, 2000 12:34 PM Subject: RE: Oracle 8.0.5

Could you please give some examples of bugs that you encountered.=20

Alex Hillman=20

-----Original Message-----=20
From: Tom Pall [mailto:tom_at_cdproc.com]=20 Sent: Monday, September 11, 2000 5:41 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Re: Oracle 8.0.5=20

If you upgrade to 8, then upgrade to 8.0.6. It's supported, for now.=20

The best I've heard about Oracle 8i is that it is no buggier than = Oracle 8.=20
Of course it's got a bunch more features and those have bugs in them.=20

I do not have any money making databases running at 8.1.6 yet, as I am =

  using 8.1.6 for reporting and non-critical databases, just to get my = feet wet.=20
  I'm eagerly awaiting 8.1.7, as the bugs in 8.1.6 which prevent me from = running=20
  in CBO are slated to be fixed in 8.1.7.=20

  We're a two DBA company and we average opening up two TARs a week,=20   all on problems with 8.1.6. Because of this, my production databases = are *NOT*=20
  going to 8.1.6 anytime soon. If we are forced to upgrade by Oracle = Support,=20
  we'll upgrade production databases to 8.0.6 until the glaring problems = we face=20
  in 8.1.6 are fixed, at least.=20

Original Message -----=20 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>=20 Sent: Monday, September 11, 2000 10:03 AM=20

> We have a mission-critical app running on RDBMS:7.3.2.3 AIX: 4.2.1 =20
>=20
> Our vendor has sent us a proposal to upgrade the RDBMS to 8.0.5. I =
know there=20
> are releases beyond this (e.g. 8.0.5.x, 8.0.6.x, 8.1.x). But after =
searching=20
> Metalink it is not clear to me that higher releases are any more =
bug-free than=20
> 8.0.5. While higher releases fix 8.0.5 bugs, they seem to introduce =
additional=20
> bugs. Therefore instead of going to the highest release, my optimal =
strategy=20
> (keep in this mind this app is mission-critical) should be to go to =
the lowest=20
> release since in those releases Oracle Tech Support will have had =
the most=20
> time/experience in fixing known problems.=20
>=20
> Any comments on 8.0.5 vs. higher versions? Comments on my upgrade =
strategy?=20

  >=20

> tia,=20

  >=20

> ..tom=20

  >=20
  >=20
  >=20
  >=20
  >=20

> --=20
> Author:=20
> INET: blair_at_pjm.com=20

  >=20


  > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051=20

  > San Diego, California        -- Public Internet access / Mailing =

Lists=20


  > -------------------------------------------------------------------- =

> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from). You may=20
> also send the HELP command for other information (like subscribing). =

  --=20
  Author: Tom Pall=20
    INET: tom_at_cdproc.com=20

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing Lists =

  --------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------=_NextPart_000_012A_01C01DAB.BBBD91B0 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><TITLE>RE: Oracle 8.0.5</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Your bugs may vary, but mine revolve =

around:</DIV>
<DIV> </DIV>
<DIV>"Database xyz does not support function abc in this = context"=20
when doing a distributed</DIV>
<DIV>(dblink) query in two 8.1.6 databases when running = in=20
CBO.  These are queries created by</DIV> <DIV>Discoverer, over which we have no control.  = Running in=20
CBO is a real drag.  Of course it's fixed</DIV>

<DIV><FONT size=3D2>in 8.1.7.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>Ora-600 when accessing partitioned tables with one =

or more=20
empty partitions and statistics.</DIV> <DIV>Ora-600 on partitioned tables which aren't empty but = have=20
statistics.</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>These are both fix in Oracle 8.1.7.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>You betcha!</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:alex_hillman_at_physia.com" = title=3Dalex_hillman_at_physia.com>Alex=20
 Hillman</A> </DIV>
 <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Tuesday, September 12, = 2000 12:34=20
 PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Oracle 8.0.5</DIV>
  <DIV><BR></DIV>
  <P><FONT size=3D2>Could you please give some examples of bugs that you =

encountered. 
 Alex Hillman -----Original Message----- From: Tom=20
 Pall [<A =
href=3D"mailto:tom_at_cdproc.com">mailto:tom_at_cdproc.com</A>]=20 Sent: Monday, September 11, 2000 5:41 PM = <FONT=20
 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>Subject: Re: Oracle 8.0.5 If you upgrade to 8, then upgrade to 8.0.6.  = It's=20
 supported, for now. 
 The best I've heard about Oracle 8i is that it is no = buggier=20
 than Oracle 8. Of course it's got a bunch = more=20
 features and those have bugs in them. I do not have any money making databases running at = 8.1.6 yet,=20
 as I am using 8.1.6 for reporting and = non-critical=20
 databases, just to get my feet wet. I'm = eagerly=20
 awaiting 8.1.7, as the bugs in 8.1.6 which prevent me from = running=20
 in CBO are slated to be fixed in 8.1.7. We're a two DBA company and we average opening up = two TARs a=20
 week, all on problems with 8.1.6.  = Because of=20
 this, my production databases are *NOT* going to 8.1.6=20
 anytime soon.  If we are forced to upgrade by Oracle = Support,=20
 we'll upgrade production databases to 8.0.6 until = the glaring=20
 problems we face in 8.1.6 are fixed, at = least.=20
 ----- Original Message ----- To:=20
 Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com>=20
 Sent: Monday, September 11, 2000 10:03 AM = 
 > We have a mission-critical app running on = RDBMS:7.3.2.3=20
 AIX: 4.2.1  > > Our=20
 vendor has sent us a proposal to upgrade the RDBMS to 8.0.5.  I = know=20
 there > are releases beyond this (e.g. = 8.0.5.x,=20
 8.0.6.x, 8.1.x).  But after searching >=20
 Metalink it is not clear to me that higher releases are any more = bug-free=20
 than > 8.0.5.  While higher releases = fix 8.0.5=20
 bugs, they seem to introduce additional > =

bugs.  Therefore instead of going to the highest release, my = optimal=20
strategy > (keep in this mind this app is =

mission-critical) should be to go to the lowest >=20
 release since in those releases Oracle Tech Support will have had the=20 most > time/experience in fixing known=20 problems. > > Any=20
 comments on 8.0.5 vs. higher versions?  Comments on my upgrade=20 strategy? > >=20
 tia, > > = ..tom=20
 > > = <FONT=20
 size=3D2>> > >=20
 > -- > = Author:=20
 >   INET: blair_at_pjm.com = <FONT=20
 size=3D2>> > Fat City Network=20 Services    -- (858) 538-5051  FAX: (858) = 538-5051=20
 > San Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists >=20 =

--------------------------------------------------------------------</FON=

T>=20
 > To REMOVE yourself from this mailing list, = send an=20
 E-Mail message > to: ListGuru_at_fatcity.com = (note=20
 EXACT spelling of 'ListGuru') and in > = the message=20
 BODY, include a line containing: UNSUB ORACLE-L >=20
 (or the name of mailing list you want to be removed from).  You=20 may > also send the HELP command for = other=20
 information (like subscribing). -- Author: Tom Pall = <FONT=20
 size=3D2>  INET: tom_at_cdproc.com Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note EXACT = spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = Received on Wed Sep 13 2000 - 17:54:59 CDT