AWR Data Warehouse Repository using Autonomous Database

In Oracle Enterprise Manager (OEM) there is the ability to host an AWR Data Warehouse which enables you consolidate all your detailed performance data of all your database and store in a central location.

This enables you to do long-term analysis trend across your AWR data to determine, performance, capacity impact on the databases in your IT estate.

In OEM 13.5, Oracle now supports the AWR Warehouse repository for Autonomous Data Warehouse.

If you don’t have the infrastructure or capacity to store AWR data on-premise, you can now send your data to the Autonomous Data Warehouse (ADW) in Oracle Cloud (OCI).

There are enormous benefits to using Autonomous Data Warehouse (ADW). One of many benefits is that you can scale up/down cpu and storage whilst the database remains online.

Continue reading “AWR Data Warehouse Repository using Autonomous Database”

Discover Autonomous Database in Enterprise Manager (EM)


In Enterprise Manager (EM) release 13.4 and 13.5, the Autonomous Database can be discovered as a target along with your other target databases on-premise deployments.

In this post I will share with you on how easily you can discover your Autonomous Database.

Continue reading “Discover Autonomous Database in Enterprise Manager (EM)”

Enterprise Manager (EM) Reports using Grafana

Oracle Enterprise Manager (EM) repository has a wealth of operational data (for host, database, middleware, apps and engineered systems) that it collects including configuration and metrics. By using Grafana, you can tap into that data to get Rich Analytics and Visualisations for Reporting.

Let’s have a look at how you can do this.

This assumes you already have an EM deployment running.

The following is a summary of steps to enable EM reporting using Grafana:

1. Review the EM App for Grafana Certification
2. Install Grafana OS Package
3. Deploy EM App for Grafana Plugin
4. Configure EM for Grafana Settings
5. Enable Network Rules for Grafana Console
6. Configure Grafana Data Source
7. Access Dashboards

Continue reading “Enterprise Manager (EM) Reports using Grafana”

Upcoming Live Webinar Series – Explore the latest innovations in Oracle Enterprise Manager

Exciting news, the long awaited Oracle Enterprise and Cloud Manageability Virtual Classroom Series has been announced and will run this October and November.

The series will include:

  • 7 sessions running weekly from October 13 2020
  • 12+ Oracle experts
  • Live presentations
  • Demos
  • Q&A

During the virtual classes, you will get to explore the latest and greatest innovations Enterprise Manager has to offer.

This is a great opportunity for you to learn and benefit from using Enterprise Manager to manage on-premise and cloud deployments for:

  • Databases
  • Middleware
  • Oracle apps (eg. EBS)
  • Engineered Systems (eg. Exadata, ZDLRA, PCA)

To register please visit:
Oracle Enterprise and Cloud Manageability Virtual Classroom Series