Time Slicing job very slow during Monthly Rollover (Oracle)

Article Id: 126189

Status: Published

Updated On: 04-02-2019 12:54

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

Our Time Slicing job is very slow during Monthly Rollover, and processing few records per second only, what can be done about that.

Environment:

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

1. Cancel the job
2. Find and kill the session on the database, make sure you get the one that updates the PRJ_BLB_SLICES. Do not remove all existing sessions, only the one that's problematic
3. Run Oracle Table Analyze job to redo statistics on the database
4. Run the Timeslicing job again

Additional Information:

Here is an article that helps identify how the Time Slicing job is progressing:
https://comm.support.ca.com/kb/ca-ppm-time-slicing-job-appears-to-be-be-hanging-or-stuck-in-the-processing-status/KB000046539