ORA-00104: deadlock detected; all public servers blocked waiting for resources
What triggered the Error:
All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.What should we do to fix it:
Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automaticaly start up new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
