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

iam running Oracle 10.2.0.4 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.

exec
DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>v_SchemaOwnerName,estimate_percent=>null,cascade=>TRUE);

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

Regards,
Mohammed Mehraj Hussain.H
Oracle DBA,
HTSL,India
*

--
http://www.freelists.org/webpage/oracle-l