Oracle supported metrics
Hardware metrics:
| Metrics | Description |
|---|---|
| Type of OS | Type of OS on which DB is running (Linux/Windows etc.) |
| Architecture | Architecture of the OS |
| Host Name | Configured host name on which DB is present |
| Availability | Active/Inactive [ Availability of the DB ] |
| Average CPU Usage | Average CPU usage of the machine |
| Average Memory Usage | Average memory usage of the machine |
| Disk Usage | Disk usage on the configured host |
| CPU Usage | CPU usage on the configured host |
| Network I/O disk usage | I/O megabytes per second |
| Network I/O disk request | I/O requests per second |
Query Performance:
| Metrics | Description |
|---|---|
| Query | List of slow queries performed/available |
| Total Execution | Count of executions of each slow queries performed/available |
| Execution Time | Total execution time of each collected query |
| Timestamp | Last timestamp of each collected query |
Connections:
| Metrics | Description |
|---|---|
| Number of connections | Number of connections made for the database |
| Number of sessions | Number of session established for the database |
| Session details | User/Query list for established session |
Metrics:
| Metrics | Description |
|---|---|
| Host CPU utilization | Host CPU utilization (percentage) |
| Disk read per second | Amount of file read time. |
| Disk write per second | Amount of file write time. |
| Number if long running queries | Number of long running (> 60s) queries. |
| User Transaction | User transaction per second |
| Number of redo log file switch | Number of redo log file switch events |
| Number of redo log file waits | Number of redo log waits. |
| Hit ratio for the SGA | Hit ratio for the SGA |
| SGA cacheable memory per statement | SGA cacheable memory per statement |
| SGA cacheable memory per user | SGA cacheable memory per user |
note
Disk usage shows in GB and other metrics will be available in MB.