EM 12c: Enterprise Manager 12c Cloud Control Query Consumes High CPU and Causes Log File Sequential Read Wait Events In Production
Last updated on JANUARY 10, 2018
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 and later
Enterprise Manager Base Platform - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
High CPU Usage generated by Enterprise Manager (EM) 18.104.22.168 Cloud Control
An Automatic Workload Repository (AWR) report on the EM 22.214.171.124 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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms