My Oracle Support Banner

ORA-07445: Core Dump [Qcdlgcd()+116] [Sigsegv] During MV Refresh in DBMS_SNAPSHOT (Doc ID 459323.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 Express Cloud 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
Information in this document applies to any platform.


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




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.