Solution : https://service.sap.com/sap/support/notes/986536 (SAP Service marketplace login required)
Summary :
High CPU consumption in Oracle 10.x background processes, such as MMON and its child processes (m000, m001, etc.), is reported across various platforms. This issue is typically observed in either new Oracle Server installations or recently patched ones. The MMON process generates trace files named using the SID and Unix PID format (e.g., <SID>_mmon_xxxxx.trc). Investigation of these trace files for specific error strings like "KEWRAFC: Flush slave failed, AWR Enqueue Timeout" or "KEWRAFC: Flush slave failed, return code 5" is recommended. Resolving the issue involves shutting down the database, relinking Oracle binaries, and restarting the database to ensure proper process execution.
Key words :
top thatoracle background processes m000, symptom high cpu consumption, awr enqueue timeout orkewrafc, return code 5 solution shutdown, dbrelink oracle binaries- connect, background processes mainlymmon, oracle binaries needed, consuming highcpu cycles, mmon process produces, unix pid numberopen
Related Notes :
| 712624 | High CPU consumption by Oracle |