ORA-00600: internal error code, arguments: [19004]

From: Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com>
Date: Tue, 4 Aug 2009 18:26:03 +0530
Message-ID: <b081c0a50908040556m40fc8485x19cff0e0f6b278db_at_mail.gmail.com>


iam running Oracle on windows ...

we have changed our statistics gathering method long time back by using dbms_stats package..

Reccently we have got one Ora-00600 error which is related to the stats and histogram,

 we have gathered our schema using the below method.


this above type collect the histograms also for some columns which is been decided by oracle since
METHOD_OPT=>'for all columns size auto'..

then we have queried a table which results in internal error.

SQL> select * from space;
select * from space

ERROR at line 1:
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []

so we changed method_opt to its 9i default value,METHOD_OPT=>'for all columns size 1' ..

then it works fine ..

But Oracle says this issue is fixed in 10.2.04 metalink documet id: *3057951.8

Mohammed Mehraj Hussain.H
Oracle DBA,

Received on Tue Aug 04 2009 - 07:56:03 CDT

Original text of this message