My Oracle Support Banner

EM 12cR5, 13c : Agent is Consuming High CPU when Collecting "Top SQL Monitoring List" Metric for Database Targets (Doc ID 2128112.1)

Last updated on AUGUST 30, 2024

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.8.0 and later
Enterprise Manager Base Platform - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

High CPU usage is observed on a 12.1.0.5 / 13c Management Agent:

 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
 3561 oracle 20 0 8826300 712304 11440 S 497.0 0.5 21017:04 java

After checking the highest CPU consuming thread with "top -H -p <EMAgent PID>", and taking a jstack from EMAgent ($AGENT_HOME/jdk/bin/jstack <EMAgent pid> > /tmp/jstack.out), this thread is showing on top:

GC.Executor.79 (oracle_database:mydb:topSqlMonitoringList_col) (oracle_database:mydb:topSqlMonitoringList_col:topSqlMonitoringList)" prio=10 tid=0x00007f084c002000 nid=0x33f0 
runnable [0x00007f08faeec000]
java.lang.Thread.State: RUNNABLE
at java.util.Arrays.copyOf(Arrays.java:2882)
at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)
at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)
at java.lang.StringBuilder.append(StringBuilder.java:119)

$AGENT_INST_HOME/sysman/log/gcagent.log reports the following errors:

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.