oracle中出现ORA-00600内部错误怎么办

ORA-600 [kcbnew_3] (文档 ID 204512.1)

转到底部

Note: For additional ORA-600 related  infORMation please read

PURPOSE:

   it means and possible actions. The information here is only applicable

You can restrict the list below to issues likely to affect one of the  following versions by clicking the relevant button: 
               

          indicates  that an alert exists for that issue.

·'+'         Note:1944526.1<1span style="font-size:12pt;font-family:;" "=""> for details of other symbols used

Bug 5218905 - OERI[kcbnew_3] when segment  advisor has been used (文档 ID 5218905.8)

转到底部

Bug 5218905  OERI[kcbnew_3] when  segment advisor has been used

 This note gives a brief overview of  bug 5218905. 
 The content was last updated on: 03-APR-2009
 Click here for details of each of the sections below.

Affects:

Fixed:

Description

ORA-600 [kcbnew_3] can occur when segment  advisor

has been running on an instance as it can  read blocks

into the cache as CURRENT when it should  have read

them as CR.

Note: The presence of ORA-600 [kcbnew_3]  does not mean

       that you HAVE encountered this problem as there can

       be other reasons for a wrong block in the cache.

Workaround

  Do  not use segment advisor.

   eg:  connect / as sysdba;

        exec dbms_scheduler.disable('AUTO_SPACE_ADVISOR_JOB');

    Use "alter system flush buffer_cache" to clear bad blocks

    from the cache

Note:

   Also see <Bug:4430244>

Please note: The above is a summary description only. Actual symptoms can    vary. Matching to any symptoms here does not confirm that you are    encountering this problem. Always consult with Oracle Support for advice.

References

Bug:5218905 (This link will only work for  PUBLISHED bugs)
Note:245840.1 Information on the sections in this article