ORA-07445 [__intel_new_memcpy] with SQL Tuning Advisor (Doc ID 1372530.1)

Last updated on JULY 02, 2015

Applies to:

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

Symptoms

When attempting to run SQL Tuning Advisor in 11.2.0.2, the following error occurs.

ERROR
-----------------------
ORA-07445: exception encountered: core dump [__intel_new_memcpy()+149] [SIGSEGV] [ADDR:0x3D] [PC:0xBC13A85] [Address not mapped to object] []

The call stack in the trace file is similar to:

 intel_new_memcpy <- qeaeMinmax <- qeaeMax <- qerghFetch
<- qerflFetchOutside <- qervwFetch <- rwsfcd <- qerhjFetch <- qerjotFetch
<- qerjotFetch <- qerjotFetch <- qersoProcessULS <- qersoFetch <- opifch2
<- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr
<- upirtrc <- kpurcsc <- kpufch0 <- kpufch <- OCIStmtFetch2
<- qksanExecSql <- qksanAnalyzeSql <- 158 <- qksanAnalyzeSegSql <- kestseDoOneExec
<- kestseDoOneRound <- 414 <- kestsePlansDoRounds <- kestseExecutePlans <- kestsaTestPlans
<- 470 <- kestsaAutoTuneDrv <- kestsTuneSqlDrv <- kesaiExecAction <- kesaiTuneSqlDrv
<- 099 <- spefcifa <- spefmccallstd <- pextproc <- PGOSF552_peftrust
<- PGOSF648_psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal
<- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr
<- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute
<- PGOSF500_jslvec_e <- xeccb <- jslvswu <- jslve_execute0 <- jslve_execute
<- rpiswu2 <- kkjex1e <- kkjsexe <- kkjrdp <- opirip
<- opidrv <- sou2o

The explain plan in the trace contains 'HASH GROUP BY', even though the query may not actually contain a 'group by' clause.

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