Stop alert "WARNING: DB Server xxx: Processes may be spinning or consuming a lot of CPU"

User51642 Yong Huang

Whenever there're processes using too much CPU, we get an email alert with this Subject:

WARNING: DB Server <hostname>: Processes may be spinning or consuming a lot of CPU

and the email body is:

--- begin ---

Warning: Software Alert 8_1

Event Time    2020-05-29T07:50:20-05:00

Description    Processes may be spinning or consuming a lot of CPU. CPU utilization of the following processes exceeds 95% in 90% or more of the samples:

Process ID    Process Information

195092    User    1000(oracle)

#Threads    1

CPU History    Timestamp    %CPU

2020-05-29T07:41:19.741-05:00    99.68

2020-05-29T07:42:19.903-05:00    99.53

...

Command    ora_p00g_obiastg1

Tree    PID    PPID    Command

195454    1    ora_p00g_obiastg1

1    0    /usr/lib/systemd/systemd --switched-root --system --deserialize 22

Affected Server    Name    <hostname>

Server Model    Oracle Corporation ORACLE SERVER X7-2

Chassis Serial Number    <serial number>

Release Version    19.2.11.0.0.200224

Recommended Action    Examine and stop the process(es) if this is unexpected.

Diagnostic package is attached. It is also accessible at /opt/oracle/dbserver/dbms/deploy/log/xxx_2020_05_29T07_50_20_8_1.tar.bz2

--- end ---

Apparently, the alert comes from dbmsrv service (https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/exadata-general-maintenance.html#GUID-1D429217-461E-4FA1-88BB-5137339C39CC). Is there a command in dbmcli to disable individual process CPU usage alert? The server has lots of CPUs. We don't care about a dozen processes consuming 100% CPU because the system load is still moderate.