====== 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||