Multiple choice

Where is free space managed for a tablespace created with automatic segment-space management?

  1. In the extent

  2. In the control file

  3. In the data dictionary

  4. In the undo tablespace
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

With automatic segment-space management (ASSM), free space is tracked using bitmaps stored in the segment header itself (within the extent), not in the data dictionary or control file. This eliminates contention on dictionary tables and improves space management efficiency. Undo tablespaces store rollback data, not free space maps.

Keep practicing — related questions