My Oracle Support Banner

ORA-7445 Dump in Memcpy() Selecting Against X$KSMDD (Doc ID 1317486.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Execution of dbms_stats.gather_fixed_objects_stats() are failing.

eg.
SQL> exec dbms_stats.gather_fixed_objects_stats();
BEGIN dbms_stats.gather_fixed_objects_stats(); END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: ...
Session ID: ... Serial number: ...

And the following ORA-7445 error is written to the alert log file
ORA-07445: exception encountered: core dump [memcpy()+210] [SIGSEGV] [ADDR:0x...] [PC:0x...] [Address not mapped to object] []

Actually, every attempt to run a query on X$KSMDD are also failing.

The Call Stack of the generated tracefile contains:
  ... memcpy ... ksmdscan_ksmdd

And Plan table confirms an access to X$KSMDD like in the following Plan Table:

------------------------------------+-----------------------------------+
| Id  | Operation         | Name    | Rows  | Bytes | Cost  | Time      |
------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT  |         |       |       |     1 |           |
| 1   |  FIXED TABLE FULL | X$KSMDD |   100 |   16K |     0 |           |
------------------------------------+-----------------------------------+

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.