We're using star transformation and bitmap indexes.
We're on 81600 64bit/solaris 5.7 and there is a bug I
can live with if I put timed_statistics to false. So
I'm ok for now.
According to your experience, which 8.1.7.x version
have the less bugs related to star transformation,
bitmap indexes, ...?
Stephane
- Cherie_Machler_at_gelco.com a écrit : >
> Brian,
>
> Are you using partitioned tables and star
> transformation?
>
> We had lots of bugs when testing the upgrade from
> 8.0.4 to 8.1.5.
> On Oracle support's recommendation we upgraded to
> 8.1.6. It
> fixed our bug but we found several more and they
> recommended
> we go to 8.1.7. We did so and that fixed those
> bugs but now we
> had more. They insisted that we go to 8.1.7.1. We
> did. Just
> as before, it fixed our problem but there were more.
> The problem
> we had was fixed in 9i but we had to wait almost
> four months for them
> to create a one-off patch for us. And when they
> did, it was against
> 8.1.7.2,
> not 8.1.7.1. So we had to apply the 8.1.7.2
> patchset before we could
> apply
> the one-off patch.
>
> Doing so fixed our bugs and we do not currently have
> any new ones, although
> the QA group has not yet put the application through
> rigorous testing.
>
> Our experience has been that you don't have a leg to
> stand on for new
> bug support if you are not on the absolute latest
> release and patch set.
> What a pain.
>
> Now we are working on trying to get all our
> databases (~60) up to 8.1.7.2.
> That's a log of work.
>
> By the way, we are on Sun Solaris 2.6 (32-bit) and
> this was a data
> warehouse
> application which made strong use of star querie
> design, bit-mapped
> indexes,
> and partitions.
>
> HTH,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
>
> Brian MacLean
>
>
> <bmaclean_at_vcom To:
> Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> merce.com> cc:
>
>
> Sent by: Subject:
> v8.1.7.0.0 - Just go ahead and shoot me - What now
>
> root_at_fatcity.c v8.1.7.1.0
> or
>
> om
>
>
>
>
>
>
>
>
> 08/03/01 12:56
>
>
> PM
>
>
> Please respond
>
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
>
> We are currently Solaris 2.6 105181-26 & Oracle
> v8.1.7.0.0.
>
>
> We recently upgraded from v8.1.6.0.0 to v8.1.7.0.0
> on the advise of Oracle
> support in order to fix several bugs we were
> encountering. To make a long
> story short, we hit 3 new very troublesome bugs
> within the first week and
> are now just limping along.
>
>
> Oracle support is now recommending we upgrade to
> v8.1.7.1.0 to fix all
> three bugs. Yeah, Right.
>
>
> Now that v8.1.7.2.0 is available and the bug fix
> report is as long or
> longer that the v8.1.7.1.0 list (see metalink Doc#
> 120613.1) we have to ask
> ourselves, "Do ya feel luck"?
>
>
> So the question is which patch set fixes more while
> at the same time breaks
> less? Or should we just limp along until v8.1.7.3 in
> January 2002?
>
>
> TIA
>
>
> Brian
>
>
>
>
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Vos albums photos en ligne,
Yahoo! Photos :
http://fr.photos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Mon Aug 06 2001 - 02:38:51 CDT