ORA-600 [1350] / ORA-48122 Error When Running dbms_stats.gather_fixed_objects_stats; (Doc ID 1103463.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2013***

Symptoms

An ORA-600 [1350] or ORA-48122 error is raised when executing dbms_stats.gather_fixed_objects_stats after upgrade to 11g. 
The incident trace file for the ORA-600 [1350] error will show something like:

ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [], [], [], [], []
----- Current SQL Statement for this session (sql_id=gtfzqazj6a6us) -----
/* SQL Analyze(170,0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t)
 dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0)
 no_monitoring */to_char(count("VALUE")),to_char(substrb(dump(min("VALUE"),16,0,32),1,120)),
to_char(substrb(dump(max("VALUE"),16,0,32),1,120)),to_char(count("ISDEPRECATED")),
to_char(substrb(dump(min("ISDEPRECATED"),16,0,32),1,120)),
to_char(substrb(dump(max("ISDEPRECATED"),16,0,32),1,120)),
to_char(count("PARAMETER")),
to_char(substrb(dump(min("PARAMETER"),16,0,32),1,120)),
to_char(substrb(dump(max("PARAMETER"),16,0,32),1,120)),
to_char(count("INDX")),to_char(substrb(dump(min("INDX"),16,0,32),1,120)),
to_char(substrb(dump(max("INDX"),16,0,32),1,120)),to_char(count("ADDR")),
to_char(substrb(dump(min("ADDR"),16,0,32),1,120)),
to_char(substrb(dump(max("ADDR"),16,0,32),1,120)),
to_char(count("INST_ID")),to_char(substrb(dump(min("INST_ID"),16,0,32),1,120)),
to_char(substrb(dump(max("INST_ID"),16,0,32),1,120))
from "SYS"."X$KSULV" t /* NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,ACL,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/

----- PL/SQL Call Stack -----
object line object
3a854e250 11813 package body SYS.DBMS_SQLTUNE_INTERNAL
3a9056bf8 5470 package body SYS.DBMS_STATS_INTERNAL
3a91b98d0 16417 package body SYS.DBMS_STATS
3a7b38520 1 anonymous block

----- Call Stack Trace -----
. .  . . ksulvf qerfxFetch qerandvFetch qergsFetch opifch2 kpoal8 . . . . .


Additional Symptoms:  The function X$KSULV appears on the failing statement, indicating it is
processing fixed tables.

Changes

Recently upgraded to RDBMS 11.1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms