Ora-07445 [Qmxsyncandgen] [Sigsegv] Raised By The Scheduler (Doc ID 1368984.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

The alert.log contains the error
ORA-07445: exception encountered: core dump [qmxSyncAndGen()+26] [SIGSEGV] [ADDR:0x10] [PC:0x90A217E] [Address not mapped to object] []
running the procedure DBMS_STATS.GATHER_DATABASE_STATS

The trace file generated contains:

----- Current SQL Statement  -----
begin DBMS_STATS.GATHER_DATABASE_STATS (
gather_sys => FALSE
,estimate_percent => dbms_stats.auto_sample_size
,method_opt => 'for all columns size 1'
,granularity => 'ALL'
,cascade => true
,options => 'GATHER'
);
end ;

----- PL/SQL Call Stack -----
 line object
number name
272 SYS.XMLTYPE
12065 package body SYS.DBMS_SQLTUNE_INTERNAL
12719 package body SYS.DBMS_SQLTUNE_INTERNAL
17400 package body SYS.DBMS_SQLTUNE_INTERNAL
6764 package body SYS.DBMS_STATS_INTERNAL
20153 package body SYS.DBMS_STATS
21081 package body SYS.DBMS_STATS
22271 package body SYS.DBMS_STATS
22974 package body SYS.DBMS_STATS
23418 package body SYS.DBMS_STATS
24055 package body SYS.DBMS_STATS
24268 package body SYS.DBMS_STATS
24224 package body SYS.DBMS_STATS
1 anonymous block

----- Call Stack Trace -----
skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd sighandler qmxSyncAndGen qmxGetNodeByNameCS qmkmtraverseXob
qmkmpin qmkmgetSchemaURL qmuLookupSchemaElement qmu_preparse_xml_ex qmxtgGetUrlAndElNam eCS qmxtgCreateFromLob qmxtkCreateFromLob
qmxtkCreateFromClob PGOSF462_qmxtkCon sFromClob spefcpfa sFromClob spefmccallstd pextproc PGOSF589_peftrust PGOSF633_psdexsp rpiswu2
psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe
opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main libc_start_main start

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