ORA-07445: core dump [__intel_ssse3_rep_memcpy()+3263] [SIGSEGV] kxfxcSendBind
(Doc ID 2609938.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
The error ORA-07445: exception encountered: core dump [__intel_ssse3_rep_memcpy()+3263] [SIGSEGV] [Invalid permissions for mapped is seen in alert log file.
…
----- Current SQL Statement for this session-----
UPDATE /*+ PARALLEL */ xxxxxx
SET
Call Stack:
==========
<- intel_ssse3_rep_m <- emcpy <- intel_fast_memcpy
<- kxfxpnd <- kxfxcSendBind <- kxfxcp1 <- kxfxcp <- qerpxSendParse
<- kxfpValidateSlaveGr <- oup <- kxfpgsg <- oup <- kxfrAllocSlaves
<- 560 <- kxfrialo <- kxfralo <- qerpx_rowsrc_start <- qerpxStart
<- qerupStart <- updaul <- updThreePhaseExe <- 329 <- updexe
<- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- libc_start_main <- start <- [TOC00005-END]
-- Plan Table -----
============
Plan Table
============
------------------------------------------------------------+-----------------------------------+-------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib | Pstart| Pstop |
------------------------------------------------------------+-----------------------------------+-------------------------+---------------+
| 0 | UPDATE STATEMENT | | | | 4 | | | | | | |
| 1 | UPDATE | XXXXX | | | | | | | | | |
| 2 | PX COORDINATOR | | | | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10001 | 1 | 971 | 4 | 00:00:01 |:Q1001| P->S |QC (RANDOM)| | |
| 4 | TABLE ACCESS BY GLOBAL INDEX ROWID | XXXX | 1 | 971 | 4 | 00:00:01 |:Q1001| PCWP | | ROW LOCATION| ROW LOCATION|
| 5 | BUFFER SORT | | | | | |:Q1001| XXXC | | | |
| 6 | PX RECEIVE | | 1 | | 3 | 00:00:01 |:Q1001| XXXX | | | |
| 7 | PX SEND HASH (BLOCK ADDRESS) | :TQ10000 | 1 | | 3 | 00:00:01 |:Q1000| S->P |HASH (BLOCK ADDRESS)| | |
| 8 | PX SELECTOR | | | | | |:Q1000| XXXC | | | |
| 9 | INDEX UNIQUE SCAN | PK_XXXXX| 1 | | 3 | 00:00:01 |:Q1000| SCWP | | | |
------------------------------------------------------------+-----------------------------------+-------------------------+---------------+
Cursor#1(0x7f5a960021a8) state=BOUND curiob=0x7f5a956272a8
curflg=44 fl2=0 par=(nil) ses=0x12e3ede540
Bind dump in incident trace file will show the inconsistent binds as below;
Bind#12
oacdty=23 mxl=4001(10000) mxlc=00 mal=00 scl=00 pre=00......................................................................Inconsistent bind data which exceeds the max length of the defined bind variable
oacflg=03 fl2=1000000 frm=00 siz=4000 off=0
kxsbbbfp=7f5a94ef4060 bln=4000 avl=32767 flg=25
Bind#13
oacdty=23 mxl=4001(10000) mxlc=00 mal=00 scl=00 pre=00......................................................................Inconsistent bind data which exceeds the max length of the defined bind variable
oacflg=03 fl2=1000000 frm=00 siz=4000 off=0
kxsbbbfp=7f5a94eb4060 bln=4000 avl=32767 flg=25
Bind#14
oacdty=23 mxl=4001(10000) mxlc=00 mal=00 scl=00 pre=00......................................................................Inconsistent bind data which exceeds the max length of the defined bind variable
oacflg=03 fl2=1000000 frm=00 siz=4000 off=0
kxsbbbfp=7f5a94c84060 bln=4000 avl=32767 flg=25
Cause
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
Symptoms |
Cause |
Solution |