Initialization Parameters, 62 of 188

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.