Description
It monitors table space free, table space used, table space util, temp table space free, temp table used, temp table space util, and it works for Oracle 11g database version onwards. It is applicable on all the on-premise Oracle databases.
Prerequisites
The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal. While applying the template, the database port, SID or Service Name, connection timeout need to be specified.
Metric Parameters
Parameter | Description |
---|---|
Frequency | Warning Threshold | If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user. |
Critical Threshold | If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user. |
Alert | The alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user. |
Metrics
oracle.table.space.util
Metric Details
Applicable for | Device |
Description | It monitors the table space utilization |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | % |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | GREATER_THAN_EQUAL | Ends with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with |
Warning Threshold | 80 | 0-100 |
Warning Repeat Count | 1 | 1-12 |
Critical Operator | GREATER_THAN_EQUAL | Ends with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with |
Critical Threshold | 90 | 0-100 |
Critical Repeat Count | 1 | 1-12 |
Alert | Yes | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
oracle.table.space.used
Metric Details
Applicable for | Device |
Description | It monitors the table space used |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | Mb |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
oracle.temp.table.space.free
Metric Details
Applicable for | Device |
Description | It monitors temporary table space free |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | Mb |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
oracle.temp.table.space.used
Metric Details
Applicable for | Device |
Description | It monitors temporary table space used |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | Mb |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
oracle.temp.table.space.util
Metric Details
Applicable for | Device |
Description | It monitors temporary table space utilization |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | % |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | GREATER_THAN_EQUAL | Ends with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with |
Warning Threshold | 80 | 0-100 |
Warning Repeat Count | 1 | 1-12 |
Critical Operator | GREATER_THAN_EQUAL | Ends with, ==, !=, >=, <=, >, <, In Range, Out of range, Equals, Not equals, Equals Ignore Case, Not Equals Ignore Case, Contains, Not contains, Regex match, Regex no match, In string list, Not in string list, In List, Not in list, Starts with |
Critical Threshold | 90 | 0-100 |
Critical Repeat Count | 1 | 1-12 |
Alert | Yes | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
oracle.table.space.free
Metric Details
Applicable for | Device |
Description | Validates the size allocated for the table by database. |
Category | Application |
Collector Type | Gateway |
Monitor Name | Oracle Table Space |
Unit | MB |
Possible Inputs
Metric | Input Value | Range of Values |
---|---|---|
Frequency | 5 | 1 – 1440 (mins) |
Filter | ||
Warning Operator | ||
Warning Threshold | ||
Warning Repeat Count | ||
Critical Operator | ||
Critical Threshold | ||
Critical Repeat Count | ||
Alert | No | Yes/No |
Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph