标题: ORA-00104: deadlock detected; all public servers blocked waiting for resources [打印本页] 作者: admin 时间: 2016-7-7 15:13 标题: 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.