Oracle Error Message
ORA-00104: deadlock detected; all public servers blocked waiting for resource
Reason for the Error
This message is displayed when a client locks a resource and the maximum number of shared servers are occupied by other clients requesting a locked resource. The original client is unable to obtain a shared server and thus cannot release the resource lock.
Solution
The system automatically starts new servers to break the deadlock until the number of servers reaches the MTS MAX SERVERS value. If this problem occurs frequently, increase the value of the initialization parameter MTS SERVERS or MTS MAX SERVERS to ensure that more shared servers are available at the next restart of the instance.
