ORA-07445 [kgghash()+1072] Or ORA-07445 [kgghtIterInit2()+390] Errors When Gathering Stats On a Standby DB (Doc ID 1907048.1)

Last updated on JULY 14, 2014

Applies to:

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

Symptoms

An ORA-07445 [kgghash()], ORA-07445 [kgghtIterInit()] or ORA-07445 [kgghtIterInit2()] error could occur when gathering statistics on a primary/standby database.

The call stack will contain module kzia_ro_fixed_table_callback(), e.g.:

 
ORA-07445 [kgghash()]
=====================
kgghash() <- kgghtAddCB() <- kzia_ro_fixed_table_callback() <- qerfxFetch() <- qerandvFetch() <- qergsFetch() <- opifch2() <- kpoal8() <- opiodr() <- kpoodrc() ...

ORA-07445 [kgghtIterNext()]
===========================
kgghtIterNext() <- kzia_ro_fixed_table_callback() <- qerfxFetch() <- rwsfcd() <- qerltFetch() <- ctcdrv() <- opiexe() <- opiosq0() <- kpooprx() ...

Changes

 The database has performed a switch over, to or from a read-only standby database, possibly many hours before.

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