Time Slicing job very slow during Monthly Rollover (Oracle)

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

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