Applies
to:
Enterprise Linux – Version: 5
Oracle Database 11gR2
Description:
I have an update statement which modifies
around 30000 records. Statement executed successfully on a single record, but
when I execute to update all records it is going to fail with following error
message:
ORA-00600: internal
error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Solution:
·
Open and view the alert log file when error
occurred
·
Get the trace file name from alert log file
and open it
·
Search the keyword “Plan Table” in trace file
·
Here you found details of the query causing
problem
·
Identify the tables from above query and
execute the following:
Analyze table <tab_name> validate structure
cascade;
·
Identify all the indexes on the above tables
and execute the following:
Analyze
index <index_name> validate structure;
·
Here I found an index which fail to validate
and return the below error:
ORA-00600:
internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [],
[], []
·
Now I drop the index and recreate it.
·
After doing all the steps I resolved the
above error.
Your comments, especially which will help us
improve the functionality, will be greatly appreciatedJ
