Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning Problem, ANALYZE ..
Sorry, I forgot to mention the Oracle version.
This problem happened on both version 8.1.6 and 8.1.7
Regards,
Vance
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3bf59ce1$0$16935$afc38c87_at_news.optusnet.com.au>...
> 600 Errors are untrapped errors within Oracle itself (bugs, if you like).
> Whether they've been fixed or not, and whether you are encountering a
> specific known bug, depends on knowing your Oracle version. Which you don't
> mention.
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Vance Wu" <vwu_at_anacomp.com> wrote in message
> news:c3d4638a.0111161420.4f68a69a_at_posting.google.com...
> > Hi All,
> >
> > I have a table contains 5 partitions, when I rebuild all indexes, then
> > ANALYZE the table using command:
> >
> > ANALYZE TABLE MY_TABLE COMPUTE STATISTIC;
> >
> > After the table is analyzed, performance has improved a lot, but some
> > queries caused Oracle internal error:
> >
> > ERROR at line 1:
> > ORA-00600: internal error code, arguments: [25012], [0], [0],
> > [], [], [], [], []
> >
> > If I delete the statistics:
> >
> > ANALYZE TABLE MY_TABLE DELETE STATISTIC;
> >
> > Then I re-analyzed the table again using partitions:
> >
> > ANALYZE TABLE MY_TABLE PARTITION (PART_2000) COMPUTE STATISTIC;
> > ANALYZE TABLE MY_TABLE PARTITION (PART_2001) COMPUTE STATISTIC;
> > ANALYZE TABLE MY_TABLE PARTITION (PART_2002) COMPUTE STATISTIC;
> > ANALYZE TABLE MY_TABLE PARTITION (PART_2003) COMPUTE STATISTIC;
> > ANALYZE TABLE MY_TABLE PARTITION (PART_2004) COMPUTE STATISTIC;
> >
> > After the partitions of MY_TABLE are analyzed, again the performance
> > has also been improved a lot too, but for those queries that used to
> > cause ORA-00600 error are now OK, can someone explain to me why?
> >
> > Thanks,
> > Vance
Received on Sat Nov 17 2001 - 01:34:18 CST