The latest release of Autonomous Database (which, as you should already know, covers both Autonomous Data Warehouse and Autonomous Transaction processing) has brought integration with Oracle Management Cloud (OMC). This is great news for cloud DBAs and cloud Fleet Managers since it means you can now monitor all your Autonomous Database instances from within a single, integrated console.
Oracle Management Cloud is a suite of integrated monitoring, management services that can bring together information about all your autonomous database instances so you can monitor and manage everything from a single console. In a much broader context where you need to manage a complete application ecosystem or data warehouse ecosystem then Oracle Management Cloud can help you eliminate multiple management/system information silos and infrastructure data, resolve issues faster across your complete cloud ecosystem, and run IT like a business.
Each Autonomous Database instance has its own service console for managing and monitoring that specific instance (application database, data mart, data warehouse, sandbox etc). It has everything you, as a DBA or business user, needs to understand how your database is performing and using resources.
To date this has been the console that everyone has used for monitoring. But, as you can see, this service console only shows you what’s happening within a specific instance. If you have not looked at the Service Console before then checkout Section 9 in the documentation (in this case for Autonomous Data Warehouse but the same applies to ATP) Managing and Monitoring Performance of Autonomous Data Warehouse.
As more and more business teams deploy more and more Autonomous Database instances for their various projects, the challenge has been for anyone tasked with monitoring all these instances: how to get a high-level overview of what’s been deployed and in use across a whole organization? That’s where Oracle Management Cloud (OMC) comes in….the great news is that OMC monitoring of Autonomous Databases is completely free!
The purpose of this post is to look at the newly released integration between Autonomous Database and the Oracle Database Management part of Oracle Management Cloud’s. Let’s look at how to set up Oracle Database Management to discover your Autonomous Databases, how to monitor your Autonomous Database instances and check for predefined alerts and how to use the Performance Hub page.
This is what we are aiming to setup in this blog post….the Oracle Database Fleet Home page which as you can see is telling me that I have 8 autonomous database instances - 6 ADW and 2 ATP instances - and 7 of those instances are up and running and one is currently either starting up or shutting down (identified as yellow).
Before you get started with OMC it’s worth taking a step back and thinking about how you want to manage your OMC instance. My view is that it makes sense to create a completely new, separate cloud account which will own your OMC instance (or instances if you want to have more than one). It’s not a requirement but in my opinion it keeps things nice and simple and your DBAs and fleet managers then typically won’t need access to the individual cloud accounts being used by each team for their autonomous database projects.
So the first step is probably going to be registering a new cloud account and setting up users to access your OMC instance. Once you have a cloud account setup then there is some initial user configuration that needs to be completed before you can start work with OMC instance. The setup steps are outlined in the documentation - see here. To help you I have also covered these steps in the PowerPoint presentation which is provided at the end of this blog post.
Starting from your My Services home page, click on the big “Create Instance” button and find the “Management Cloud” service in the list of all available services…
…this will allow you to provide the details for your new OMC instance
Oracle Cloud will send you an email notification as soon as your new OMC instance is ready, but it only takes a few minutes and then you can navigate to the “Welcome” page for your new instance which looks like this:
The next step is setup “Discovery Profiles” for each your cloud accounts. This will require a lot of the IDs and information that were part of the user account setup process so you may want to look back over that stage of this process for quick refresh. As you can see below, a discovery profile can be configured to look for only autonomous data warehouse instances or only autonomous transaction processing instances or it can search for both within a specific cloud account. Of course if you have multiple cloud accounts (maybe each department or project team has their own cloud account) then you will need to create discovery profiles for each cloud account. This gives you the ultimate flexibility in terms of setting up OMC in a way that best suits how you and your team want to work.
There is more detailed information available in the OMC documentation, see here. The discovery process starts as soon as you click on the “Start” button in the top right-hand corner of the page. It doesn’t take long but the console provides feedback on the status of the discovery job. Once the job or jobs have completed you can navigate to the “Oracle Database” option in the left-hand menu which will bring you to this page - Oracle Database Fleet Home.
You can customise the graphs and information displayed on this page. For example the heat map in the middle of the page can display metrics for: DB Time, execution rate, network I/O, space used or transaction rate. You can switch between different types of views: listing the data as a table rather than a graph:
and because there is so much available data there is a Filter menu that allows you to focus on instances that are up or down, ADW instances vs. ATP instances, database version, and you can even focus in on a specific data center or group of data centers. Once you have setup your filters you can bookmark that view by saving the filters…
In the section headed “Fleet Members”, clicking on one of the instances listed in name column will drill into the performance analysis for that instance. This takes all the information from the Fleet Home page and brings the focus down to that specific instance. For example, selecting my demo instance which is the last row in the table above brings me to this page…
You will notice that this contains a mixture of information from the OCI console page and service console page for my demo instance so it provides me with a great overview of how many CPUs are allocated, database version, amount of storage allocated, database activity and a list of any SQL statements. A sort of mash-up of my OCI console page and service console page. If you then go to the Performance Hub page, we can start to investigate what’s currently happening within my demo instance…
as with the previous screens I can customize the metrics displayed on the graph although this time there is a huge library of metrics to choose from:
and OMC allows me to drill-in to my currently running SQL statement (highlighted in blue in the above screenshot) to look at the resource usage..
and I can get right down to the SQL execution plan…
As you can see Oracle Management Cloud takes monitoring of your autonomous database instances to whole new level. Now you can get a single, integrated view for managing all your autonomous database instances, across all your different cloud accounts and across all your data centres. For cloud DBAs and cloud Fleet Managers this is definitely the way to go and more importantly OMC is free for Autonomous Database customers.
If you are already using OMC to monitor other parts of your Oracle Cloud deployments (mobile apps, GoldenGate, data integration tools, IaaS, SaaS) then monitoring Autonomous Database instances can now be included in your day-to-day use of OMC. Which means you can use a single console to manage a complete application ecosystem and/or a complete data warehouse ecosystem.
For cloud DBAs and cloud Fleet Managers life just got a whole lot easier! Happy monitoring with Oracle Management Cloud.
Step-by-Step setup guide in PDF format is here.
Autonomous Data Warehouse documentation is here.
Autonomous Transaction Processing documentation is here.
OMC documentation for Autonomous Database is here.