Global Enqueue Services Deadlock detected.
Hi
we have a 2 node 11.2.0.3 RAC on Linux 6
we are seeing the following messages in the alert.log on both nodes
"Global Enqueue Services Deadlock detected. More info in file"
In the trace files, there are UPDATE statements
How can we fix this? Any ideas what could be promoting this?
There are 6 application servers that connects to both the db nodes. Would it help if we shutdown
and restart all those application servers one by one or do you feel that bouncing the instances one by one or may be shut down and restart the database in whole would help
we have a 2 node 11.2.0.3 RAC on Linux 6
we are seeing the following messages in the alert.log on both nodes
"Global Enqueue Services Deadlock detected. More info in file"
In the trace files, there are UPDATE statements
How can we fix this? Any ideas what could be promoting this?
There are 6 application servers that connects to both the db nodes. Would it help if we shutdown
and restart all those application servers one by one or do you feel that bouncing the instances one by one or may be shut down and restart the database in whole would help
0