Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 73 of 220
INSTANCE_NUMBER
is an Oracle9i Real Application Clusters parameter that can be specified in parallel mode or exclusive mode. It specifies a unique number that maps the instance to one free list group for each database object created with storage parameter FREELIST GROUPS
.
The INSTANCE
parameter of the ALTER TABLE ... ALLOCATE EXTENT
statement assigns an extent to a particular free list group. If you set INSTANCE_NUMBER
to the value specified for the INSTANCE
parameter, the instance uses that extent for inserts and for updates that expand rows.
The practical maximum value of this parameter is the maximum number of instances specified in the CREATE DATABASE
statement. The absolute maximum is operating system-dependent.
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|