Re: ORA-00600: Index produces timeout ?

On Thu, 09 Apr 1998 05:23:19 -0600, nat_at_object-factory.com wrote:

>(I am a bit afraid that this is going to be a newbie question, alas here goes
>(I got little pride :) ):I have a problem with an Oracle database, that I
>inherited frommy predecessor. The database runs into ORA-00600 Internal
>Errors on certain simple selects (like SELECT * from A where x=6 and y=2) and
>the cure so far has been to remove indexes from A.
>
>If the indexes are brought back, the errors come back. The error IMO is a
>timeout.
>
>What I've got is:
> Oracle7 Server Release 7.3.2.2.0 - Production Release
> With the distributed option
> PL/SQL Release 2.3.2.2.0 - Production
> SunOS 5.5.1 Generic sun4u sparc SUNW,Ultra-1

Hi,

this sounds quite similar to an error that I had last year on a 7.3.2 db. Try the following: Recreate the index on A, put your statement through explain plan and see if there is an and-equal access using this index in it (which I suspect). If so, it may be the same bug as the one that I struggled with (actually what I got was ORA-08103 Object no longer exist, but only on and-equal index scan). Oracle support had a patch for it, and everything worked fine again.

HTH
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Thu Apr 09 1998 - 13:25:40 CDT