<< Back to previous view

[QA-18] ORA-00600 [6033] in SELECT. Created: 15/Jul/07  Updated: 16/Sep/07

Status: Closed
Project: Questions & Answers
Fix Version/s: None

Type: Oracle - Internals Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Answered Votes: 0

Product Version: 8.1.7.0.0
Operating System: Solaris
Operating System Version: 5.8

 Description   

Error code:

 
ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []

Current SQL statement for this session:

 
SELECT *   FROM CSD_BOUNCE_CONTENT_BODY  WHERE BOUNCE_CONTENT_ID = :b1

Oracle kernel function from which the problem is raised:

 
kdifxs()

This is a function of Oracle Data Layer and responsible for fetching a row in an index scan.

Leaf block dump:

 
Leaf block dump
===============
header address 2567438500=0x990800a4
kdxcolev 0
kdxcolok 0
kdxcoopc 0xa0: opcode=0: iot flags=-C- is converted=Y
kdxconco 2
kdxcosdc 0
kdxconro 663
kdxcofbo 1410=0x582
kdxcofeo 4421=0x1145
kdxcoavs 8687
kdxlespl 0
kdxlende 0
kdxlenxt 0=0x0
kdxleprv 62923132=0x3c0217c
kdxledsz 0
kdxlebksz 16152
kdxlepnro 11
kdxlepnco 1
...

This is an index object# 0x1ec41. As seen above, kdxcoopc is 0xa0. That means, this index is a key compressed V8 B*Tree index. Also, kdxledsz is 0. In other words, this index is a non-unique index.

Recommendations:

Check your table by the following statement against any possible corruption:

  • SQL > analyze table CSD_BOUNCE_CONTENT_BODY validate structure cascade;

If no corruption is detected, please see the following bugs:

  • ORA-600 [6033] DURING WORK FLOW ORDER IMPORT PROCESS
  • ORA-600 [711], [1], [0X2EDFE84] [KDIFXS - PREFIX CONTEXT] WITH COMPRESSED INDEX

Generated at Mon Sep 15 23:24:07 UTC 2025 using JIRA Standard Edition, Version: 3.12.3-#302.