Show TOC

Data for the Screen: Database Performance: Tables and IndexesLocate this document in the navigation structure

Data for the Screen: Database Performance: Tables and Indexes

Screen Database Performance:Tables and Indexes: SAP/Oracle Database Monitor: Status of the Data.

You can use the analysis options on this screen to get detailed information on the data of the database system. These details are updated regularly by report RSORATDB ( The Database Collector in Background Processing). The Database system section shows the time of the last analysis.

Choose Refresh if you require more up-to-date status data. RSORATDB is then started again. You should only use this option if absolutely necessary, as it can take a long time to determine all the information depending on the size of the database.

 

Database system

 

Refresh

RSORATDB is started immediately to update all statistical data.

Checks

Up-to-date statistics are created, and some statistics already generated with RSORATDB are displayed. Details on extents and missing indexes are always up-to-date.

Space statistics

History of database size. These values are read from table MONI.

Tablespaces

 

Current sizes

These details were determined during the last RSORATDB run.

Space statistics

History of tablespace size. These values are read from table MONI.

Freespace statistics

These details were determined during the last RSORATDB run.

Tables and indexes

 

Detailed analysis

These details were determined during the last RSORATDB run.

Missing indexes

RSORATDB examines the database for missing indexes.

Space critical objects

These details were determined during the last RSORATDB run.

Space statistics

History of table/index size. These values are read from table MONI.