My Oracle Support Banner

ORA-7445 [__INTEL_SSSE3_REP_MEMCPY()] from JDBC Thin Connection (Doc ID 2374749.1)

Last updated on MARCH 03, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The error ORA-7445 [__intel_ssse3_rep_memcpy()] is thrown when running a select statement from a JDBC application.
The issue does not reproduce from SQL*Plus while forcing same plan.

The incident trace file contains the following details:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x5E089F6, __intel_ssse3_rep_memcpy()+8406] [flags: 0x0, count: 1]
.................
__intel_ssse3_rep_memcpy()+8393 (0x5e089e9) nop
__intel_ssse3_rep_memcpy()+8397 (0x5e089ed) nop
__intel_ssse3_rep_memcpy()+8400 (0x5e089f0) mov -0x7(%rsi),íx
__intel_ssse3_rep_memcpy()+8403 (0x5e089f3) mov -0x4(%rsi),ìx
> __intel_ssse3_rep_memcpy()+8406 (0x5e089f6) mov íx,-0x7(%rdi)
__intel_ssse3_rep_memcpy()+8409 (0x5e089f9) mov ìx,-0x4(%rdi)
__intel_ssse3_rep_memcpy()+8412 (0x5e089fc) ret
__intel_ssse3_rep_memcpy()+8413 (0x5e089fd) nop
__intel_ssse3_rep_memcpy()+8416 (0x5e08a00) lddqu -0x86(%rsi),%xmm0

*** 2018-01-18 07:51:16.890
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=<SQL_ID>) -----
SELECT * FROM (Select C1
,C2
,C3
,:P_1 P1

From <TABLE_NAME>
Where :P_1 Between D1 And D2) QRSLT ORDER BY C2
[TOC00004-END]

[TOC00005]
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kpobii kpobav opibvg opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real ssthrdmain main libc_start_main start
................
----- Bind Byte Code (IN) -----
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 0x5cedfc158 Offsi = 48, Offsi = 0
Opcode = 2 Bind Twotask Scalar Sql In (may be out) Copy
oacdef = 0x5cedfc188 Offsi = 48, Offsi = 88
[TOC00908-END]
[TOC00909]
----- Bind Info (kkscoacd) -----
Bind#0
oacdty=12 mxl=07(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=16 off=0
kxsbbbfp=00000000 bln=07 avl=00 flg=05 <<<<<<<<<<<<<<<<<---NULL kxsbbbfp
Bind#1
oacdty=12 mxl=07(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=0 off=8
kxsbbbfp=7f3b0251e7e0 bln=07 avl=07 flg=01
value="1/18/2018 8:0:0"

 

The plan table uses 12.1 rowset feature:

 

Changes

Upgrade to 12gR1.

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
Changes
Cause
Solution
References


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