My Oracle Support Banner

ORA-07445 QsmmixGenFakeIdxStats ACCESS_VIOLATION After PSU Applied (Doc ID 2004621.1)

Last updated on NOVEMBER 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata 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
Information in this document applies to any platform.


After installing PSU, now a select statement that uses a linked databases encounters error ORA-07445. This select statement is the first step of a procedure that brings journal entries from Oracle Utilities CCB to Oracle PeopeSoft.

Problem can be reproduced by running the failing statement in sqlplus.

The CCB linked database is currently at PSU

Mon Apr 27 08:46:53 2015
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x144F76888, qsmmixGenFakeIdxStats()+228]
Errors in file <path>\trace\<sid>_ora_9884.trc (incident=49849):
ORA-07445: exception encountered: core dump [qsmmixGenFakeIdxStats()+228] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x144F76888] [UNABLE_TO_READ] []
Incident details in: <path>\trace\<sid>\incident\incdir_49849\<sis>_ora_9884_i49849.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.




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

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