My Oracle Support Banner

Query with ANSI Join Involving Views/Tables Can Fail with ORA-7445 [kghfrf] (Doc ID 2103785.1)

Last updated on FEBRUARY 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Below error seen in alert log file:

Mon Feb 01 17:12:07 2016
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x936B181, kghfrf()+201] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_68533.trc (incident=1470237):
ORA-07445: exception encountered: core dump [kghfrf()+201] [SIGSEGV] [ADDR:0x0] [PC:0x936B181] [SI_KERNEL(general_protection)] []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_1470237/<instname>_ora_68533_i1470237.trc

The failing SQL statement involves an ANSI join.

The call stack from the trace file shows functions like:

[05]: kghfrf [KGH]<-- Signaling
[06]: kghssgtr [KGH]
[07]: kghssgfr [KGH]
[08]: kghsskdstry [KGH]
[09]: kkqvmcvselsub [SQL_VMerge]
[10]: kkqvmCheckValidSVM [SQL_VMerge]
[11]: kkqvmTrMrg [SQL_VMerge]
[12]: kkqvmTrMrg [SQL_VMerge]
[13]: kkqvmTrMrg [SQL_VMerge]
[14]: kkqvmTrMrg [SQL_VMerge]
[15]: kkqvmdrv2 [SQL_VMerge]
[16]: kkqvmdrv [SQL_VMerge]



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.