ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Getting Ora-600 [kdsgrp1] On A Select [ID 429746.1]

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

原创 Linux操作系统 作者:renjixinchina 时间:2012-07-24 10:20:05 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-736473/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-30

  • 博文量
    373
  • 访问量
    2047210