Since you're on 8.0.5, I would run utlbstat before the job runs and utlestat after it runs. This should help you with the health of the instance.
In addition, just after the job starts, I would start a trace on it so I could spend most of my time analyzing the queries that take the most time to execute.




Reply With Quote