My Oracle Support Banner

ORA-600 [kcblin_3] when _smm_max_size is greater than 2GB (Doc ID 1372904.1)

Last updated on NOVEMBER 05, 2015

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.
***Checked for relevance on 29-Apr-2013***

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

 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.