Oracle Server -
Enterprise Edition - Version: 10.2.0.3 and later [Release:
10.2 and later ]
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,
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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/223555/viewspace-681322/ ,如需转载,请注明出处,否则将追究法律责任。