ORA-00600 [qerghFetch:inc] or [15851] or ORA-07445 [smbput()]
(Doc ID 1542297.1)
Last updated on AUGUST 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterOracle 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
Running a SELECT query with MIN(CASE [...]) clause fails with:
ORA-00600: internal error code, arguments: [qerghFetch:inc], [], [], [], [], [], [], []
OR
ORA-00600: internal error code, arguments: [15851], [6], [6], [1], [2], [], [], []
OR
ORA-07445: exception encountered: core dump [smbput()+688] [SIGSEGV] [Address not mapped to object]
These parameters will not workaround the issue:
"_BLOOM_FILTER_ENABLED" = false;
"_gby_hash_aggregation_enabled" = false;
The execution plan is similar to
Plan Table
============
-----------------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-----------------------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 33 | |
| 1 | COUNT | | | | | |
| 2 | VIEW | | 1 | 91 | 33 | 00:00:01 |
| 3 | HASH GROUP BY | | 1 | 25 | 33 | 00:00:01 |
| 4 | HASH JOIN | | 157 | 3925 | 33 | 00:00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID | <TABLE_NAME> | 1 | 15 | 1 | 00:00:01 |
| 6 | INDEX UNIQUE SCAN | <INDEX_NAME1> | 1 | | 1 | 00:00:01 |
| 7 | VIEW | index$_join$_002 | 157 | 1570 | 31 | 00:00:01 |
| 8 | HASH JOIN | | | | | |
| 9 | HASH JOIN | | | | | |
| 10 | INDEX RANGE SCAN | <INDEX_NAME2> | 157 | 1570 | 1 | 00:00:01 |
| 11 | INDEX RANGE SCAN | <INDEX_NAME3>| 157 | 1570 | 8 | 00:00:01 |
| 12 | INLIST ITERATOR | | | | | |
| 13 | INDEX RANGE SCAN | <INDEX_NAME4> | 157 | 1570 | 20 | 00:00:01 |
-----------------------------------------------------------------+-----------------------------------+
and cursor_sharing = FORCE
Issue reproduces with PSU 10.2.0.5.7 applied or with <Patch 9735237> applied.
The 'call stack' can be found in the trace file. It may contain some or all of the following function codes:
$cold_qerghFetch qervwFetch qercoFetch rwsfcd
Changes
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 |
Changes |
Cause |
Solution |
References |