Freelist

From Oracle FAQ
Jump to: navigation, search

Each segment has one or more freelist (in the segment header) that keeps track of data blocks under the high-water mark.

When records are inserted into the segment, Oracle examines the freelist to determine which data blocks have available space to store the new rows. When rows are deleted (or updated), and the amount of free space in the data block falls below a threshold value (PCTUSED), the data block will be returned to the freelist.

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

[edit] Example

CREATE TABLE tab1 (col1 NUMBER)
STORAGE (FREELISTS 10);

[edit] Also see

  • ASSM - Automatic Segment Space Management
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 #