Patch 5644830 : Performance Issue with patch 5644830
During the execution of this patch(5644830), Customer seen that lots of object locking issues and patch was not proceeding as they ran this patch with 128 workers.
So later canceled the worker and executed the sql (pa111u31.sql & paupg109.sql ) separately from sql prompt.
Customer would like to take your help in understanding what is the idea no of worker they need to run this patch so that we should not face this issue again in next iteration.
Regards,
Rasheed