ORA-00600 of encounters: [15851], [3], [2], [1], [1]

Week Children's Day Taiwan database reported ora600, checked the next MOS, the problem is not big, record a bit.

ORA-00600:&NBSP;INTERNAL&NBSP;ERROR&NBSP;CODE,&NBSP;ARGUMENTS:&NBSP;[15851],&NBSP;[3],&NBSP;[2],&NBSP;[1],[1],  [], [], []ora-00600: internal error code, arguments: [15851], [3 ], [2], [1],[1], [], [], []ora-06512: at  "SYS. Dbms_stats ", line 21275 it matches thisexactly:ora-600 [15815] when  using dbms_stats on tablewith function based index  (Doc ID  1092675.1) BUT&NBSP;IT&NBSP;DOESN ' T talk about any workaround. thesolution is  to apply a patch or upgrade to 11.2.0.2.interestingly, this  noteora-600: [15851] when gathering statistics (doc id 1111618.1) seems  to be about the same problem, and inaddition to a  Patch, it also suggests a workaround:sql> select index_name, partition_name,num_rows, from dba_ind_partitions where  status= ' unusable '; sql> alter index <owner>.<name>rebuild; sql> analyze table<owner>.<table_name> compute/estimate statistics;

This article is from the "just out of the shell of the Birds" blog, please be sure to keep this source http://qhd2004.blog.51cto.com/629417/1713071

ORA-00600 of encounters: [15851], [3], [2], [1], [1]