QMON Processes Consuming High Amount of CPU on 22.214.171.124
(Doc ID 1615165.1)
Last updated on AUGUST 31, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
You have observed that qmon worker processes (qXXX) are consuming a high amount of CPU.
To determine if you are suffering this problem, the following conditions should be met.
1) In AQ HC script (provided on Doc ID 1193854.1) html output, you can see :
a) At Statistics --> QMON section, the process consuming CPU are in status RUNNING and the task assigned are related to spilling like : QMON_SPILL or QMON_DEALLOC_SPILLED.
It can be idenfied using the following query too:
2) A 10046/SQL trace for qmon workers consuming cpu shows continous waits on 'library cache: mutex X' for the same idn all the time.
This issue has been observed on customer running EBS Workflow module, but can be observed on any type of queues.
It is more frequent to observe this issue on environment with ASMM (sga_target > 0) is being used and streams_pool_size parameter is not defined.
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