Slow Performance - Job Runtime Increased - Troubleshooting

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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?

Environment

Release : All 

 

Resolution

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