Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Integer |
Default value | 1 |
Modifiable | No |
Range of values | Any nonzero value |
Basic | No |
Real Application Clusters | Multiple instances must have the same value. |
CLUSTER_DATABASE_INSTANCES
is a Real Application Clusters parameter that specifies the number of instances that are configured as part of your cluster database. You must set this parameter for every instance. Normally you should set this parameter to the number of instances in your Real Application Clusters 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
. Note that the PARALLEL_AUTOMATIC_TUNIG
parameter has been deprecated.
See Also:
Oracle Database Performance Tuning Guide for more information on tuning parallel execution
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide for information on Real Application Clusters