Hi,
I am really intrigued by this problem.This error is thrown when there ate too many processes waiting in queue for their turn to access the resource or when there is too much database activity.
My concern is,if we decide to fix the problem by increasing the no. of enqueue resources,what is the guarantee that my process wont fail again with this error..Also,can there be any other reason for this error being thrown?
I looked up Oracle help..It said that the enqueue resources and the number of DML locks should be the same if one is using parallel DML..any explanation for this?
Would appreciate it if someone could shed some light on this matter.
I am really intrigued by this problem.This error is thrown when there ate too many processes waiting in queue for their turn to access the resource or when there is too much database activity.
My concern is,if we decide to fix the problem by increasing the no. of enqueue resources,what is the guarantee that my process wont fail again with this error..Also,can there be any other reason for this error being thrown?
I looked up Oracle help..It said that the enqueue resources and the number of DML locks should be the same if one is using parallel DML..any explanation for this?
Would appreciate it if someone could shed some light on this matter.