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

Email This Post Email This Post

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 MTS_MAX_SERVERS as the system will automatically start new servers to break the deadlock until the number of servers reaches the value specified in MTS_MAX_SERVERS.

Popularity: 7% [?]

Related Post

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Close
E-mail It