An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running. This monitor is meant to watch datafiles utilization metrics.
Available metrics to monitor:
Parameter | Description |
---|---|
Active | To enable/disable a rule. |
Tablespace name | A filter on the tablespace name |
Monitored item | Select the metric to monitor |
Threshold | The threshold to use on the metric: If you set a number, the severity field will be used to define alarm severity. You can also use multi-threshold syntax. |
Severity | If not DISABLED, send an alarm if the table space is in error. Will be ignored in case of multi threshold syntax. |
Auto clear | If checked, the alarm will be cleared as soon as the alarm condition is not met anymore. |
Alarm tag | This field allows to add custom text within the alarm message. %MSG% variable will containthe actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tagwill be used as prefix. |
Alarm | To enable alarm sending |
Metric | To enable metric sending |
Report | Not used at the moment |
metricId | metricUnit | metricTarget | metricDescription |
---|---|---|---|
ORACLE_DATABASE_TBLSPC_SIZE_MB | MB | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_FREE_SPACE_MB | MB | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_FREE_SPACE_PERCENTAGE | % | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_USED_SPACE_MB | MB | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_USED_SPACE_PERCENTAGE | % | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_FRAGM_FREE_CHUNKS | TABLE_SPACE | ||
ORACLE_DATABASE_TBLSPC_FRAGM_LARGEST_CHUNK_MB | MB | TABLE_SPACE | |
ORACLE_DATABASE_TBLSPC_FRAGM_INDEX | INDEX | ||
ORACLE_DATABASE_TBLSPC_NOT_AUTOEXTEND | TABLE_SPACE | ||
ORACLE_DATABASE_TBLSPC_EXTEND_ABILITY | TABLE_SPACE |