ORA-600 [ktspgsb3:objdchk_kcbgcur_3] Accessing ASSM Segment (Doc ID 2007343.1)

Last updated on JUNE 09, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to access LOBs, the following error occurs as reported in the alert log:

ORA-00600: internal error code, arguments: [ktspgsb3:objdchk_kcbgcur_3], [26794], [9], [4], [0], [], [], [], [], [], [], []


The trace file shows characteristics like:

----- Current SQL Statement for this session (sql_id=72mrqwjxtqctc) -----
table_c_a_68a4_a_0_0

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x2509fee58      1139  package body SYS.DBMS_LOB
0x24faaecf8        45  package body SAP1.DB_BLOB
0x24d683fe0         1  anonymous block


----- Call Stack Trace -----

... kcbgcur ktspgsb3 ktsplbfmb ktsplbrecl ktspgsp_main kdlgsp_init kdl_write1 kdlf_write koklwrite1 koklwrite kkxlwra kkxlbwra ...


For this situation, the current sql indicates the use of a temporary table and the PL/SQL stack shows the LOB involvement.

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