Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Monday, 16 May 2016

ORA-00104

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

Please provide your feedback in the comments section above. Please don't forget to follow.