Error Occur in Select Query (ORA-00600)

Question

Sir,
I have problem about oracle (select query). I was write select query and it is working some time and some time not working. Error has display as following:
Select Query:- Select DISTINCT BatchNumber from tabname where recdate Like '20111101%' AND OptCode='Datta';
Error:- ORA-00600; internal error code, arguments: [kdiss_pin_hdr: too many], [], [], [], [], [], [], []
Why this error occur in select query.
Please give me reply ASAP.
Thanks.

Datta Kharad · Answer

Hello Sir,
I cant remove recdate from my query but, same query is working on another schema. I have 2 schema (eg. HCL and DELL) and each schema has its own tables. HCL-  OptTable
DELL-OptTable
Given query is working Dell.OptTable and not working HCL.OptTable
And also another select query is working on two schema. But this query is not working properly....
If u have any solution then tell me Sir....
Thanks for Giving reply to me....

Suthish Nair · Answer

The possible information available is here, http://orafaq.com/wiki/ORA-00600. Can you remove the recdate like condition and check you query, also select top 5 or 10 records.

Manikavelu Velayutham · Answer

This error code is native to internal exceptions from the Oracle programs. It indicates that the process has encountered an unexpected low. It may be due to timeout A corrupted file crash verification data in memory I/O issue "(physical memory)"