ORA-07445: Core Dump [Qcdlgcd()+116] [Sigsegv] During MV Refresh in DBMS_SNAPSHOT (Doc ID 459323.1)

Symptoms

A refresh of a materialized view (MV) with DBMS_REFRESH resulted in the following error:
ORA-07445: exception encountered: core dump [qcdlgcd()+116] [SIGSEGV] [Address not mapped to object] [0x000000037] [] []

The P/L SQL stack in the tracefile showed the following:

----- PL/SQL Call Stack -----
object line object
handle number name
39cc74cf8 81 package body SYS.DBMS_SNAPSHOT
39cc74cf8 1728 package body SYS.DBMS_SNAPSHOT
39cc74cf8 2223 package body SYS.DBMS_SNAPSHOT
39cc74cf8 2460 package body SYS.DBMS_SNAPSHOT
39cc95db8 683 package body SYS.DBMS_IREFRESH
39cc9ea50 195 package body SYS.DBMS_REFRESH
3959adea8 1 anonymous block

The stack trace in the tracefile may look similar to the following:

. . . sigacthandler qcdlgcd kkmfrkcn qcscif qcsrctq qcssrc qcsrcr qcsrnr qcsridn qcsraic qcsoHandleRemoteSel qcspqb kkmdrv opiSem opiDeferredSem opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 opiall0 opikpr opiodr rpidrus skgmstack rpidru rpiswu2 kprball kkzfrc kkzfrsh_execute 764 kkzfrsh kkzifr3g spefcmpa spefmccallstd peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv rpiexe kkjex1e kkjsexe kkjrdp opirip opidrv sou2o opimai_real main start

Changes

Cause

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