ORA-600 [kghstack_free1], [kdblccovwr_segcol] or ORA-600 [len/segcol exceeds allocation] When Updating a Compressed Table with Lob Column

(Doc ID 2394876.1)

Last updated on MAY 04, 2018

Applies to:

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

Symptoms

- Running an update from Informatica application on a compressed table with a lob column fails with one of the following errors:

- Error: ORA-00600 [kghstack_free1] [kdblccovwr_segcol]
Error Stack:
    ORA-00600: internal error code, arguments: [kghstack_free1], [kdblccovwr_segcol], [], [], [], [], [], [], [], [], [], []
Main Stack:
... kghstack_free kdblccovwr kdblcovw kduurp kdusru kauupd updrow qerupFetch updaul updThreePhaseExe updexe opiexe ...

or

- Error: ORA-00600 [len/segcol exceeds allocation]
Error Stack:
   ORA-00600: internal error code, arguments: [len/segcol exceeds allocation], [], [], [], [], [], [], [], [], [], [], []
Main Stack:
... kdblcAddLmnInfo kduadk kdblccovwr kdblcovw kduurp kdusru kauupd updrow qerupFetch updaul updThreePhaseExe updexe ...


- One of the incident trace file shows the following information:

----- Current SQL Statement for this session (sql_id=c93dz1z3tw4mm) -----
UPDATE DW_NAM.STG_BFO_USER SET USERNAME = :1, LASTNAME = :2, FIRSTNAME = :3,NAME = :4, COMPANYNAME = :5, DIVISION = :6, DEPARTMENT = :7, TITLE = :8, STREET = :9, CITY = :10, STATE = :11, POSTALCODE = :12, COUNTRY = :13,STATECODE = :14, COUNTRYCODE = :15, LATITUDE = :16, LONGITUDE = :17, EMAIL =:18, EMAILPRFRNCSAUTOBCC = :19, EMAILPRFRNCSAUTOBCCSTAYINTCH = :20, ....

Plan Table
============
----------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost |Time |
----------------------------------------------------+-----------------------------------+
| 0 | UPDATE STATEMENT | | | | 3 ||
| 1 | UPDATE | STG_BFO_USER| | | ||
| 2 | TABLE ACCESS BY INDEX ROWID | STG_BFO_USER| 1 | 1864 | 3 |00:00:01 |
| 3 | INDEX UNIQUE SCAN | USER_PK | 1 | | 2 |00:00:01 |
----------------------------------------------------+-----------------------------------+

 
- The errors are reported for the following compression type::

SQL> select compression,COMPRESS_FOR from dba_tables where table_name='STG_BFO_USER';

COMPRESS COMPRESS_FOR
-------- ------------------------------
ENABLED ADVANCED


- Dropping and recreating the table doesn't fix the error and changing to basic compression doesn't help either.

- Minimum supplemental logging is enabled at database level:

Minimum Primary Key Foreign Key Unique All Columns
Supplemental Supplemental Supplemental Supplemental Supplemental
Logging? Logging? Logging? Logging? Logging? Force Logging?
------------ ------------ ------------ ------------ ------------ ------------
YES NO NO NO NO YES

 

- RMAN validate, analyze table validate structure cascade, DB Verify, DataPump export don't detect any corruption at table level.

- The output of PLSQL block from <Document 787004.1> (used to check the lobs for possible corruptions) doesn't show corruptions.

- Running:
        SQL> ALTER TABLE TEST.STG_BFO_USER MOVE COMPRESS;
  doesn't help to fix the error.

 

Changes

 

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