OCI Database Management
With Database Management Cloud Service, DBAs get a unified console for on-premises and cloud databases with lifecycle database management capabilities for monitoring, performance management, tuning, and administration. Use advanced database fleet diagnostics and tuning to troubleshoot issues and optimize performance. Optimize SQL with real-time SQL monitoring and simplify database configurations.
Oracle delivers the best of Oracle Enterprise Manager as a cloud service. DBAs no longer have to maintain the system, freeing up time to focus their high-value skills. In addition, key innovations like Database Fleet Automation simplify and speed database fleet management for both on-premises and databases deployed on Oracle Cloud Infrastructure (OCI).
Introduction to Oracle Cloud Infrastructure Database Management.
Explore Database Management
Fleet monitoring and management
Compartment and group monitoring
View, monitor, and obtain insights such as the inventory or the number of Oracle Databases across a database compartment or group. See status, alarms, CPU, and Storage usage. Fleet Summary enables monitoring of multiple Oracle Database services deployed across OCI compartments or Groups from a single screen.
Root cause analysis
Proactively detect and identify the root cause of performance issues across a fleet of databases and respond to performance and configuration related alerts.
Database fleet automation
Automate database fleet management for better operational efficiency. Define routine database jobs that will run against a set of databases on a schedule.
Database groups
Manage by groups
Create groups of Oracle databases for monitoring and managing them together, simplifying oversight.
Bulk SQL operations
Use templates as a powerful way to create and run bulk SQL operations.
CDB and PDB management
Group databases by their purpose; for example, group by container databases (CDB's) and pluggable databases (PDB's) spanning compartments, then use bulk SQL operations to automate lifecycle operations.
Database summary
Key performance metrics
Use a cloud console to monitor DB time and average active sessions to evaluate database performance.
Throughput metrics
Monitor IO throughput and bandwidth from a cloud console to proactively detect throughput bottlenecks.
Tablespace and storage usage
Display system storage and user data storage broken down by usage in system tablespaces and user data. User data storage is broken down by usage in the top five user tablespaces.
Jobs
SQL templates
Package SQL scripts in templates to run in bulk across databases in a group. These can be used to automate scheduled database maintenance tasks.
Automate DevOps jobs
Create templates that automate bulk SQL jobs across all databases in a group, like DevOps jobs using your custom SQL, PL/SQL scripts.
Automate developer jobs
Developers can create templates to address needs across compartments within a group. Apply jobs as templates to run your own SQL scripts against a single database or a Group.
Quick start: Get more insight on databases using OCI Database Management dashboards capability
Murtaza Husain, Director, Product Management, Oracle
With the new Dashboards capability available in the Oracle Cloud Infrastructure (OCI) Database Management service, you have access to powerful data visualization options that gather real-time data and displays it in widgets.
Read the complete postFeatured blogs
- November 3, 2022Top Activity Lite for efficient real-time database performance monitoring
- August 25, 2022Enhanced alarms and monitoring capabilities in OCI Database Management
- August 24, 2022TCPS support for cloud databases for OCI Database Management
Database Management use cases
-
Manage a fleet of databases running on Oracle Cloud Infrastructure and on-premises
Monitor and manage OCI databases from a unified console using the best of Oracle Enterprise Manager delivered as a cloud service.
-
Run SQL jobs on a group of databases
Run user-defined SQL jobs on database groups, for example, to conduct pre-release checks to databases under test.
Resources
Access Database Management documentation
You may also be interested in
Oracle Application Performance Monitoring
End user monitoring and diagnostics
Get started with Database Management
Try Oracle Cloud Free Tier
Get started with the 10GB free tier.
Contact Us
Contact an expert for more information about Database Management.