Re: ORA-00600 and bitmaps?

ORA-600 errors generally always need to be referred back to Oracle suppport. In order to get even the remotest chance of an answer here, you need to supply the next error number from the ORA-600 error series. e.g. ORA-600 [xxxx][a][b][c][d][e] What is in the xxxx box?

George Barbour.

"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 Tue May 28 2002 - 08:59:01 CDT