Red Hat NETWORK SATELLITE 5.1.1 - RELEASE NOTES, Справочное руководство

Страница: 248 / 268

Appendix C. Probes
236
Field Value
Critical Maximum Redo Log Space Request Rate
Warning Maximum Redo Log Space Request Rate
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 allow a table to grow. 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 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). 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 matches 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
metric: