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 laterOracle 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 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
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
Symptoms |
Cause |
Solution |
References |