My Oracle Support Banner

Ora-07445 [_intel_fast_memcpy.J()+155] When Using Sys_Guid() and Row Contains Bad Data (Doc ID 1321175.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

When using sys_guid() function in a query for a specific row, it fails with:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()+155] [SIGSEGV] [unknown code] [0x000000000] [] []

Example:

SQL> select sys_guid(),a.* from TEST a where rollenid='8990021648350Z85BAPECD';

ERROR at line 1:
ORA-03113: end-of-file on communication channel
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.J()+266] [SIGSEGV] [unknown code] [0x000000000] [] []

It works fine if remove sys_guid() function from query.

We also see some of that row's data is invalid, for example:

SYST DSTIMESTAMP
---- ---------------------------------------------------------------------------
Á 57.22.88 47:47:48,825373

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!

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