Quickly Monitor and Manage Databases with a Cloud Service

January 25, 2022 | 5 minute read
Timothy Mooney
Director, Product Marketing
Text Size 100%:

For DevOps, developers, DBAs, and IT team members looking for a quick and robust way to monitor and manage databases, these highlights from a technical session may be good news. Oracle experts describe top uses for Oracle Cloud Infrastructure Database Management Service and specifically around managing databases in a multicloud or hybrid cloud environment using a cloud-based solution. This session was part of Oracle Observability and Management at Oracle Database World and this session can be found here.

 

Challenges
Hybrid multi-cloud database management challenges

 

Databases are Everywhere Making it Challenging to Monitor Them

Oracle Product Managers, Steve Lemme and Sriram Vrinda do a great job showing DBAs, IT administrators, and developers some new cloud-based technology for quickly monitoring and managing databases whether it’s for an overview or for deep database analytics.

Are you facing any of these challenges?

They start by walking us through a sampling of the challenges they see when they talk to administrators and developers. While the advantages of deploying in the cloud are well known, there are new challenges administrators are facing when managing databases. For example, are you seeing many more applications deployed than ever before? Many of which are more complex to deploy, monitor, and update. While the cloud does help by offloading some administrative work, it often means IT is learning and using more tools and methods to administer database assets. All this complexity leads to additional manual effort when troubleshooting application slowdowns or issues. And that is before considering developers, who want to move quickly and need easy self-service provisioning and access to the databases that their code interacts with.

Benefits
Database Management Service overview of benefits

 

A Managed Database Management Cloud Service

This is where Sriram and Steve go into Oracle’s Database Management Cloud Service, which is designed to address the challenges of managing databases in a typical modern multi-dimensioned environment.  When considering best practices in managing databases, first, you want an overview of all your assets, including top-level performance metrics, all summarized and normalized in a single view with notifications for warnings and critical issues. Next, you want to drill down into any issues or areas of interest for further detail. You double-click into your areas of interest to quickly find the root cause of issues and get lower-level diagnostics. Finally, to manage many databases at scale, you want to have the option to run fleet-wide or group-wide jobs, or scripts to automate processes including updates, and security checks.

Feature overview
OCI Database Management Service overview of features

 

Key Characteristics and Use Cases to Apply the OCI Database Management Service

Kernel-level Oracle Database diagnostics

First, Sriram points out the depth of detail Oracle can bring in providing database diagnostics. It’s reassuring to see all the information Oracle gives you access to, including the deep instrumentation into the Oracle Database kernel. The Database Management service leverages this information and highlights that data with modern graphics and visualizations to deliver intuitive insights and interactive views of all your databases, deployed anywhere.

Cloud-based service

It’s built in the cloud, which means Oracle does all the upgrades, patching and takes care of all the infrastructure to scale and maintain the management environment. You can have confidence everything stays current and secure while enabling you to spend more time taking care of what you care about, your databases.

Key use cases

  • Monitor and manage databases everywhere, especially making it fast and easy to support new implementations on any cloud or on-premises
  • Proactively identify and fix performance problems before they occur on production systems whether on cloud or on-premises
  • Managing databases across multiple clouds

Diving Deeper with Active Session History (ASH) and the Performance Hub

Performance Hub

Combining and summarizing key data in one place has always been a key feature, and you see this again in the Performance Hub. It’s an integrated view of system-wide to session-specific database activity all starting from a single screen. Most DevOps people will appreciate overview resources like Automatic Database Diagnostic Monitor (ADDM), which is great for analyzing the Automatic Workload Repository (AWR) for potential performance bottlenecks without needing to have the experience of a DBA to get basic information.

Active Session History

(ASH) and Real-time SQL monitoring are often used by DBAs to dive deeper, using their expertise and the diagnostics to identify finer-grained immediate issues.  ASH is a tool that samples database characteristics and analyses key data over time. The auto-sampling is captured and displayed in the tool, where you can look at top activities across the databases you are monitoring.

Guided resolution workflows

Along with the many diagnostics provided, you will also find the guided resolution workflows on the Performance Hub. Use these analyzers to compare resolution options along with what results to expect from each option.

RAC monitoring
Monitoring Oracle Real Application Clusters

 

Monitoring Oracle Real Application Clusters

Many companies run their largest and most important databases on Oracle Real Application Clusters. Monitoring RAC is another key capability of the Database Management cloud service, where attributes like DB Time and Average Active Sessions are summarized along with Cluster metrics like interconnect traffic and Cluster wait events.

Setting Up Database Management Cloud Service

As you might expect, Oracle's Database Management cloud service is popular, especially for cloud and new database deployments. To get set up quickly, use the resources listed.

Timothy Mooney

Director, Product Marketing

Experience across business development, product management, product marketing in computer hardware to cloud services.


Previous Post

Incident Response and Management using Oracle Enterprise Manager 13.5 with PagerDuty

Desiree Abrokwa | 3 min read

Next Post


How Confident Are You? - Database Configuration and Compliance Management

Steve Lemme | 3 min read