Oracle on Linux metrics and alerts
Published 19 February 2025
This documentation contains a list of metrics and alerts that are available when monitoring Oracle on Linux instances. Send us feedback if there are additional metrics or alerts you'd find valuable.
Metrics
The following lists the metrics Redgate Monitor collects and exposes on the Analysis page:
Host Linux machine metrics
Machine: processor time |
Avg. CPU queue length |
Machine: memory used |
Memory pages/sec |
Network utilization |
Disk used |
Disk free |
Disk avg. read time |
Disk avg. write time |
Disk read bytes/sec |
| Disk write bytes/sec |
Disk throughtput bytes/sec |
Disk transfers/sec |
Avg. disk queue length |
Oracle on Linux metrics
Number of active user sessions |
Number of inactive user sessions |
Number of blocked user sessions |
Number of active background sessions |
Number of inactive background sessions |
Number of blocked background sessions |
Logons / sec |
User commits / sec, |
User rollbacks / sec |
Physical reads / sec |
Long table scans / sec |
Physical writes / sec |
Short table scans / sec |
Buffer cache hit ratio |
Alerts
The following is a list of alerts available for Oracle on Linux:
- Oracle specific alerts
- Database instance error log entry
- Instance unreachable
- Long-running Query
- Host machine alerts
- Disk average read time
- Disk average write time
- Disk space
- Internal Redgate Monitor error (host)
- Machine unreachable
- Monitoring error (host machine data collection)
- Monitoring stopped (host machine credentials)
- Physical memory
- Processor under-utilization
- Processor utilization
- Oracle specific alerts
