Re: ORA-00600 and bitmaps?

From: Liggs <liggs_at_hotmail.com>
Date: Wed, 29 May 2002 18:46:15 +0000 (UTC)
Message-ID: <ad37ln$6ef$2@helle.btinternet.com>

Call the ora-00600 into Oracle Support ASAP.

Good luck.
Alun

"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
>
>
>
Received on Wed May 29 2002 - 13:46:15 CDT