Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information 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, should be replaced by 10 and replaced by 497393

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id =
and between block_id AND block_id + blocks - 1;

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

Getting Ora-600 [kdsgrp1] On A Select [ID 429746.1]

Applies to:

Symptoms

Cause

Solution

相關文章