Description
It monitors the CPU Usage Per Txn, Database CPU Time Ratio, Database Wait Time Ratio, Executions Per Sec, Executions Per Txn, User Transaction Per Sec, Response Time Per Txn, Sql Service Response Time, 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.cpu.usage.per.sec
Metric Details
| Applicable for | Device |
| Description | This metric represents the CPU usage per second by the database processes, measured in hundredths of a second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.cpu.usage.per.txn
Metric Details
| Applicable for | Device |
| Description | The amount of CPU usage per transaction for the specific task or session. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.database.cpu.time.ratio
Metric Details
| Applicable for | Device |
| Description | The Database CPU Time Ratio is of limited value as a tuning tool. The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.executions.per.txn
Metric Details
| Applicable for | Device |
| Description | The average amount of time per execution |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.executions.per.sec
Metric Details
| Applicable for | Device |
| Description | The average transactions per second |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.sql.service.response.time
Metric Details
| Applicable for | Device |
| Description | SQL Response Time is the average elapsed time per execution of a representative set of SQL statements, relative to a baseline. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| 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.user.transaction.per.sec
Metric Details
| Applicable for | Device |
| Description | The User Commits Per Sec Oracle metric data item represents the number of user commits performed, per second during the sample period. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.response.time.per.txn
Metric Details
| Applicable for | Device |
| Description | The Response Time Per Txn Oracle metric is using only statistics available within the database, this data item gives the best approximation of response time, in seconds, per transaction during this sample period. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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.database.wait.time.ratio
Metric Details
| Applicable for | Device |
| Description | It monitors database wait time ratio. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Oracle System Summary |
| Unit | NULL |
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