My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.