*****************************************************************************************
***ADVANTAGES IN USING LOCALLY MANAGED TABLESPACES OVER DICTIONARY MANAGED TABLESPACES***
*****************************************************************************************
- Because locally managed tablespaces do not record free space in data
dictionary, it reduces contention on these tables.
- Local management of extents automatically tracks adjacent free space,
eliminating the need to coalesce free extents.
- Avoids recursive space management operations, which can occur in
dictionary-managed tablespaces if consuming or releasing space in an
extent results in another operation that consumes or releases space in
a rollback segment or data dictionary table.
- Sizes of extents that are managed locally can be determined automatically
by the system. Alternatively, all extents can have the same size in a
locally managed tablespace.
- Changes to the extent bitmaps do not generate rollback information
because they do not update tables in the data dictionary (except for
special cases such as tablespace quota information).
- Reduced fragmentation
Partager