Installation guide
For example, a table that starts with 10 MB of space and that is configured with an extent size of 1 MB
and max extents of 10 can grow to a maximum of 20 MB (by being extended by 1 MB ten times). T his
probe can be configured to alert by (1) the number of allocated extents (e.g. "go critical when the table
has been extended 5 or more times"), or (2) the table is extended past a certain percentage of its max
extents (e.g. "go critical when the table has exhausted 80% or more of its max extents").
The required T able Owner and T able Nam e fields contain a default value of % that matches any
table owner or name.
Table A.60. Oracle::T able Extents settings
Field Value
Oracle SID*
Oracle Username*
Oracle Password*
Oracle Port* 1521
Table Owner* %
Table Name* %
Timeout* 30
Critical Maximum Allocated Extents
Warning Maximum Allocated Extents
Critical Maximum Available Extents
Warning Maximum Available Extents
A.9.14. Oracle::Tablespace Usage
The Oracle::T ablespace Usage probe monitors an Oracle database instance and collects the following
metric:
Available Space Used - T he percentage of available space in each tablespace that has been used.
Tablespace is the shared pool of space in which a set of tables live. T his probe alerts the user when
the total amount of available space falls below the threshold. Tablespace is measured in bytes, so
extents do not factor into it directly (though each extension removes available space from the shared
pool).
The required T ablespace Nam e field is case insensitive and contains a default value of % that
matches any table name.
Probes
123