Type
|
Benefit
|
Drawback
|
Fixed-length
|
Performance asset — Fixed extents incur the performance impact for allocating and formatting the blocks at extent creation time. This causes minimal performance impact to the database during normal operations.
|
Full extent management — It is possible for multiple extents to fill within a cycle of extent management. You must account for this possibility in after-image planning and implementation.
|
Variable-length
|
Performance loss — When a new after-image block is required and there are no empty blocks, the database broker must allocate and format additional space from the operating system.
|
Full disks — Extents could grow to take up all of the available disk space.
Larger file management — Management of variable extents can involve working with very large files, since the extents can grow to any size. Take into account the possibility that you may need to back up or move these large files.
|