ORA-00600: internal error code arguments: [kdsgrp1]
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>