How to fix the error ORA-00104: deadlock detected; all public servers blocked waiting for resources?

In this post, you’ll learn more about the Oracle ErrorORA-00104: deadlock detected; all public servers blocked waiting for resources with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-00104: deadlock detected; all public servers blocked waiting for resources

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.

How to fix the Error ORA-00104: deadlock detected; all public servers blocked waiting for resources ?

You can fix this error in Oracle by following the below steps

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.