Oracle on Amazon RDS metrics and alerts
Published 26 March 2025
This documentation contains a list of metrics and alerts that are available when monitoring Oracle on AmazonRDS instances.
If you can't find a specific metric or alert you would like to use when monitoring your RDS instances, send us feedback.
Amazon RDS host metrics
To get access to machine metrics in Amazon RDS you need to provide Redgate Monitor with your AWS API credentials.
The following table summarizes the host metrics that Redgate Monitor can collect, for Amazon RDS servers, only if Amazon RDS Enhanced Monitoring is enabled for your Amazon RDS instances:
Machine: processor time |
Machine: memory used |
Network utilization |
Disk used |
Disk free |
Disk read bytes/sec |
| Disk write bytes/sec |
Disk throughput bytes/sec |
Disk transfers/sec |
Metrics
The following lists the metrics Redgate Monitor collects and exposes on the Analysis page:
Oracle on RDS metrics
Available at the instance level:
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 Amazon RDS:
- Oracle specific alerts
- Database instance error log entry
- Instance unreachable
- Long-running query
- Host alerts
- Disk space
- Internal Redgate Monitor error (host)
- Monitoring error (host data collection)
- Monitoring stopped (host credentials)
- Physical memory
- Processor under-utilization
- Processor utilization
- Oracle specific alerts
