Red Hat NETWORK 3.6 -, Reference Manual

Page: 178 / 198

166 Appendix C. Probes
Field Value
Critical Maximum Redo Buffer Allocation Retry Rate
Warning Maximum Redo Buffer Allocation Retry
Rate
Table C-59. Oracle::Redo Log settings
C.9.13. Oracle::Table Extents
The Oracle::Table Extents probe monitors an Oracle database instance and collects the following
metrics:
•
Allocated Extents-Any Table — The total number of extents for any table.
•
Available Extents-Any Table — The percentage of available extents for any table.
In Oracle, table extents are how a table grows. When a table is full, it is extended by an amount of
space configured when the table is created. Extents are configured on a per-table basis, with an extent
size and a maximum number of extents.
For example, a table that starts with 10 MB of space and 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).
This 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
Table Owner
and
Table Name
fields contain a default value of
%
that will match any
table owner or name.
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
Table C-60. Oracle::Table Extents settings
C.9.14. Oracle::Tablespace Usage
The Oracle::Tablespace Usage probe monitors an Oracle database instance and collects the following