My Oracle Support Banner

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

Last updated on MAY 19, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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!


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.