ORA-00104 deadlock detected; all public servers blocked waiting for resources

Cause: 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.

Action: Increase the limit for the system parameter MAX_SHARED_SERVERS as the system will automatically start new servers to break the deadlock until the number of servers reaches the value specified in MAX_SHARED_SERVERS.

Solution doesn't works for you?
POST your error in our discussion panel below.
Our DBA team will be happy to help you :)

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments