Red Hat NETWORK 3.6 - Informações Técnicas descarregar pdf (Página 178)

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 conﬁgured when the table is created. Extents are conﬁgured 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 conﬁgured 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 conﬁgured 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 ﬁelds 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

1 2 ... 173 174 175 176 177 178 179 180 181 182 183 ... 197 198

Sem comentários

Red Hat NETWORK 3.6 - Informações Técnicas Página 178