You specified extent management as local for a tablespace. How will it affect space management in
the tablespace?
A.
All the extents will be of the same size.
B.
Bitmap will be used to record free and allocated extents.
C.
Free extents will be managed by the data dictionary tables.
D.
The tablespace will be system managed and the users cannot specify the extent size.
Tablespaces that record extent allocation in the dictionary, are called dictionary managed tablespaces, and tablespaces that record extent allocation in the tablespace header, are called locally managed tablespaces.
Advantages of Locally Managed Tablespaces:
Eliminates the need for recursive SQL operations against the data dictionary (UET$ and FET$ tables)
Reduce contention on data dictionary tables (single ST enqueue)
Locally managed tablespaces eliminate the need to periodically coalesce free space (automatically tracks adjacent free space)
Changes to the extent bitmaps do not generate rollback information
Extents are allocated thru bitmaps
structures are bitmaps in which each bit represents a single exten