Re: ORA-00600 and bitmaps?

"MT" <mtechera_at_wpmc.com> wrote in message news:acvs1v$9ds$1_at_news.online.de...
> Hello Everyone:
>
> I have a query that when executed gives me an ORA-00600.
> The query involves joining over several tables (that is why
> I don't want to list everything here).
>
> In fact, I get the ORA-00600 even when I try to generate
> a plan for the query.
>
> When I change some of the indexes on the join columns
> from bitmaps to B*-trees the error goes away.
>
> The problem then is that other queries then suffer in
> substatially in terms of performance as a result.
>
> I am using 8.1.7.0 on Win2K and the CBO.
>
> Does this problem sound familiar to anyone?
>
> Regards,
> Mario
>
>
>

Hi Mario,

there were some problems the bitmap indexes. I have two suggestions: 1. Upgrade to 8.1.7.3.x
2. Try to reorg the table either with CREATE TABLE ... AS SELECT ... or with exp/imp and try than the bitmap index.

Regards
Ralph Received on Tue May 28 2002 - 13:37:26 CDT