Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

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)) }

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center