Ora-7445 [msqopnws] On SQL Analyze (Doc ID 1585018.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms


When attempting to perform the  SQL Analyze , the following error occurs.

ERROR
-----------------------
ORA-07445: exception encountered: core dump [msqopnws()+6566] [SIGSEGV] [ADDR:0x28] [PC:0x2013C34] [Address not mapped to object] []


STEPS
-----------------------
/* SQL Analyze(1189,0) */ SELECT * FROM (WITH TIMESLOT_DATA AS
........
TTL_APPT_QT) QRSLT ORDER BY TMSLT_DATE
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
0xf4672478 106 package body SYS.DBMS_XRWMV
0xeea584c8 3527 package body SYS.DBMS_SNAPSHOT
0xf187abe8 1 anonymous block


Cause

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