Announcing the general availability of Oracle Cloud Infrastructure Database Management for Oracle Databases

September 8, 2021 | 4 minute read
Sriram Vrinda
Director of Product Management
Text Size 100%:

Earlier this year, we announced the general availability of the Oracle Cloud Infrastructure (OCI) Database Management service for on-premises Oracle databases. We’re excited to announce that Database Management service now also supports Oracle Databases, which are databases running on comanaged Oracle Cloud Database services, including bare metal, virtual machines, and Exadata Cloud.

Oracle Database Management provides comprehensive database management for all flavors of Oracle Databases, significantly reducing the burden on database admins by providing a full lifecycle solution encompassing monitoring, performance management, tuning, and database administration. Database Management is part of the OCI Observability and Management platform.

Database Management options

Database Management features for Oracle Database service are available as part of two Management Options, which you can select when enabling Database Management.

The Full Management option includes all Database Management features for Oracle Database Enterprise Editions, including the following features. The Full Management option is also available for Oracle Database Standard Edition but doesn’t include Performance Hub features.

  • Monitoring and managing capabilities for your fleet of databases

  • SKU features, which include advanced Performance Hub features, such as automatic database diagnostic monitor (ADDM) and blocking sessions and other features, such as scheduled fobs, tablespace monitoring, and database parameters

  • Features available as part of Basic Management

The Basic Management option includes the following features:

  • 14 basic monitoring metrics, such as CpuUtilization, StorageAllocated, and UserCalls. These metrics are displayed in the OCI Monitoring service and on the Database Details page of the database after Database Management is enabled.

  • Active session history (ASH) analytics and SQL monitoring features in Performance Hub for multitenant container databases (CDBs). These features are not available for pluggable databases.

To learn more, watch a short demonstration of enabling Database Management for OCI databases.

Database Management service key features

Fleet monitoring and management

  • A unified user interface to monitor multiple Oracle Database services deployed within OCI and on-premises

  • 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

Performance Hub

Performance hub provides holistic performance management capabilities providing a single view of the database performance using a varied set of features, such as active session history analytics, real-time SQL monitoring, automatic database diagnostics monitoring (ADDM), and blocking sessions.

Figure 2: Performance Hub components

Automatic workload repository (AWR) explorer

As a performance analyst, you can rely on the Performance Hub to visualize the performance trend of an Oracle database. However, retaining AWR data in the production database for an extended period can be difficult. The AWR viewer is the solution that allows you to retain AWR data for longer periods of time, perform an offline analysis, compare AWR data against similar database, and so on.

Figure 3: AWR Explorer

Scheduled jobs

Create and run jobs using your own custom SQL and PL/SQL scripts against a single database or a group of databases. With scheduled jobs, you have the following capabilities:

  • Create a job.

  • Provide schedule details for the job by selecting one of the following options:

    • One time (Immediately): Select to run the job once (immediately).

    • One time (Later): Select to run the job once (later) and specify the time when it runs.

    • Repeating: Select to run a job multiple times at the specified frequency.

  • View or edit the job definition.

  • Clone and delete a job.

  • Post and view results in OCI Object Storage service.

  • Build metric queries and set up alert notifications on the job status in the OCI Monitoring service.

Figure 4: Scheduled jobs

Get started today!

You can find Database Management under the Monitoring and Diagnostics menu in the Oracle Cloud Infrastructure 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 databases (Oracle databases deployed on-premises) and Oracle Cloud databases on bare metal, virtual machines, and Exadata Cloud service.

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

Sriram Vrinda

Director of Product Management

Sriram Vrinda is an experienced Product Manager with a demonstrated history of working in the information technology and services industry. Strong product management professional skilled in Oracle Database, Autonomous Databases, MySQL Databases, IT Service Management, Solution Architect, and Pre-sales. He has helped various customers with Oracle solutions specifically around performance, availability, and scalability aspects for about 20 years.

Previous Post

Webcast: Migrate Databases with Minimal Downtime Using Enterprise Manager Database Migration Workbench

Timothy Mooney | 2 min read

Next Post

Oracle Cloud Infrastructure Database Management

Vivek Verma | 8 min read