My Oracle Support Banner

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 later
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

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


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