Tuesday, 12 June 2012

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

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 automaticaly start up new servers to break the deadlock until the  number of servers reaches the value specified in MAX_SHARED_SERVERS.

No comments:

Post a Comment