ORA-00600: [rworupo.1], [34], [32]

环境信息

操作系统：windows 2019
ORACLE：11.2.0.1
补丁情况：无

故障现象

手动收集用户统计信息时提示ora-00600错误，具体信息如下

SQL> exec dbms_stats.gather_schema_stats(ownname=>'CS',granularity=>'ALL',estimate_percent=>10,method_opt=>'for all indexed columns',cascade=>TRUE,degree=>16);

ORA-00600: internal error code, arguments: [rworupo.1], [34], [32], [], [], [], [], [], [],[], [], []
ORA-06512: 在 "SYS.DBMS_STATS", line 20508
ORA-06512: 在 "SYS.DBMS_STATS", line 20993
ORA-06512: 在 "SYS.DBMS_STATS", line 21073
ORA-06512: 在 "SYS.DBMS_STATS", line 21030
ORA-06512: 在 line 1

经查阅网络资料以及mos文档，确定该错误信息为bug。

mos相关资料

Format: ORA-600 [rworupo.1] [a] [b]
VERSIONS:
  versions 9.0.1 to 11.2

DESCRIPTION:

  This error is raised when the length of a column value in a row which
  we are unpacking from the queue buffer exceeds the length recorded in
  the corresponding operand descriptor.

ARGUMENTS:
  Arg [a] Length of column value
  Arg [b] Length of operand descriptor

FUNCTIONALITY:
  rwoima - RoW Operand vector IMPlementation A

IMPACT:
  PROCESS FAILURE
  NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

最终解决办法如下：

#修改会话级别
alter session set "_newsort_enabled"=false;
#修改实例级别
alter system set "_newsort_enabled"=false scope=both;