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>



Hi,

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
Received on Tue Aug 04 2009 - 07:56:03 CDT

Original text of this message