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.

Time Slicing job very slow during monthly rollover (Oracle)


Article ID: 126189


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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


Release: All Supported
Component: Clarity Time Slicing

Database: Oracle


  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 Time slicing job again

Additional Information

See also related KB: Time Slicing job slow performance - troubleshooting

Here is an article that helps identify how the Time Slicing job is progressing: Time Slicing job appears to be hanging - troubleshooting