Oracle Tablespaces

Purpose

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.

Monitored item

Available metrics to monitor:

Size in MB

Free space in MB

Free space %

Used space in MB

Used space %

Fragmentation: Number of chunks

Fragmentation: Largest chunk in Mb

Fragmentation: Index

Tablespace is not auto extensible (Threshold ignored)

Tablespace is auto extensible (Threshold ignored)

Configuration hints

Create a new rule and select the tablespace metric to monitor.

Then set the threshold for the metric value. For that you must you the multi syntax threshold:

G2W:90 (Send a WARNING alert if value goes above 90 - Green To Warning)<br/>

W2M: (Send a MAJOR alert if value goes above 95 - Warning To Major)<br/><br/>

You can create any number of rules than necessary and set multiple thresholds levels for each metrics. You can also create rules for a specific table space file.

Surveillance table

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

Generated metrics

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