ORA-07445: [Strlen()+24] Running dbms_stats.gather_fixed_objects_stats (Doc ID 1176254.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Mar-2012***

Symptoms

SQL> execute dbms_stats.gather_fixed_objects_stats;
Fails with:
ORA-07445: exception encountered: core dump [strlen()+24] [SIGSEGV] [ADDR:0x526561642066726F] [PC:0xFFFFFFFF7AD3BA38] [Address not mapped to object] []

Failing sql:
/* SQL Analyze(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 no_substrb_pad */ to_char(count("KGLOBHMK")),to_char(substrb(dump(min("KGLOBHMK"),16,0,32),1,120)),
to_char(substrb(dump(max("KGLOBHMK"),16,0,32),1,120)),to_char(count("KGLHDBVL")),
to_char(substrb(dump(min("KGLHDBVL"),16,0,32),1,120)),
<snip>

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
a37ed31e8 145 package body SYS.DBMS_SQLTUNE_INTERNAL
a37ed31e8 12043 package body SYS.DBMS_SQLTUNE_INTERNAL
a37ed31e8 12677 package body SYS.DBMS_SQLTUNE_INTERNAL
a37ed31e8 17162 package body SYS.DBMS_SQLTUNE_INTERNAL
a27de7e10 5869 package body SYS.DBMS_STATS_INTERNAL
a23dd0160 18030 package body SYS.DBMS_STATS
a23dd0160 18842 package body SYS.DBMS_STATS
a23dd0160 19702 package body SYS.DBMS_STATS
a23dd0160 20226 package body SYS.DBMS_STATS
a23dd0160 20456 package body SYS.DBMS_STATS
a23dd0160 20945 package body SYS.DBMS_STATS
a23dd0160 21498 package body SYS.DBMS_STATS
a23dacd40 1 anonymous block

----- Call Stack Trace -----
strlen qerfxGCol qerfxFetch qerandvFetch qergsFetch opifch2 kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpufch0 kpufch qksanExecSql qksanAnalyzeSql qksanAnalyzeSegSql psdextp pefccal ...

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