ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Investment Allocation Job Performance Issue - Oracle

book

Article ID: 213375

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The Investment Allocation job is taking 5 times longer to run.
There have been no significant changes in terms of Clarity data.

Cause

Increases in job runtimes can increase due to a database configuration/maintenance issue.

 

Environment

Releases: up through 16.0.1 

Reference the following KB for enhancements to the job in 16.0.2:  Investment Allocation Job - Purpose & Overview 

 

Resolution

Please open a case with Support.

1. Provide the Oracle AWR report for the one-hour snapshot for when the job is running at poor performance.

2. Provide the Oracle AWR report for the one-hour snapshot for when the job was performing at normal performance.

On the AWR showing evidence of the performance issue related to the job, the AWR should provide recommendations where the DBA team can review and implement the advisory and
check if the performance of the Investment Allocation job after implementing the changes.

 

 

Additional Information

Check if one or more of the following are occurring during the job run as per the AWR report:
1. Is RMAN DR activity taking place?
2. Is a database export being performed?
3. Is auditing enabled?
4. Is there an undersized SGA (system global area)?