Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

UDI-00002: invalid username or password

1 Answers  


ORA-02751: osnfsmmap: cannot map shared memory file

1 Answers  


ORA-13214: failed to compute supercell for window object

1 Answers  


ORA-31018: Error deleting XML document

1 Answers  


PCC-02308: identifier required in this function declaration

1 Answers  


AMD-00146: Custom Measure "string" already exists in Workspace "string"

1 Answers  


ORA-31164: cannot load object-relational XML attribute using direct path

1 Answers  


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


RMAN-03008: error while performing automatic resync of recovery catalog

1 Answers   HCL,


ORA-00114: missing value for system parameter SERVICE_NAMES

1 Answers  


ORA-01038: cannot write database file version string with ORACLE version string

1 Answers  


SQL*Loader-00251: Sort devices are not used by SQL*Loader

1 Answers  


Categories