Oracle10G on the ORA-600 [19004] problem is there on 11Gr2?

Oracle10G on the ORA-600 [19004] problem is there on 11Gr2?

Oracle 10g ORA-600 [19004] problem is there on 11Gr2?

Oracle 10g ORA-600 [19004] problem is there on 11Gr2?

The application reports a 600 error.
A 600 error was found during log query.
Alert log file:
Mon Dec 05 19:08:08 2011
Errors in file d: \ app \ ibsadmin \ diag \ rdbms \ orcl \ trace \ orcl_ora_00004.trc (incident = 5137 ):
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []
Incident details in: d: \ app \ ibsadmin \ diag \ rdbms \ orcl \ incident \ incdir_51_\ orcl_ora_3664_i5137.trc
Mon Dec 05 19:08:14 2011
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C: \ Documents and Settings \ ibsadmin> notepad d: \ app \ ibsadmin \ diag \ rdbms \ orcl \
Incident \ incdir_51_\ orcl_ora_3664_i5137.trc
Check the trace file and find an SQL error.
C: \ Documents ents and Settings \ ibsadmin> sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Mon Dec 5 19:18:53 2011

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
View version:
SQL> select * from v $ version;

BANNER
-----------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production
View error statements:
SQL> SELECT CV. CUSTOM_FIELD_ENTITY_ID ID, CFE. SEQUENCE, CFE. IS_ACTIVE, VALUE FRO
M CUSTOM_FIELD_ENTITY CFE, CUSTOM_FIELD_VALUE cv where cv. CUSTOM_FIELD_ENTITY_ID
= CFE. ID;
Select cv. CUSTOM_FIELD_ENTITY_ID ID, CFE. SEQUENCE, CFE. IS_ACTIVE, VALUE FROM CUS
TOM_FIELD_ENTITY CFE, CUSTOM_FIELD_VALUE cv where cv. CUSTOM_FIELD_ENTITY_ID = CF
E. ID

*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> conn businessdata
Connected.
SQL> SELECT CV. CUSTOM_FIELD_ENTITY_ID ID, CFE. SEQUENCE, CFE. IS_ACTIVE, VALUE FRO
M CUSTOM_FIELD_ENTITY CFE, CUSTOM_FIELD_VALUE cv where cv. CUSTOM_FIELD_ENTITY_ID
= CFE. ID;
Select cv. CUSTOM_FIELD_ENTITY_ID ID, CFE. SEQUENCE, CFE. IS_ACTIVE, VALUE FROM CUS
TOM_FIELD_ENTITY CFE, CUSTOM_FIELD_VALUE cv where cv. CUSTOM_FIELD_ENTITY_ID = CF
E. ID
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [],
[], [], [], []

You can delete the statistical data in 10 Gb to solve this problem. Try again here.

SQL>
SQL> execute dbms_stats.delete_schema_stats ('businessdata ')

PL/SQL procedure successfully completed.
There is no problem in executing the SQL statement.
The strange thing is:

For oracle 10.2.0.3 install patch for BUG #5579764. The bug has been fixed in 11g. ---- it seems that this problem still exists in windows.

Follow instructions of Metalink Note 390249.1 and delete column histograms.

,