ORA-07445 QsmmixGenFakeIdxStats ACCESS_VIOLATION After PSU Applied

(Doc ID 2004621.1)

Last updated on MAY 06, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 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 E:\ORACLE\diag\rdbms\fnprod\fnprod\trace\fnprod_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: E:\ORACLE\diag\rdbms\fnprod\fnprod\incident\incdir_49849\fnprod_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.


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 hundreds of Community platforms