Performance Issues with Timesheet Approval/Editing/Population

Products

• Clarity PPM On Premise

Issue/Introduction

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).

Resolution

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.