Synopsis

Values:1 to maximum number of instances specified in CREATE DATABASE statement

Default:Lowest available number (depends on instance startup order and on the INSTANCE_NUMBER values assigned to other instances)

Multiple Instances:Must have different values

A Parallel Server parameter that specifies a unique number that maps the instance to one group of free space lists for each table created with the FREELIST GROUPS storage option. The INSTANCE option of the ALTER TABLE ALLOCATE EXTENT statement assigns an extent to a particular group of free lists. If the INSTANCE_NUMBER parameter is set to the value specified for the INSTANCE option, the instance uses that extent for inserts and for updates that expand rows.