Time Slicing job very slow during Monthly Rollover (Oracle)

Document ID : KB000126189
Last Modified Date : 04/02/2019
Show Technical Document Details
Introduction:

 
Question:
Our Time Slicing job is very slow during Monthly Rollover, and processing few records per second only, what can be done about that.
Answer:
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