Oracle trace files are filling up system space with ORA-00600: internal error code
HI,
We are noticing that the files in the TRACE folder for Oracle are getting substantially larger.
When we looked at the alert.log and notice that every night about 01:24, Oracle generates an ORA-00600 error and creates several diagnostic dump files.
I took a look inside one of the trc file (xxxx_m000_9500.trc) and saw this:
kewrpap - Clearing the error, continue to next table*** KEWROCISTMTEXEC - encountered error: (ORA-00942: table or view does not exist
)
*** SQLSTR: total-len=344, dump-len=344,
STR={delete from WRH$_CELL_DB_BL tab where (:beg_snap <= tab.snap_id and tab.snap_id <= :end_snap and dbid = :dbid) and not exists (select 1 from WRM$_BASELINE b where (tab.dbid = b.dbid) and (tab.snap_id >= b.start_snap_id) and (tab.snap_id <= b.end_snap_id)) }