Entering content frameProcedure documentation Checking Freespace for Objects in Tablespace  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Oracle to check the freespace for objects in a tablespace. The information you see helps to decide whether to extend a tablespace. It can also be useful when you reorganize the database.

You can also use this procedure to check which tablespaces would overflow if an additional number of extents were assigned.

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

Procedure

  1. To check the objects in all tablespaces of the database:
    1. Choose Tablespace Administration ® Check free space of objects in all tablespaces.

      2. SAPDBA prompts you for the threshold number of extents that would cause tablespace overflow. For example, if you specify two, then SAPDBA displays all objects that would cause overflow if two new extents were added.

    2. Enter the threshold number of extents which would cause overflow.

SAPDBA checks all tablespaces and displays a list of the objects (that is, tables or indexes) for which the additional number of extents you specified would cause the corresponding tablespace to overflow.
  1. To check the objects in a single tablespace:
    1. Choose Tablespace Administration ® Tablespace and enter the tablespace that you want to check.

      2. SAPDBA validates and enters the tablespace name into the appropriate menu option.

    2. Choose Tablespace Administration ® Check free space of objects in tablespace <name that you just entered>

      3. SAPDBA prompts you for the threshold number of extents that would cause tablespace overflow. For example, if you specify two, then SAPDBA displays all objects that would cause overflow if two new extents were added.

    3. Enter the threshold number of extents which would cause overflow.

SAPDBA checks the chosen tablespace and displays a list of the objects (that is, tables or indexes) for which the additional number of extents you specified would cause the corresponding tablespace to overflow.

Result

You have now checked the amount of freespace in the tablespace or tablespaces. See Preventing Tablespace Overflow for information on how to interpret the results to prevent tablespace overflow.

Leaving content frame