SAP/Oracle Database Monitor: Status of the Data

To display the status of the data:

Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.

Alternatively, use transaction code DB02.

The information on the Database Performance: Tables and Indexes screen is subdivided into various sections. The most important display screens are explained below:

Database system

In this section, you will find general information on the database:

the name of the database
the time when the details of this screen were generated

The table shows the analysis functions available.

Database system analysis function

Pushbutton	Explanation
Refresh	Updates the statistics on the entire screen. Choose this option only if absolutely necessary, as it can take a long time to determine all the information depending on the size of the database.
Check	Consistency Checks, Extent Analysis (Oracle)
Space statistics	Displays the database history.

Tablespaces

In this section, you will find overview information on all tablespaces of the SAP system: number, size, freespace, information on freespace problems.

The table shows the analysis functions available.

Tablespaces analysis functions

Pushbutton	Explanation
Current sizes	Tablespace analysis
Space statistics	Displays tablespace history
Freespace statistics	Freespace analysis

See also:

Tablespace Analysis (Oracle)

Tables and indexes

In this section, you will find overview information on all tables/indexes of the SAP system: number, size, number of objects with more than one extent, number of objects missing in the database, number of objects missing in the ABAP Dictionary, number of objects with freespace problems.

The table shows the analysis functions available.

Tables and indexes analysis functions

Pushbutton	Explanation
Detailed analysis	Analysis of individual objects
Missing indexes	Missing Indexes
Space critical objects	Displays storage-critical objects
Space statistics	Displays the history of tables/indexes