ora-7445 error or core dump while querying V$OPEN_CURSOR (Doc ID 435093.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8
Oracle Server - Enterprise Edition - Version: 10.1.0.2
This problem can occur on any platform.

Symptoms

You run a query against V$OPEN_CURSOR and you see an ORA-7445 error and/or a core dump.

If you review the 'stack' portion of the trace file, you will see some or all of the following function codes.:

kglLockIterator kqlftl qerfxFetch qerghFetch qerflFetchOutside opifch2

 

An explain plan inside the trace would
confirm access on fixed table X$KGLLK. 

If you search the trace file for "X$KGLLK" you will find an explain plan that is something like:

============
Plan Table
============
-------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | | |
| 1 | SORT AGGREGATE | | | | | |
| 2 | FIXED TABLE FULL | X$KGLLK | | | | |
-------------------------------------+-----------------------------------+

Changes

This may occur after an upgrade or patch application but it may also occur during normal business processing.

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