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