Ora-07445 When Selecting From V$Sql_plan (Doc ID 758433.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server Enterprise Edition - Version: 9.2.0.1 to 11.1.0.8
This problem can occur on any platform.
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.8

Symptoms

SELECT * FROM V$SQL_PLAN where HASH_VALUE is null

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [0000000101624CC4] [SIGSEGV]
[Address not mapped to object] [0x1F4000000000040] [] []
Current SQL statement for this session:
SELECT * FROM V$SQL_PLAN where HASH_VALUE is null

Explain plan:
Plan Table
--------
------------------------------------------------------ 
| Operation                      | Name
------------------------------------------------------ 
| SELECT STATEMENT               | 
|  NESTED LOOPS OUTER            | 
|   NESTED LOOPS OUTER           | 
|    FIXED TABLE FULL            | X$KQLFXPL 
|    TABLE ACCESS BY INDEX ROWID | OBJ#(18) 
|     INDEX UNIQUE SCAN          | OBJ#(36) 
|   TABLE ACCESS CLUSTER         | OBJ#(22) 
|    INDEX UNIQUE SCAN           | OBJ#(11) 
------------------------------------------------------ 


STACK TRACE:
------------
ksedmp ssexhd sigacthandle xplMakeRow xplFetchRow kqlfgx kglic0 ... 

 

@ FOR INTERNAL SUPPORT USAGE ONLY

 

 

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