Free lists
When an object (for example, a table) is created, one or more Oracle blocks are allocated to that object; as we’ve mentioned, each allocation is called an extent. Storage is allocated according to the current STORAGE parameters. Oracle maintains a list of blocks available in each tablespace called the free block list. As blocks are added to a table, either through the allocation of an additional extent or by deleting data from an existing block, they are added to the endof the free block list. Since Oracle allocates data to blocks by searching for a free block starting at the beginning of the free block list, these newly freed or allocated blocks will be the last blocks used.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
