Database Overview

This monitor in the SAP/Oracle Database Monitor lets you display the space usage on the database, including history information. It uses a collector job to periodically retrieve data from the cluster table MONI.

You choose Space Database Overview in the DBA Cockpit.

You can choose Without Duplicates on the History tab to remove any duplicates in the data.

Structure

The fields on the tab Main data are self-explanatory.

The tab History contains the following information for the sub-tab Days display (the columns are analogous for the sub-tabs Weeks and Months):

Column	Description
Date	Date of last analysis
Name	Database name
Size (Gb)	Database size in GB
Chg. Size/day	Change of database size per day in GB
Free (Gb)	Database free space in GB
Chg. Free/day	Change in database free space per day in GB
Used (%)	Percentage used space in the database
Chg. Used/day	Change in database used space per day
Users	Number of database users
Chg. Users/day	Change in number of users per day
Tablespaces	Number of tablespaces
Chg. Tablespaces/day	Change in number of tablespaces per day
Segments	Number of segments
Chg. Segments/day	Change in number of segments per day
Data (%)	Percentage of space containing data
Chg. Data/day	Change in data space per day
Temp (%)	Percentage of space containing temporary data
Chg. Temp/day	Change in temporary space per day
Tables (%)	Percentage of space containing tables
Chg. Tables/day	Change in number of tables per day
Indexes (%)	Percentage of space containing indexes
Chg. Indexes/day	Change in number of indexes per day
Others (%)	Percentage of space occupied by other objects (that is, objects other than tables and indexes, such as lobs, clusters, or rollbacks)
Chg. Others/day	Change in number of other objects per day

Each sub-tab on the History tab contains an average display separately at the top followed by detailed displays for each time period.