Collector for Database Monitoring

The technical name of the Collector for Database Monitoring is /DVD/MON_CL_COL_DB.

This collector collects information about the database, also including sizes of tables or indexes available on the database or configured tablespaces.

Monitoring of tablespaces for the database is only available for system(s) with the Oracle or DB2/DB6 database.

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

KPI name	Description	Unit	Detail table
DB_CRIT_TAB_SP_P	Used space on the most critical data file (tablespace)	%	Yes
DB_FREE	Free size of database	MB	Yes
DB_INDEX_NUM	Total number of indexes	Count	Yes
DB_INDEX_SIZE	Total size of indexes	MB	Yes
DB_SIZE	Total size of database	MB	Yes
DB_TAB_NUM	Total number of tables	Count	No
DB_TAB_SIZE	Total size of tables	MB	No
DB_TS_FREE	Free size of database tablespaces	MB	Yes
DB_TS_TOTAL	Total size of database tablespaces	MB	Yes
DB_TS_USED_P	Used percentage of database tablespaces	%	Yes
DB_USED	Used size of database	MB	Yes
DB_USED_P	Used space on database	%	Yes

Input Table

This collector uses two input tables:

1. /DVD/MON_DBTS_I1 – Inputs for DB Tablespaces Monitoring Setup

The rules define which tablespaces are included in the KPI value calculation. The input table contains the following fields:

Technical name	Column name	Description
KPI	KPI name	Name of the KPI that rule applies to
TABLE_SPACE_NAME	Tablespace name	Name of the tablespace that rule applies to
VALUE_RESULT	Value result	Defines the function for requested KPI result value
CHANGED_BY	Last changed by user [automatically filled]	User who last changed the specific record
CHANGED_AT	Last changed time [automatically filled]	Time when the specific record was changed
CREATED_BY	Created by user [automatically filled]	User who created the specific record
CREATED_AT	Created at the time [automatically filled]	Time when the specific record was created

2. /DVD/MON_DBTS_I2 – Inputs for Index Monitoring Setup on DB Tablespaces

This input table is only relevant for external Oracle database monitoring, so it does not make sense to configure it for other databases.

The rules define which indexes from the external database should be included in the monitoring. The input table contains the following fields:

Technical name	Column name	Description
INDEX_NAME	Index name	Name of the index that the rule applies to
OWNER_NAME	Owner name	Name of the owner that the rule applies to
TABLE_SPACE_NAME	Tablespace name	Name of the tablespace that the rule applies to
CHANGED_BY	Last changed by user [automatically filled]	User who last changed the specific record
CHANGED_AT	Last changed time [automatically filled]	Time when the specific record was changed
CREATED_BY	Created by user [automatically filled]	User who created the specific record
CREATED_AT	Created at the time [automatically filled]	Time when the specific record was created

Detail Table

The collector provides three detail tables that store additional information for monitored tablespaces or indexes.

1. DB tablespace size statistics (all)

The technical name of the detail table DB tablespace size statistics (all) is /DVD/MON_S_DB_TABLE_SPACE. It reports the size statistics for all tablespaces configured on the database in the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to the detail table [automatically added]
SID	System ID [automatically added]
TS_NAME	Tablespace name
TS_SIZE	Total size in MB
TS_FREE	Free size in MB
TS_USED_P	Percentage of used size

2. DB tablespace size statistics (per KPI)

The technical name of the detail table DB tablespace size statistics (per KPI) is /DVD/MON_S_DB_TS_DETAIL. It reports the size statistics only for tablespaces defined in the input table /DVD/MON_DBTS_I1 for specific KPI. The detail table contains the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to the detail table [automatically added]
SID	System ID [automatically added]
KPI	KPI name
VALUE_RESULT	Defines the function for the requested KPI value result
TS_NAME	Tablespace name
TS_SIZE	Total size in MB
TS_FREE	Free size in MB
TS_USED_P	Percentage of used size

3. Database Indexes

The technical name of the detail table Database indexes is /DVD/MON_S_DB_INDEXES. It reports the index size only for indexes defined in the input table /DVD/MON_DBTS_I2 for specific owners and tablespaces. This detail table contains the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to the detail table [automatically added]
SID	System ID [automatically added]
INDEX_NAME	Index name
OWNER_NAME	Owner name
TABLESPACE_NAME	Tablespace name
INDEX_SIZE	Index size in bytes