Re: ORA--00600 [15592}

From: Juergen Gmeiner <jg_at_tiani.com>
Date: 21 Oct 1998 11:26:10 +0200
Message-ID: <m1yaqa5kr1.fsf@klondike.tiani.com>

"David Spaisman" <david.spaisman_at_compaq.com> writes:

> A developer was running a fully-tested query in production(it also ran
> successfully in a test instance but less data than production) and the
> ORA--00600 error occurred. Oracle Tech support suggests turning off
> hash_join_enabled. But the application is slow as is(purchased from a
> vendor) and I don't want to risk degradation further.

we had this error on wgs 7.3.2 and aix4.1, but as 600 means "internal error", that's pretty generic.

our problem was that at large production sites with lots of updates, apparently oracle got confused and was unable to do a consistent read of the table (or the index, i don't remember exactly).

fix for bug # 401264 solved the problem for us.

ymmv,
juergen Received on Wed Oct 21 1998 - 04:26:10 CDT