Re: ORA-00600: Index produces timeout ?

Have you done analyze table validate structure yet ? Your table maybe corrupted .

Peter Schneider wrote:

> 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 - 14:22:45 CDT