History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QA-18
Type: Oracle - Internals Oracle - Internals
Status: Closed Closed
Resolution: Answered
Priority: Major Major
Assignee: ubTools Support
Reporter: ubTools Support
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Questions & Answers

ORA-00600 [6033] in SELECT.

Created: 15/Jul/07 05:02 PM   Updated: 16/Sep/07 04:27 PM
Return to search
Fix Version/s: None

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


 Description  « Hide

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


 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.