Re: ORA-00600: ,  in ALERT.LOG
Date: Wed, 16 Apr 2008 02:32:31 -0700 (PDT)
On Apr 15, 4:21 pm, bdbafh <bdb..._at_gmail.com> wrote:
> On Apr 15, 8:01 am, "isma.sanc..._at_gmail.com" <isma.sanc..._at_gmail.com>
> > Hi,
> > We have discovered in the alert.log some ora-00600 in our Oracle
> > Database 10g (10.2.0.3.0) on Windows 2003 Server. The database is
> > running, but the error is generating a big amount of dump files.
> > In the dump files, we found the following information:
> > *** SERVICE NAME:(SYS$USERS) 2008-04-10 13:31:19.527
> > *** SESSION ID:(294.450) 2008-04-10 13:31:19.527
> > *** 2008-04-10 13:31:19.527
> > ksedmp: internal or fatal error
> > ORA-00600: internal error code, arguments: , , , , ,
> > , , 
> > Current SQL statement for this session:
> > SELECT STRING_VALUE FROM MGMT_CURRENT_METRICS WHERE TARGET_GUID = :B3
> > AND METRIC_GUID = :B2 AND KEY_VALUE = :B1
> > We have also found that Oracle defined automatic optimizer statistics
> > collection job (GATHER_STATS_JOB) is not running properly.
> > In the operation details, the job appears as STOPPED
> > REASON="Job slave process was terminated"
> > I don't know if there's any relation with the ORA-600 Error. But I
> > don't know how to solve it.
> > I've looked for information about this error in metalink but I
> > couldn't find useful information.
> > do you know how to solve it?
> > Thank you for your help in advance.
> > Ismael
> There should have been a trace file generated (in bdump) by the
> dbms_stats scheduled job failure.
> There are several errors with the package dbms_stats in 10.2.0.3 on MS
> Win 32, 2 of which I have seen directly.
> If you manually gather statistics on this table as a foreground
> process using dbms_stats.gather_table_stats, what errors occur?
> Are you ready to deploy the 10.2.0.4 patchset?
> There are fixes for dbms_stats in there (check the release notes) that
> might or might not apply to your issue.
> good luck.
When I manually gather statistics:
dbms_stats.gather_table_stats(ownname => 'SYSMAN', tabname =>
I get :
ORA-03113: end-of-file on communication channel and a new ora-00600 in the alert.log. :-( Received on Wed Apr 16 2008 - 04:32:31 CDT