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