SCA agent is constantly going on. Bouncing SCA, deleting the cache directories (data, log, and tmp) don't help. However, SCA will run for a few minutes and go down again.
The MERC_MISC_EVENT table containing ~41 millions rows, which stat agent is doing a full table scan on.
SOLUTION:
The Purge Agent Event Tables job is responsible to reduce the number of rows in the MERC_MISC_EVENT table. However, there are currently too many rows in this table so have the DBA manually truncate the table. Here is what you can do:
