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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'

1 Answers  


ORA-02028: fetching an exact number of rows is not supported by the server

1 Answers  


ORA-37116: OLAP API table function error: (string)

1 Answers  


ORA-09793: szguns: length of user name is greater than buffer.

1 Answers  


NZE-29114: Cannot import private key.

1 Answers  






NNL-01011: Forwarding contexts freed: number

1 Answers  


ORA-02733: osnsnf: database string too long

1 Answers  


ORA-01871: the number of seconds must be less than 60

1 Answers  


NNO-00067: server reload check countdown aborted

1 Answers  


ORA-09928: Unable to restore the label of server

1 Answers  


DRG-12509: length of the stop word string exceeded the limit of string bytes

1 Answers  


LSX-00333: literal "~S" is not valid with respect to the pattern

1 Answers  


Categories