Skip to Content
0
Former Member
Oct 17, 2012 at 10:40 AM

RSPO1041 taking huge execution time after EHP5 upgrade

58 Views

Hi All,

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.

Thanks,

Prashant