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

DRG-50943: query token too long on line string on column string

1 Answers  


ORA-19621: archivelog range has already been specified

1 Answers  


ORA-38774: cannot disable media recovery - flashback database is enabled

1 Answers  


ORA-09270: szalloc: error allocating memory for security

1 Answers  


IMP-00078: Cannot translate FILE locator to "string" "string" in server character set

1 Answers  






ORA-19922: there is no parent row with id string and level string

1 Answers  


ORA-00269: specified log file is part of thread string not string

1 Answers  


PCB-00010: SQLCHECK value in EXEC ORACLE statement exceeds command line value

1 Answers  


TNS-00309: Connection Manager: Failed to open log while re-reading parameter data

1 Answers  


PLS-00363: expression 'string' cannot be used as an assignment target

1 Answers  


QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-16794: Database Guard is ON for primary database

1 Answers  


Categories