Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600 when analyzing
Hi!
Looks like its a bug, there was a similar tar on metalink, getting ora-600
while analyzing. I think fix is 8.1.7.3...
search metalink.
HTH
santysharma
Oracle Certified DBA
Sun Certified System Admin (Solaris 8)
"David Wilburn" <dwilburn_at_mitre.org> wrote in message
news:3B8E71BC.D425F14B_at_mitre.org...
> 8.1.6.0
>
> James Williams wrote:
> >
> > On Thu, 30 Aug 2001 11:57:42 -0400, David Wilburn <dwilburn_at_mitre.org>
> > wrote:
> >
> > What release are you. I got something similar when I went to 8.1.6.3.
> > Had to apply patch. Can't remember the number but this sounds like the
> > same bug.
> >
> > >I'd ask Oracle's support for this, but I'm currently in a state of
> > >support limbo :(
> > >
> > >This works just fine:
> > >
> > >analyze table LOGDB.SENSORLOG
> > >partition (P20010822)
> > >compute statistics for all local indexes;
> > >
> > >But this does not:
> > >
> > >analyze table LOGDB.SENSORLOG
> > >partition (P20010822)
> > >estimate statistics for all local indexes sample 20 percent;
> > >
> > >ERROR at line 1:
> > >ORA-00600: internal error code, arguments: [25012], [12], [8], [], [],
> > >[], [], []
> > >
> > >Any clues as to what the hell is going on here? I would think that if
> > >there were a problem, that compute statistics would catch it.
> > >
> > >-Dave Wilburn
Received on Thu Aug 30 2001 - 12:14:06 CDT