ORA-600 [kcblin_3] when _smm_max_size is greater than 2GB
(Doc ID 1372904.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.1.0.1 [Release 10.2 to 12.1]Information in this document applies to any platform.
Symptoms
The following error is returned when the hidden parameter _SMM_MAX_SIZE is set to a value greater than 2Gb and the estimate size for a GROUP BY (HASH) operation result greater than 2Gb:
ORA-00600: internal error code, arguments: [kcblin_3], [103], [253952], [8192], [32769], [312], [640], [], [], [], [], []
The output of the view V$SQL_WORKAREA_ACTIVE shows for example the following output:
SID TIME OPERATION ESIZE MEM MAX MEM PASS TEMPSEG_SIZE_MB
------ ------------------- ---------------- ------- ------- --------- ------- ---------------
178 01/11/2011:19:18:13 GROUP BY (HASH) 2156 0 0 0
178 01/11/2011:19:18:13 HASH-JOIN 1343 1454 1454 0
178 01/11/2011:19:18:13 HASH-JOIN 3 0 0 0
178 01/11/2011:19:18:13 HASH-JOIN 2 0 0 0
------ ------------------- ---------------- ------- ------- --------- ------- ---------------
178 01/11/2011:19:18:13 GROUP BY (HASH) 2156 0 0 0
178 01/11/2011:19:18:13 HASH-JOIN 1343 1454 1454 0
178 01/11/2011:19:18:13 HASH-JOIN 3 0 0 0
178 01/11/2011:19:18:13 HASH-JOIN 2 0 0 0
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 |