PowerProtect: High CPU usage from Agent service on Oracle and SQL hosts

Summary: PPDM 19.13 Agent service on Oracle RMAN and SQL hosts is highly using CPU on the host.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

1. On the Oracle host, you see agent-service using close to 100% CPU.

Track the usage of the copies.db running:

lsof -p <pid>
2. Go to /opt/dpsapps/agentsvc/dbs/v1 and check the size of copies.db

copies.db will be very large, potentially 100s of GBs

Cause

Due to the large size of the database "copies.db" the agentservice is taking up a lot of CPU resources to query it.

Resolution

On Linux, Oracle hosts

1. Go to /opt/dpsapps/agentsvc

2. Stop agent service:

./register.sh --stop

3. Go to /opt/dpsapps/agentsvc/dbs/v1

4. Renamed the following DB files:

copies.db
tasks.db
sessions.db

5. Run the following commands:

conn / as sysdba
SQL> exec dbms_stats.gather_fixed_objects_stats();

6.  Go back to /opt/dpsapps/agentsvc

7.  Restart the agent service: Use

./register.sh --start

On Windows SQL hosts:

1. Click Start and type services.msc.

2. Stop the PowerProtect Agent Service.

3. Go to C:\Program Files\DPSAPPS\agentsvc\dbs\v1

4. Rename the following DB files:

copies.db
tasks.db
sessions.db

5. In the Windows Services applet, Start the PowerProtect Agent service

Products

Data Protection
Article Properties
Article Number: 000220276
Article Type: Solution
Last Modified: 09 Oct 2024
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.