Integer 

Static 

1 

Any non-zero value 

PARALLEL_SERVER_INSTANCES is an Oracle Parallel Server parameter that specifies the number of instances currently configured. You must set this parameter for every instance. Normally you should set this parameter to the number of instances in your Oracle Parallel Server environment. A proper setting for this parameter can improve memory use.

Oracle uses the value of this parameter to compute the default value of the LARGE_POOL_SIZE parameter when the PARALLEL_AUTOMATIC_TUNING parameter is set to TRUE.  

See Also:

• Oracle8i Designing and Tuning for Performance for more information on tuning parallel execution.

• Oracle8i Parallel Server Administration, Deployment, and Performance for information on Oracle Parallel Server.