Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tuning Problem, ANALYZE ..
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...Received on Fri Nov 16 2001 - 17:09:40 CST
> 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