Slow Performance - Job Runtime Increased - Troubleshooting
search cancel

Slow Performance - Job Runtime Increased - Troubleshooting


Article ID: 141089


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


There is continuous slowness in process or Job execution after a certain date/day.
Since the jobs are running longer than expected, what could be causing the issue?


Release : All 



For customers hosted by Oracle, obtain the statspack or AWR report for the time period the job took a long time to run.

Open a case and provide as an attachment for reference.


Additional Information

For statspacks, the obtain the query hash value(s).
In order to get the optimizer plans for the hash value, running the out of the box sprep.sql will prompt for the hash values as input.

See also Jobs Slow Performance / Stuck - Master KB