Select Page

Oracle Monitoring with AWS CloudWatch and Oracle OEM

Author: Cindy Putnam | 2 min read | February 4, 2020

When we manage Oracle databases on the AWS platform, we find it somewhat cumbersome to monitor the database and servers in one place; whether that be Oracle OEM or AWS CloudWatch. This blog will give suggestions on how to use both OEM and CloudWatch to monitor your Oracle databases on AWS RDS.

While Oracle OEM monitors the specific database alerts such as alert log errors, failed jobs, tablespace usage etc., it does not monitor server specific issues such as CPU utilization, OS space issues and memory usage. CloudWatch can monitor those OS specific metrics.

Together, Oracle OEM and AWS CloudWatch can be configured to monitor the database environment without missing critical, possible failure/outage events.

Oracle OEM Monitoring

OEM monitoring should be set up using DBA and company standards for any other Oracle database.

This is an example of an OEM template used for monitoring a production database instance:


…and so on.

The metrics are quite comprehensive and monitor the database systems well.

Then AWS Cloud Watch is configured in addition to comprehensibly monitor the systems sending alerts as needed.

AWS CloudWatch Monitoring

Here are some examples of CloudWatch monitoring of an RDS server. As you can see, these metrics are inclusive of the entire RDS server, not just the database instance.

Below is an example of some of the metrics that can be quickly set up to monitor through AWS CloudWatch.

This first metric shows Average CPU Utilization, OS Storage Space, Database Connections and Memory metrics.


Swap space can also be easily monitored and reported.


This is an example of some of the throughput metrics.


Overall memory metrics…


As demonstrated, Oracle OEM monitoring and AWS RDS CloudWatch can be used in tandem to monitor your Oracle databases on the AWS RDS Cloud platform.  Through both tools, email notifications can be configured to multiple email addresses or distribution lists to assist DBAs, OS Admins and AWS architects monitor the environments with confidence and transparency at the Oracle database level and the AWS RDS level. If you’re looking for assistance with your database monitoring needs, please contact us.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

PostgreSQL vs. Oracle: Let’s Compare

Discover some key differences between PostgreSQL vs Oracle that can help you make an informed decision when deciding on a database management system.

Vijay Muthu | March 30, 2021

Oracle RMAN Backup and Recovery with Restore Points

Oracle restore points are useful for benchmark testing. Find out how you can use Oracle’s Recovery Manager (RMAN) tool to create and use restore points.

Cindy Putnam | May 3, 2019

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.