Procedure documentationTable Sizes Locate this document in the navigation structure

 

In the Space user menu of the DBA Cockpit you can find, among other things, a display of statistics about table size and table growth in the Table Sizes user menu. The current table sizes are determined by a report and saved in a database table which forms the history of table sizes and table growth. You can view, among other things, the statistical data in the Table Sizes user menu.

Procedure

Determining Statistical Data

If necessary, you will have to determine the statistics data for the tables. You have the following options to do this:

  • Schedule the action Update Table Statistics in the DBA planning calendar every week.

    The database must be in the ONLINE operational state at the time of executing the task. To schedule the action  Update Statistics Tables, proceed as described in  Scheduling an Action .

  • You can also update the table statistics once in the DBA Cockpit.

    The database must be in the ONLINE operational state at the time of executing the task. Open the DBA Cockpit (transaction DBACOCKPIT) and select   Space   Table Sizes  . Choose the Update Table Statistics function to start the background job that updates the statistics.

Result

The system determines the table sizes and their growth. The system determines the index sizes. The runtime depends on the fill level of the database instance and the number of tables you are analyzing. The measurement data is logged in the following areas:

  • Table SDBCCMS: The measurement data from the tables can be viewed in the DBA Cockpit in the Table Sizes user menu.

  • Spool/Screen: The measurement data from the tables and their indexes can be either printed out or downloaded for other provider’s tools.

  • Table ADATABSIZE (only for the basis database of the SAP system): You can use the SQL Studio database tool to access the measurement data and the indexes in the ADATABSIZE table directly.

Displaying Table Size

Once the statistical data has been determined, you can display it as follows: Open the DBA Cockpit (transaction DBACOCKPIT) and select   Space   Table Sizes  .

Result

You can choose from the following displays:

  • Tables with Greatest Growth: You can set the comparison time period, comparison interval, and the number of tables displayed.

  • Largest Tables: You can set the date and number of tables displayed.

  • Growth of a Table You can set the table name and the display period.

You can display all statistics as graphics. The following functions are available:

  • Delete Statistics Data: You can delete statistics data manually by specifying a time period/date or automatically by specifying a time period (in weeks).

  • Update Table Statistics: Note that table statistics information is saved only once a day. Any older daily statistics are overwritten.