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 11.2.0.1 to 12.1.0.2 [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.
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 <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
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]
...
[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
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
| Symptoms |
| Cause |
| Solution |
| References |