CLUSTER_DATABASE_INSTANCES

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_TUNING parameter has been deprecated.

Note:

1. This parameter was introduced in Oracle9i.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘CLUSTER_DATABASE_INSTANCES’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
cluster_database_instances	1	TRUE	FALSE	FALSE	FALSE	FALSE	number of instances to use for sizing cluster db SGA structures

Oracle initializatoin parameters