Description
This template monitors metrics like CPU usage per second, executions per transaction, cache invalidations, active sessions, user commits, table space free, long running queries, IO wait time, invalid objects, etc.
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.cpu.usage.per.sec
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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 | CLOUD_PAAS_DB |
| 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
oracle.errors
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | OracleErrors |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Errors |
| Unit |
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.library.cache.gets
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Validates the Number of Library Cache gets by database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Library stats |
| Unit |
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.library.cachereloads
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Validates the Number of Library Cache Reloads by database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Library stats |
| Unit |
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.invalidations
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Validates how many Cache invalidations on particular database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Library stats |
| Unit |
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.session.cpu_used
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the session CPU usage in seconds. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Sessions |
| Unit | s |
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.active.sessions
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the active sessions. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Sessions |
| 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.inactive.sessions
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the inactive sessions. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Sessions |
| 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.session.limit.usage
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the sessions utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Sessions |
| Unit | % |
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.session.waits
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the session waits. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle Sessions |
| Unit | s |
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.shared.pool.free
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the free shared pool memory in MB. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle SGA stats |
| 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.java.pool.free
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the free java pool memory in MB. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle SGA stats |
| 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.large.pool.free
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the free large pool memory in MB. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle SGA stats |
| 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.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
oracle.cpu.usage.per.sec
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| 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 | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| Description | The amount of CPU usage per transaction for the specific task or session. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| 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 | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| Description | The average amount of time per execution. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| Description | The average transactions per second. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| 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 | Advanced Cloud 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 | CLOUD_PAAS_DB |
| 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 | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| 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 | Advanced Cloud Oracle System Summary |
| Unit |
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 | CLOUD_PAAS_DB |
| Description | It monitors database wait time ratio. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud Oracle System Summary |
| Unit |
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.space.util
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the table space utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | User defined |
| 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 | User defined |
| 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 | CLOUD_PAAS_DB |
| Description | It monitors the table space used. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | CLOUD_PAAS_DB |
| Description | It monitors temporary table space free. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | CLOUD_PAAS_DB |
| Description | It monitors temporary table space used. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | CLOUD_PAAS_DB |
| Description | It monitors temporary table space utilization. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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 | User defined |
| 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 | User defined |
| 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 | CLOUD_PAAS_DB |
| Description | Validates the Size allocated for the table by database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud 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.invalid.objects
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Checks for invalid objects in database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud OracleDB Performance |
| 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.failed.logon.count
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | It monitors the failed logon attempts of the current user. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud OracleDB Performance |
| 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.blocking.lock.queries
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Validates how many block lock queries on particular database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud OracleDB Performance |
| 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.long.running.queries
Metric Details
| Applicable for | CLOUD_PAAS_DB |
| Description | Validates how many long running queries on particular database. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | Advanced Cloud OracleDB Performance |
| 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