Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

batch job taking longer time then expected

677389Mar 1 2011 — edited Mar 1 2011

Hi All,

We have a scheduled batch job which run at 11:30 pm daily.
When user did testing in UAT environment , it took 56 hrs to complete.But now when they run the same batch job in production system took more than 80 hrs.
FYI : The production server RAM(40GB approx) is more than UAT server RAM (4 GB).

Can anyone plz help to explore.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2011

Added on Mar 1 2011

#general-database-discussions

14 comments

1,235 views