Query with ANSI Join Involving Views/Tables Can Fail with ORA-7445 [kghfrf]

(Doc ID 2103785.1)

Last updated on FEBRUARY 22, 2016

Applies to:

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

Symptoms

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 /ora/app/oracle/diag/rdbms/idrpw/IDRPW2/trace/IDRPW2_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: /ora/app/oracle/diag/rdbms/idrpw/IDRPW2/incident/incdir_1470237/IDRPW2_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]
...

 

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