Freelist group

From Oracle FAQ
Jump to: navigation, search

Freelist groups are useful in RAC environments where it can be used to reduce contention when processes from multiple cluster instances insert or update the same table.

With multiple freelist groups, extra segment header blocks are defined, one for each freelist group of the table or index.

Freelists and freelist groups are ignored when using ASSM. Starting from Oracle 9i, ASSM is preferred.

[edit] Example

CREATE TABLE tab1 (col1 NUMBER)
STORAGE (FREELIST GROUPS 2);

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #