Hi Dave,

Thanks for your reply.

Yes, I did that before comming here. Every one ending up increasing Undo TS size. However, when the batch job is running, same time gather database stats job (default 10g scheduler job) and segment space advisor jobs are running. I have started digging from that end to see whether they are causing any contension.

Thanks,