ORA-00600 [qerghFetch:inc] or [15851] or ORA-07445 [smbput()] (Doc ID 1542297.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 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 | T_EP        |     1 |    15 |     1 |  00:00:01 |
| 6   |       INDEX UNIQUE SCAN          | T_EP_PK     |     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         | T_EP_I_X    |   157 |  1570 |     1 |  00:00:01 |
| 11  |         INDEX RANGE SCAN         | T_EP_E_I_X|   157 |  1570 |     8 |  00:00:01 |
| 12  |        INLIST ITERATOR           |                       |       |       |       |           |
| 13  |         INDEX RANGE SCAN         | T_EP_J_I_X      |   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

 

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