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

To really help here there is more information necessary. This like reading tea leaves. Please provide the exact ora-600 and the stack trace to check
in which layer the problem happens.

Regards
Steve Received on Wed May 29 2002 - 00:24:58 CDT