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 laterEnterprise 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 |