Table Sizes

In the Statistics user menu (OLTP/ liveCache) you can find, among other things, a display of statistics about table sizes and growth in the user menu Table Sizes.

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 Size user menu.

Determining Statistical Data

If necessary, you will have to determine statistical data.

Procedure

You have the following options:

·        Schedule the action update table statistics in the DBA planning calendar every week.
The database instance must be in the operational state ONLINE 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 Database Assistant or liveCache Assistant.
The database instance must be in the operational state ONLINE at the time of executing the task. Choose the function Table Statistics in the user menu Statistics
® Table Sizes to start a background job that updates the statistics.

Result

The system determines the table sizes and growth. The index sizes are determined.

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 Database Assistant/liveCache Assistant in the Table Sizes 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 instance of the SAP system)

You can use the SQL Studio database tool to access the measurement data and the indexes in the table ADATABSIZE directly.

Displaying Table Size

Once the statistical data has been determined, you can display it as follows:

Procedure

...

       1.      Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10).

       2.      Choose Statistics ® Table Sizes.

Result

You can choose from the following displays:

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

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

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

You can display all statistics as graphics.

The following functions are available:

·        Delete Statistics Data
Deletion can be done manually by specifying a time period/date or automatically by specifying a time period (in weeks).

·        Update Table Statistics
Note that the table statistics information is saved only once a day.
Older daily statistics, if any, are overwritten.