products:promonitor:6.8:monitorsguide:oracle:oracletablespaces

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

ParameterDescription
ActiveTo enable/disable a rule.
Tablespace nameA filter on the tablespace name
Monitored itemSelect the metric to monitor
ThresholdThe 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.
SeverityIf not DISABLED, send an alarm if the table space is in error. Will be ignored in case of multi threshold syntax.
Auto clearIf checked, the alarm will be cleared as soon as the alarm condition is not met anymore.
Alarm tagThis 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.
AlarmTo enable alarm sending
MetricTo enable metric sending
ReportNot used at the moment

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
ORACLE_DATABASE_TBLSPC_SIZE_MBMBTABLE_SPACE
ORACLE_DATABASE_TBLSPC_FREE_SPACE_MBMBTABLE_SPACE
ORACLE_DATABASE_TBLSPC_FREE_SPACE_PERCENTAGE%TABLE_SPACE
ORACLE_DATABASE_TBLSPC_USED_SPACE_MBMBTABLE_SPACE
ORACLE_DATABASE_TBLSPC_USED_SPACE_PERCENTAGE%TABLE_SPACE
ORACLE_DATABASE_TBLSPC_FRAGM_FREE_CHUNKSTABLE_SPACE
ORACLE_DATABASE_TBLSPC_FRAGM_LARGEST_CHUNK_MBMBTABLE_SPACE
ORACLE_DATABASE_TBLSPC_FRAGM_INDEXINDEX
ORACLE_DATABASE_TBLSPC_NOT_AUTOEXTENDTABLE_SPACE
ORACLE_DATABASE_TBLSPC_EXTEND_ABILITYTABLE_SPACE
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/oracle/oracletablespaces.txt · Last modified: 2022/10/25 12:05 by rbariou