My Oracle Support Banner

11.1: ORA-600 [17147] AND [kghfrempty:ds] On Select Using Functional Indexes (Doc ID 884882.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.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

Following errors might occur in a 11.1.0.7 environment using E-Business Suite

ORA-00600: codice di errore interno, argomenti: [17147], [0x1118A79A8], [], [], [], [], [], []
ORA-00600: codice di errore interno, argomenti: [17147], [0x1118A79A8], [], [], [], [], [], []
ORA-00600: codice di errore interno, argomenti: [kghfrempty:ds]

 

When executing a query with functional indexes execution time is slow.

Call stack:
kghfrmrg <- kghfre <- kghsfx kghunfhp <- kghundo <- kghfrh_internal kghfrh

 

Execution plan looks similar to the one below:
---------------------------------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT                         |                         |       |       |    20 |           |
| 1   |  SORT ORDER BY                           |                         |     1 |  1051 |    20 |  00:00:01 |
| 2   |   VIEW                                   |                |     1 |  1051 |    19 |  00:00:01 |
| 3   |    HASH UNIQUE                           |                         |     1 |   499 |    19 |  00:00:01 |
| 4   |     NESTED LOOPS                         |                         |     1 |   499 |    18 |  00:00:01 |
| 5   |      NESTED LOOPS                        |                         |     1 |   452 |    18 |  00:00:01 |
| 6   |       NESTED LOOPS                       |                         |     1 |   401 |    16 |  00:00:01 |
| 7   |        NESTED LOOPS                      |                         |     1
|   365 |    15 |  00:00:01 |
| 8   |         NESTED LOOPS OUTER               |                         |     1 |   329 |    14 |  00:00:01 |
| 9   |          NESTED LOOPS                    |                         |     1 |   268 |    13 |  00:00:01 |
| 10  |           NESTED LOOPS                   |                         |     1 |   209 |    12 |  00:00:01 |
| 11  |            NESTED LOOPS                  |                         |     1 |    70 |    11 |  00:00:01 |
| 12  |             NESTED LOOPS                 |                         |     1 |    59 |     5 |  00:00:01 |
| 13  |              TABLE ACCESS BY INDEX ROWID |      |     1 |    44 |     4 |  00:00:01 |
| 14  |               INDEX RANGE SCAN           |   |     2 |       |     2 |  00:00:01 |
| 15  |              INLIST ITERATOR             |                         |       |       |       |           |
| 16  |               INDEX UNIQUE SCAN          |   |     1 |    15 |     1 |  00:00:01 |
| 17  |             TABLE ACCESS BY INDEX ROWID  |      |     1 |    11 |     6 |  00:00:01 |
| 18  |              INDEX RANGE SCAN            |          |     1 |       |     5 |  00:00:01 |
| 19  |            TABLE ACCESS BY INDEX ROWID   |             |     1 |   139 |     1 |  00:00:01 |
| 20  |             INDEX UNIQUE SCAN            |              |     1 |       |     0 |           |
| 21  |           TABLE ACCESS BY INDEX ROWID    |               |     1 |    59 |     1 |  00:00:01 |
| 22  |            INDEX UNIQUE SCAN             |          |     1 |       |     0 |           |
| 23  |          TABLE ACCESS BY INDEX ROWID     |    |     1 |    61 |     1 |  00:00:01 |
| 24  |           INDEX UNIQUE SCAN              | |     1 |       |     0 |           |
| 25  |         TABLE ACCESS BY INDEX ROWID      |    |     1 |    36 |     1 |  00:00:01 |
| 26  |          INDEX UNIQUE SCAN               | |     1 |       |     0 |           |
| 27  |        TABLE ACCESS BY INDEX ROWID       |    |     1 |    36 |     1 |  00:00:01 |
| 28  |         INDEX UNIQUE SCAN                | |     1 |       |     0 |           |
| 29  |       TABLE ACCESS BY INDEX ROWID        |           |     1 |    51 |     2 |  00:00:01 |
| 30  |        INDEX RANGE SCAN                  |        |     1 |       |     1 |  00:00:01 |
| 31  |      INDEX UNIQUE SCAN                   |       |     1 |    47 |     0 |           |
---------------------------------------------------------------------------+-----------------------------------+

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

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