My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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)),

----- 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 ...




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.