Re: Oracle 7.3 bugs

Brad Skiles wrote:
>
> I accidentally marked the thread concerning 7.3 bugs as "read", but I
> wanted to post our experiences running 7.3.2.3 on HP-UX 10.20. We've
> encountered approximately 5 bugs since the upgrade. All of them occured
> after we tried to implement bitmap indexes. We've received 4 patches
> and 1, "Oh, that'll be fixed in 7.3.4."
>
> To stop the bugs from appearing, we've done 2 things: 1) stopped using
> bitmap indexes and 2) set HASH_JOIN_ENABLED = FALSE in the init.ora
> file. The only other workaround suggested by Oracle, which *may* have
> enabled us to continue using bitmaps, was to *not* use CBO. Not an
> option here.
>
> We're anxious for 7.3.4 (or later) to show up, because we would like to
> make use of bitmaps. The storage savings is significant.

That was a normal experience, for every version of Oracle. Even 7.3.4, you
should expect something new happens.

However, with all the patches applied, I think it is okey with bitmapped index.
Since my environment is exactly same as yours. HP-UX 10.20, 7.3.2.3, use
bitmapped-indexes, 4 to 5 patches, seems okey.

By the way, you sure bitmapped index saves storage significantly ? 'Cause for
our case it is opposite. Received on Wed Apr 09 1997 - 00:00:00 CDT