|
Index >
ORACLE Server Parameters >
max_shared_servers
max_shared_servers
Oracle 11.1.0:
| Parameter Name: | max_shared_servers
| | Description: | max number of shared servers
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
| Parameter Name: | max_shared_servers
| | Description: | max number of shared servers
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
| Parameter Name: | max_shared_servers
| | Description: | max number of shared servers
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
| Parameter Name: | max_shared_servers
| | Description: | max number of shared servers
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
No such parmeter in Oracle 8.1.7.
Oracle 8.0.6:
No such parmeter in Oracle 8.0.6.
Oracle 7.3.4:
No such parmeter in Oracle 7.3.4.
Related Error Messages:
ORA-00104: deadlock detected; all public servers blocked waiting for resourcesCause: 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.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ max_shared_servers ]
on the Oracle FAQ.
| 
