Ora-07445: Exception Encountered: Core Dump [Memcpy()+756] (Doc ID 786439.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.3
***Checked for relevance on 06-Oct-2011***
***Checked for relevance on 13-Mar-2013***

Symptoms


ORA-07445: exception encountered: core dump [memcpy()+756] [SIGSEGV] [Address not mapped to
object] [0x2000FFFF7B28FB38] [] []

Current SQL statement for this session:

select p1.album_id, count(p1.album_id) visible_photo_count from photos.photos p1
where p1.album_id in (select distinct(album_id) from photos.photos
where photo_id between 129581543 and 129591543)
and p1.visible_state in (0,3)
group by p1.album_id

The call stack in the trace written by the error includes all or some of the following functions:


memcpy <- msqapp <- kkpapDASQuerySLvl <- kkpapDASQuery <- kkofmpsqp <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbd
<- apaqbd <- apadrv <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <-
kkspsc0 <- kksParseCursor <- opiosq0 <- opiall0

The error occurs usually when the query joins to a partitioned table.

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