Freespace Check during Reorganization of a Single (SAP Library - Database Administration (Oracle) with SAPDBA)

Freespace Check during Reorganization of a Single Object

Import check when menu item Reorganize table or index is selected.

SAPDBA first checks whether the first extent (in the case of MINEXTENTS = 1, otherwise SAPDBA carries out a space check for all requested extents) of the table or index for reorganization fits in one of the data files in the tablespace. Afterwards a check is made to see if there is enough space for all the NEXT extents that are expected during the data import.

SAPDBA determines the size of the freespace areas that will be available in the individual data files when the table or index is deleted.

When the result of the check is negative, SAPDBA does not perform the reorganization. In this case, you should extend the tablespace and/or use the option Reduce object size: yes and repeat the reorganization.

SAPDBA additionally takes reserve space into account when calculating the space required for the reorganized table or index. This reserve prevents the import operation from failing in the rare case that the space requirements of the reorganized table or index are greater than before the reorganization. This can occur, for example, if the PCTFREE values are relatively high and the PCTFREE areas are quite full. These areas are freed during reorganization. Any additional NEXT extents are requested at this time:

The reserve space corresponds to the size of the NEXT extent of the affected table or index, but is always at least 120KB.

If the appropriate reserve space is not available, you can still start the reorganization. You can simply ignore the warning message or, alternatively, cancel the reorganization.

Reorganization of Indexes

When an index is reorganized (also as a consequence of a table reorganization), SAPDBA checks whether sufficient space is available for sorting the index in tablespace PSAPTEMP.

If tablespace PSAPTEMP has less space than twice the size of the largest index for reorganization, SAPDBA issues a warning message.