Ora-7445 [KGLNAO] occurs when running joined query on Dynamic Performance (V$) Views. (Doc ID 470010.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.1.0.6 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Symptoms

Query on GV$-Tables fails with ORA-07445 [kglnao()+32]  

ERROR MESSAGE
-------------
*** 2007-12-05 16:21:34.205
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kglnao()+32] [SIGSEGV] [Address
not mapped to object] [0x0000128CB] [] []

STATEMENT
---------
Current SQL statement for this session:
select 
      o.sid, o.sql_text, o.address, o.hash_value, 
      o.user_name, o.inst_id, s.schemaname
from  gv$open_cursor o, gv$session s
where o.saddr = s.saddr
and   o.sid = s.sid
and   o.inst_id = s.inst_id
and   ( (O.SID = '28' AND O.INST_ID = '1'))


CALL STACK
----------
kglnao kkstpld kqlfgl kglLockIterator
kqlftl qerfxFetch qervwFetch qersoFetch qerjoFetch kpofrws opifch2
... 

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