Select Page

Oracle Monitoring with AWS CloudWatch and Oracle OEM

Cindy Putnam | | 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.

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.

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine over 100 logins on the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?

JP Chen | October 1, 2015

Work with Us

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

CONTACT US

Work for Us

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

EXPLORE JOBS