INSTANCE_GROUPS

Parameter type:	String
Syntax	INSTANCE_GROUPS = group_name [, group_name ... ]
Parameter class:	Static
Default value:	None
Range of values:	One or more instance group name, separated by commas
Oracle Parallel Server:	Multiple instances can have different values.
INSTANCE_GROUPS is an Oracle Parallel Server parameter that you can specify only in parallel mode. Used in conjunction with the PARALLEL_INSTANCE_GROUP parameter, it lets you restrict parallel query operations to a limited number of instances. See "PARALLEL_INSTANCE_GROUP".
This parameter specifies one or more instance groups and assigns the current instance to those groups. If one of the specified groups is also specified in the PARALLEL_INSTANCE_GROUP parameter, then Oracle allocates query processes for a parallel operation from this instance. See Also: Oracle8i Parallel Server Administration, Deployment, and Performance for more information on parallel query execution in an Oracle Parallel Server environment.