ORA-00104 deadlock detected; all public servers blocked waiting for resources
Oracle Database Error Code Messages ORA-00104 Help About Description;
Deadlock detected; all public servers blocked waiting for resources.
Cause for Error and Problem;
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 Solve;ORA-00104 deadlock detected; all public servers blocked waiting for resources?
Action for Solve and Fix Ora-00104;
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.
Next Post Ora-00910;
