MMON Slave Process Executing SQL ID '4kvhga64b6wah' with High CPU Utilization
(Doc ID 2743260.1)
Last updated on NOVEMBER 07, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Queries submitted by a slave process of the MMON background process consume high CPU utilization. While similar in syntax, the query with SQL ID '4kvhga64b6wah' tends to require more CPU time than that with SQL ID '0vcs754gpmxrc'
- As seen in a sample AWR Report, together, the two queries are responsible for approximately 33.6 percent of all CPU Time. Each has yet to complete a single execution:
SQL ordered by CPU Time
CPU Time (s) Executions CPU per Exec (s) %Total Elapsed Time (s) %CPU %IO SQL Id SQL Module SQL Text
1,058.25 0 23.35 1,234.02 85.76 0.00 4kvhga64b6wah MMON_SLAVE WITH binds as (select :dbid as...
464.15 0 10.24 572.04 81.14 0.00 0vcs754gpmxrc MMON_SLAVE WITH binds as (select :dbid as...
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