X

The latest cloud infrastructure announcements, technical solutions, and enterprise cloud insights.

Announcing the general availability of Oracle Cloud Infrastructure Database Management

We’re pleased to announce the general availability of the Oracle Cloud Infrastructure (OCI) Database Management.

Oracle has been a leader in database management for decades, and now these unique capabilities are available in Oracle Cloud. The new Database Management service brings the best of Oracle’s industry-leading capabilities from enterprise manager into Oracle Cloud. The service gives maximum customer choice through innovations in both cloud and on-premises manageability offerings.

Oracle Database Management provides comprehensive database performance and management capability for all flavors of Oracle Databases, including OCI and on-premises, which significantly reduce the burden on DBAs by providing a full-lifecycle solution encompassing monitoring, performance management, tuning, and database administration. Database Management is part of the Oracle Cloud Observability and Management platform.

Database Management helps you prevent potential outages in your key applications. It provides performance diagnostics capabilities that simplify diagnosing performance issues for administrators and ensure quicker resolution of performance bottlenecks. The service also provides advanced management and administration of your databases to proactively detect and identify the cause of performance issues and perform database administrative operations, such as running SQL jobs across a fleet of databases.

Database Management service feature

Fleet monitoring and management

  • A unified user interface to monitor multiple Oracle Database services deployed within OCI compartments

  • Enhanced ability to proactively detect and identify the root cause of performance issues across a fleet of databases

  • Respond to performance and configuration-related alerts


Figure 1: Fleet Summary provides a single-pane-of-glass view of all Oracle Databases.

Database groups

  • A unified user interface to monitor multiple Oracle Database services deployed across OCI compartments

  • Automate database fleet management for better operational efficiency

  • Define routine database jobs that run against a set of databases on a schedule


Figure 2: Group databases by their purpose: For example, CDBs and PDBs across compartments.

Database Summary

You can monitor a specific database from the Database Summary page to monitor the following key Database metrics:

  • Database time and average active sessions

  • IO throughput and bandwidth

  • Database memory components

  • System and user tablespace


Figure 3: Monitor and manage a specific Oracle database

Jobs

Create and run jobs using your own custom SQL, PL, and SQL scripts. Jobs have the following key features:

  • Create a job.

  • View or edit the job definition.

  • Clone and delete a job.

  • Post and view results in OCI Object Storage service.


Figure 4: Create and execute a SQL job on a single or all the databases in a group.

Get started today!

You can find Database Management in the Monitoring and Diagnostics menu in the OCI Console. The service is accessible through the Console, CLI, and REST API and is already available in all commercial regions, with Government regions coming soon.

Database Management is available to use with external Oracle databases deployed on-premises. Support for Oracle Databases on Oracle Cloud Infrastructure is coming soon.

We hope that you enjoy the Database Management service! To learn more, visit the product page.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha