MMON generating Trace File '_m000_' Frequently Ora-12899 (Doc ID 330552.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 and later
Information in this document applies to any platform.

Symptoms

MMON is generating trace files frequently.

 *** ACTION NAME:(Auto-Flush Slave Action) 2005-08-08 06:01:01.156
    *** MODULE NAME:(MMON_SLAVE) 2005-08-08 06:01:01.156
    *** SERVICE NAME:(SYS$BACKGROUND) 2005-08-08 06:01:01.156
    *** SESSION ID:(147.39616) 2005-08-08 06:01:01.156
    *** KEWROCISTMTEXEC - encountered error: (ORA-12899: value too large for column
    "SYS"."WRH$_ACTIVE_SESSION_HISTORY"."PROGRAM" (actual: 63, maximum: 48)
    )
      *** SQLSTR: total-len=1293, dump-len=240,
          STR={INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number,
    sample_id,    sample_time, session_id, session_serial#, user_id,    sql_id, sql_child_number,
    sql_plan_hash_value, service_hash,    session_type, sql}
    kewa_flusher: Exception handler 13509 - Will resignal!

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms