My Oracle Support Banner

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 later
Information 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


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