2.339 SHARED_SERVERS
SHARED_SERVERS
specifies the number of server processes that you want to create when an instance is started. If system load decreases, then this minimum number of servers is maintained. Therefore, you should take care not to set SHARED_SERVERS
too high at system startup.
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
If you are using shared server architecture or if the |
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
The value of this parameter should be less than |
Basic |
Yes |
Starting with Oracle Database 12c Release 1 (12.1.0.2), the SHARED_SERVERS
parameter can be set on PDBs. However, unlike most other parameters that can be set on a PDB, this parameter can only be used within a PDB to enable or disable use of shared servers for that PDB. Therefore, in a PDB, the DBA can either set SHARED_SERVERS
to 0 to disable use of shared servers for that PDB or use ALTER SYSTEM RESET SHARED_SERVERS
to re-enable shared servers for the PDB. The configuration of shared servers for the CDB can only be done in the root.
See Also:
-
Oracle Database Administrator’s Guide for more information on setting this parameter