ORA-00600: Internal Error Code, Arguments: [kkogbro: No Kkoaptyp], [0]
(Doc ID 1674064.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Different select statements are failing with:
ORA-00600: internal error code, arguments: [kkogbro: no kkoaptyp], [0], [], [], [], [], [], [], [], [], [], []
- The trace file shows the following information :
----- Current SQL Statement for this session (sql_id=4kg73387w25jw) -----
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x556335378 7486 package body APPS.WF_MAIL
0x54dd26410 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kkogbro kkojnp kkocnp kkooqb kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbdDescendents apaqbdList apaqbd apadrv opitca kksFullTypeCheck rpiswu2
kksLoadChild kxsGetRuntimeLock kksfbc kkspbd0 kksParseCursor opiosq0 opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal
...........
----- Session Cursor Dump -----
Current cursor: 22, pgadep=1
Open cursors(pls, sys, hwm, max): 22(1, 0, 64, 600)
NULL=0 SYNTAX=1 PARSE=0 BOUND=21 FETCH=0 ROW=0
Cached frame pages(total, free):
4k(16, 15), 8k(0, 0), 16k(2, 2), 32k(0, 0)
.....
----------------------------------------
Cursor#22(0x7f1d696e2800) state=SYNTAX curiob=0x7f1d6943ea88
curflg=cd fl2=0 par=(nil) ses=0x55ccdc648
----- Dump Cursor sql_id=4kg73387w25jw xsc=0x7f1d6943ea88 cur=0x7f1d696e2800 -----
LibraryHandle: Address=0x5597f9620 Hash=fc1163c LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
FullHashValue=48a15e1a65019b78493ce31a0fc1163c Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=264312380 OwnerIdn=590
...........
----- Current SQL Statement for this session (sql_id=4kg73387w25jw) -----
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
........
_optimizer_native_full_outer_join = force
optimizer_outer_join_to_inner = true
_optimizer_full_outer_join_to_outer = true
_first_k_rows_dynamic_proration = true
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x556335378 7486 package body APPS.WF_MAIL
0x54dd26410 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
kkogbro kkojnp kkocnp kkooqb kkoqbc apakkoqb apaqbdDescendents apaqbdList apaqbdDescendents apaqbdList apaqbd apadrv opitca kksFullTypeCheck rpiswu2
kksLoadChild kxsGetRuntimeLock kksfbc kkspbd0 kksParseCursor opiosq0 opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal
...........
----- Session Cursor Dump -----
Current cursor: 22, pgadep=1
Open cursors(pls, sys, hwm, max): 22(1, 0, 64, 600)
NULL=0 SYNTAX=1 PARSE=0 BOUND=21 FETCH=0 ROW=0
Cached frame pages(total, free):
4k(16, 15), 8k(0, 0), 16k(2, 2), 32k(0, 0)
.....
----------------------------------------
Cursor#22(0x7f1d696e2800) state=SYNTAX curiob=0x7f1d6943ea88
curflg=cd fl2=0 par=(nil) ses=0x55ccdc648
----- Dump Cursor sql_id=4kg73387w25jw xsc=0x7f1d6943ea88 cur=0x7f1d696e2800 -----
LibraryHandle: Address=0x5597f9620 Hash=fc1163c LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
FullHashValue=48a15e1a65019b78493ce31a0fc1163c Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=264312380 OwnerIdn=590
...........
----- Current SQL Statement for this session (sql_id=4kg73387w25jw) -----
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
........
_optimizer_native_full_outer_join = force
optimizer_outer_join_to_inner = true
_optimizer_full_outer_join_to_outer = true
_first_k_rows_dynamic_proration = true
- The HashFullOuterJoin access path is enabled: _optimizer_native_full_outer_join = force
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 |