After EHP5 upgrade, report RSPO1041 is taking too long to execute.
Report RSPO1041 is scheduled to be executed daily in production system via a job.
Before EHP5 upgrade the job use to execute in 10 mins.
But after EHP5 upgrade the job needs to be cancelled as it takes more than 24 hours to execute.
The report deletes all the spools older than 45 days.
Please help to provide a solution to this problem.