ORA-07445: [Strlen()+24] Running dbms_stats.gather_fixed_objects_stats
(Doc ID 1176254.1)
Last updated on AUGUST 25, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
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 ...
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |