CA PPM high cpu usage

book

Article ID: 141226

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

Experiencing high cpu usage for PPM

WARN  Rownum limit of '50000' detected. Attempted to return '59431'.

Environment

Release : 15.3

Component : CA PPM RESOURCE MANAGEMENT

Resolution

When it comes to database tuning, we usually don't provide any such recommendations due to the fact that the configuration would vary from system to system.

There are no generic recommendations from Clarity on tuning. However, based on Install guide:

Post-Install: Optimize Oracle 12c Performance
On local installations of Oracle 12c R1 or R2, you might detect a regression issue with Oracle 12c when ORDERED hint is used in structured queries. An Oracle bug in 12c R2 can degrade performance if the optimizer is set to 12.2.0.1.
For systems using Oracle 12c R1 (12.1.0.2), no further action is required.
For systems using Oracle 12c R2 (12.2.0.1), you can optimize performance by setting the optimizer to 12.1.0.2. We recommend applying this optional local fix.
Follow these steps: 
From a command prompt in Oracle, enter the following lines:
 sqlplus / as sysdba  ALTER SYSTEM SET "_fix_control" = '17800514:0'; Exit;
Run the following command:
ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE= '12.1.0.2' SCOPE=BOTH;
Verify that your Oracle 12c R2 initialization file parameters appear similar to the following example:
*._fix_control='17800514:0'*._optimizer_multi_table_outerjoin=FALSE*.audit_file_dest='/

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-3/installing-and-upgrading/install-ca-ppm.html

Additional Information

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-3/installing-and-upgrading/install-ca-ppm.html