EM 12c: Enterprise Manager 12c Cloud Control Query Consumes High CPU and Causes Log File Sequential Read Wait Events In Production
(Doc ID 2339988.1)
Last updated on FEBRUARY 17, 2019
Applies to:Enterprise Manager for Oracle Database - Version 18.104.22.168.0 and later
Enterprise Manager Base Platform - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
High CPU Usage generated by Enterprise Manager (EM) 126.96.36.199 Cloud Control
An Automatic Workload Repository (AWR) report on the EM 188.8.131.52 Cloud Control Repository database shows certain queries, issued by EM 12c, consuming database resources, generating contention, and log file sequential read wait events.
One example of an offending query as seen in an AWR report could look like this one:
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