Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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. 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index