ORA-600 [kghstack_alloc], [koklsotyopn alloc] on INSERT
(Doc ID 1404149.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database - Standard Edition - Version 11.2.0.2.0 and later
Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Encountering ORA-600 [kghstack_alloc], [koklsotyopn alloc] during INSERT.
The following error is seen in the ALERT:
ORA-00600: internal error code, arguments: [kghstack_alloc], [koklsotyopn alloc], [], [], [], [], [], [], [], [], [], []
From the generated tracefile the following information is available.
Current sql:
----- Current SQL Statement for this session (sql_id=6w1hv8d7fuzfc) -----
INSERT INTO TABLE1 (COL1,COL2) VALUES (:1,:2)
INSERT INTO TABLE1 (COL1,COL2) VALUES (:1,:2)
The call stack looks similar to:
----- Call Stack Trace -----
kghstack_alloc koklsotyopn kokleva evaopn2
kghstack_alloc koklsotyopn kokleva evaopn2
The bind variable information shows:
COL1:
Bind#0 oacdty=02 mxl=22(22)
COL2:
Bind#1 oacdty=01 mxl=2000(21408) <----------- max length : 2000, though application tries to insert 21408
Bind#0 oacdty=02 mxl=22(22)
COL2:
Bind#1 oacdty=01 mxl=2000(21408) <----------- max length : 2000, though application tries to insert 21408
Checking the table structure of table TABLE1 shows COL2 is of type CLOB:
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 |