Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2Information in this document applies to any platform.
Symptoms
-- Problem Statement:
On 10.2.0.3 in Production:
When attempting to run a query,
the following error occurs: ORA-600 [kdsgrp1]
-- Steps To Reproduce:
Execute a select, insert or update statement that requires the use of an index.
-- Business Impact:
The issue has the following business impact:
Due
to this issue, the statement will fail with an ORA-00600: internal
error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Cause
One possible cause is an Index corruption.Solution
1) Look in the generated trace file where the error occurred, search for the string "SESSION ID"You should see an entry similar to:-
*** SESSION ID:(461.5270) 2007-05-01 23:43:18.775
row 028796f1.125 continuation at
file# 10 block# 497393 slot 294 not found
2) Take the file# and block# found in your search and put them in the following query.
In this case,
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id =
and
You should receive output similar to
TABLESPACE_NAME SEGMENT_TYPE OWNER
------------------------------ ------------------ ------------------------------
SEGMENT_NAME
--------------------------------------------------------------------------------
USERS TABLE SCOTT
HR
3) In your trace file search for the string "Plan Table". Using the table you identified in Step 2
(e.g SCOTT.HR) , look at the Plan Table to identify indexes that are potentially corrupted.
4) Drop and re-create the indexes that you identified in step 3