Description
It monitors the system statistics like User Commits, User Rollbacks, Table Scan Blocks, Redo Log Space Requests, Cache Blocks Lost, IO Wait Time and it works for Oracle 11g database version onwards. It is applicable on AWS 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.
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.user.commits
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | This metric represents the number of user commits performed per second in last two monitoring polls. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | psec |
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.redo.log.space.requests
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It represents the active log file is full and Oracle is waiting for disk space to be allocated for the redo log entries. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | Req per Sec |
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.user.rollbacks.persec
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | This metric represents the number of times, per second , that users manually issue the ROLLBACK statement or an error occurred during a user's transactions. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | psec |
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.cache.blocks.lost
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | This metric represents the number of global cache blocks lost over the user-defined observation period. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | count |
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.table.scan.blocks.persec
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Number of blocks received via table scans. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | psec |
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.io.wait.time
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | How much time the application was blocked, waiting for all I/O operation to complete |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | ms |
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.logons.per.sec
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | This metric represents the number of logons per second during the sample period. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | count |
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.db.instance.uptime
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It represents db instance uptime since start up. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit | Days |
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.check.db.alive
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Monitors connectivity to the database instance. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Stats |
| Unit |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | NOT_EQUALS_IGNORE_CASE | 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 | ACTIVE | [{"ACTIVE":"0"},{"SUSPENDED":"1"},{"INSTANCE RECOVERY":"2"}] |
| Warning Repeat Count | 1 | 1-12 |
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | Yes | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph