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

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>

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