Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 8 - RAC Administration

Manual Space Management

Figure 8.5 Multiple Free List Groups in a segment header

The process free lists are created when the freelist group clause is used in a create TABLE/ALTER TABLE statement.

For example:

CREATE TABLE sales
( . . . )
STORAGE (INITIAL 10M NEXT 10M
MINEXTENTS 2 MAXEXTENTS 512
PCTFREE 20 PCTUSED 60 PCTINCREASE
FREELIST GROUP 2 FREELISTS 6 );

You can also specify the freelist and freelist group parameters for other objects such as indexes and clusters.  

For example:

CREATE INDEX sales_index ( . . . )

STORAGE ( FREELIST GROUP 3 FREELISTS 4) ;

Storage Parameters

freelists: Specifies the number of free lists for each of the free list  groups of the schema object.

freelist groups: The number of groups of free lists for the database objects you are creating. Oracle uses the instance number of Oracle Real Application Cluster instances to map each instance to one free list group.