Performance Issues with Timesheet Approval/Editing/Population


Article ID: 210651


Updated On:


Clarity PPM On Premise


The problem occurred after a recent upgrade of Clarity (15.3 to 15.8 or 15.9.1) and the database (Oracle 12c to 19c).


Compare the execution plans of prior and current version.
Obtain the AWR of the prior to the upgrade and after the upgrade.

The execution plan for 12c was much lower than that  of 19c, therefore it was suggested to set the compatibility mode to 12c.

In reported cases, after setting the required/recommended database parameters in 15.9.1 Settings, afterwards, the timesheet actions were much improved.