High CPU Utilization when working with large quantities of versions

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

We have a project with thousands of items in it. When trying to do a delete version of a removed folder (where multiple subitems exist), Harvest goes into an unresponsive state and we see very high CPU utilization on AWS RDS. We can mimic this in QA by simply querying for package contents in a package with over 1000 items. I executed "find version" for items against a project with a large quantity of items, and we get an unresponsive Harvest and RDS goes into a high CPU utilization state. As of now, I cannot delete or successfully query packages in projects with very large quantities of files. RDS is set for General Purpose SSD, db.t2.medium instance, and IOPS disabled. Oracle 12.1.0.2.v15

Environment

Release : 13.0.3

Component : CA HARVEST SCM CORE FUNCTIONALITY/PROCESS AUTOMATION

Cause

We found that statistics were being collected on the Harvest "Temp" tables.  This is not recommended since those are meant to be "scratch-pad" space which is constantly being filled and emptied, and filled again.  Recommended dropping the statistics option on the temp tables.

Resolution

Locking the Oracle temp tables so that stats could not be collected resolved the problem.