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.