Oracle Server Manager Release 2.3.2 Addendum

Managing Database Storage

Coalescing a Tablespace

The new Coalesce option in the Tablespace menu coalesces (defragments) a tablespace. Coalescing a tablespace improves system performance by consolidating blocks of data and providing larger contiguous blocks of available free space.

Note: For an Oracle database prior to release 7.3, the Coalesce menu item is not available.

To coalesce a tablespace, select a tablespace in the object list then choose Coalesce from the Tablespace menu. The Tablespace folder and menu are shown in Figure 2 - 1.

Figure 2 - 1. Tablespace Folder and Menu

Coalesce Columns

In the Tablespace folder, two new columns, % Extents Coalesced and % Blocks Coalesced, have been added to the object lists. These columns display values from 0 to 100.

Low percentages in the coalesce columns indicate that the tablespace is fragmented. The Coalesce option of the Tablespace menu defragments a tablespace and increases the percentages in the % Extents Coalesced and % Blocks Coalesced columns.

Note: For an Oracle database prior to release 7.3, the % Extents Coalesced and % Blocks Coalesced columns display N/A (not available).

For more information about the COALESCE option of the ALTER TABLESPACE command, refer to Oracle7 Server SQL Reference. For more information about administering an Oracle database, see the Oracle7 Server Administrator's Guide.

Rollback Object List

PENDING OFFLINE has been added to the list of possible values for the Status of the rollback segment. This value indicates that the rollback segment was taken offline while it was busy.