Oracle database error code ORA-00104 – deadlock detected; all public servers blocked waiting for resources

Oracle Database Error Code ORA-104 Description :
deadlock detected; all public servers blocked waiting for resources
Error 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.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
1 Comment   
«
»