AnsweredAssumed Answered

Update PRTimeentry table running for days

Question asked by Paul_DST on Nov 7, 2016
Latest reply on Nov 9, 2016 by Nika_Hadzhikidi

New to Clarity/PPM inner workings but we have a time slice job running against this table where it sets SLICE_STATUS to 0,1,2,3 or 4.

We believe it might be related to changes to reporting added for Jaspersoft (Moving away from Biz Objects)

There are 17 million records in this table.

 

The main  update we see running is   (Calling other procedures?)

UPDATE PRTimeentry

   SET SLICE_STATUS = :"SYS_B_0"

   WHERE SLICE_STATUS = :v0

   ADD ROWNUM <= :"SYS_B_1"

 

We are out of ideas.   Oracle DB tuning had no suggestions.  It is only updating about 1000 records a minute.  Indexes won't have any help we are told as there are nulls in SLICE_STATUS.    We were told maybe a Bitmap index might help but I think something else is going on here we are not aware of.

Outcomes