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 --- [EMAIL PROTECTED] 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@vcom To: > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > merce.com> cc: > > > Sent by: Subject: > v8.1.7.0.0 - Just go ahead and shoot me - What now > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] ___________________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
