To determine available user table data space, you must take non-user table data space allotments into account.
You must determine how much space these allotments need and subtract that space from the available table space.
The nonuser table space allotments that
must be accounted for are those in the following list.
- Overhead space, including space reserved for allocation maps and related statistics.
- Depot area, which includes cylinders reserved as a staging
area for modified-in-place data blocks before they are written to their home
disk destinations.Data blocks that are not modified in place are not written to the depot area.
- Tables area, which includes the following.
- Data Dictionary (for the WAL log and system tables)
- Crashdumps user
- User temporary space
- User spool space
The following topics describe specific space requirements and provide equations with which to determine variable space requirements.