Determining Space Information (Oracle) 

Use

You can determine information about space and space parameters online or use existing statistics.

Procedure

  1. Choose Tools ® CCMS ® DB administration ® Data archiving, or enter Transaction DB15 in the command field.
  2. Enter an archiving object and then display the corresponding tables (see Displaying Archiving Objects and Tables).

    3. Intermediate result

    Online space provides you with information obtained from the Oracle system table DBA_TABLES. This includes the number of records, the space used, and the date the last time statistics were created by Oracle. The system also displays general information about the time and the number of the last archiving session as well as its client–dependence.

    Space statistics displays the corresponding information from the SAP tables DBSTATTORA and DBSTATIORA that are filled using statistic determining sessions ( sapdba -analyze ).

    See CCMS Support for the Cost-Based Optimizer

    If you want more details about the space and space parameters of a particular table, do the following:

  3. Select a table
  4. Choose Online space or Space statistics
  5. Alternatively, you can select a table from the display and then choose Space details.

Result

You can use the information displayed to determine what to archive. Choose Archive management to go to archive management directly, where you can plan and execute data archiving.