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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset