Database Management
74 Release Notes
Monitor and Manage Scheduler Jobs
You can now use Database Management to monitor and manage database scheduler jobs for a Managed Database. You can ...
Manage SQL Profiles
You can now view SQL profiles for a Managed Database and perform tasks such as enabling, disabling, dropping, and ...
Monitor SQL Firewall
You can now monitor SQL Firewall in the Security section. The new SQL Firewall tab provides visibility into SQL ...
New Autonomous AI Database Activity Overview Dashboard
You can now use the Oracle-defined Autonomous AI Database activity overview dashboard to monitor the activity, workload, and ...
Explore Database Management Using Demo Mode
You can now use demo mode in Database Management to explore monitoring and analysis capabilities without having to configure ...
Compare Period ADDM
You can now use Compare Period ADDM in Database Management to compare database performance between two time periods using ...
New Database Management Report Type in News Reports
Ops Insights News Reports now includes a Database Management report type. You can create a database fleet health summary ...
Add ZPR Security Attributes to Database Management Private Endpoints
Zero Trust Packet Routing (ZPR) security attributes can now be added to private endpoints in Database Management. You can ...
Unified Database Security Monitoring
A unified Security view that enables monitoring of users, roles, profiles, and audit settings is now available. This enhancement ...
Discover and Monitor Oracle Cloud Exadata Infrastructure
You can now discover and monitor Exadata storage servers for the following Oracle Database cloud solutions:
- Oracle ...
Database Management for MySQL HeatWave: End of Life Announcement
MySQL HeatWave support within the Database Management service has been deprecated; however, it will remain available for use until ...
SQL Performance Watch: End of Life Announcement
SQL Performance Watch support within the OCI Database Management service has been deprecated; however, it will remain available for ...
OCI Vulnerability Detection and Patching: End of Life Announcement
OCI Vulnerability Detection and Patching support within the OCI Database Management service has been deprecated; however, it will remain ...
Discover and Monitor Oracle Cloud Database Systems in Database Management
You can now discover an Oracle Cloud Database System and monitor the following components (in addition to databases) in ...
Database Management Enhancements for Autonomous Databases
In Database Management, you can now use Diagnostics & Management features for Autonomous Database on Exadata Cloud@Customer. Previously, Diagnostics ...
Use a Management Agent to Enable Database Management for ExaDB-XS
When enabling Diagnostics & Management in Database Management for Oracle Databases running on Exadata Database Service on Exascale Infrastructure ...
Oracle-defined Dashboard for HeatWave and External MySQL DB Systems
You can now use the new Oracle-defined dashboard, MySQL fleet performance, to monitor the critical performance metrics for ...
SPA Quick Check in Database Management
In SQL Performance Watch, you can now configure SPA Quick Check to validate the potential impact of a system ...
New Features in Database Management for Heatwave and External MySQL
This release of Database Management for HeatWave and External MySQL introduces the following enhancements:
- Database Management features ...
Bulk PDB Enablement and Monitoring
For Oracle Cloud Databases, you can now bulk enable Diagnostics & Management for a CDB and its associated PDBs. ...
Patch Management in Database Management
Patch Management for Oracle Databases allows you to remediate the vulnerabilities identified through Vulnerability Detection, by using recommended security ...
ADDM Spotlight in Database Management
ADDM Spotlight aggregates the ADDM data in the database and consolidates the findings and recommendations that need to be ...
Database Management for Exadata Database Service on Exascale Infrastructure
You can now enable and use Database Management for Oracle Databases running on Exadata Database Service on Exascale Infrastructure ...
Gantt Chart in Performance Hub
Performance Hub now provides a Gantt chart that enhances SQL monitoring with a timeline view for monitoring SQL executions ...
SQL History in Performance Hub
Performance Hub provides a SQL History tab that contains granular statistics on all the SQL executions in the database. ...
Plan Control in Performance Hub
Performance Hub provides a Plan Control tab that contains details about existing SQL profiles, SQL patches, and SQL plan ...
Vulnerability Detection in Database Management
Vulnerability Detection for Oracle Databases enhances security and mitigates risk through real-time CVE insights, risk-based prioritization, automated patch recommendations, ...
Create SQL tuning sets in SQL Performance Watch
When creating a SQL Performance Analyzer task in Database Management SQL Performance Watch, you can now go to the ...
Monitor High Availability and Backups in Database Management
You can now monitor the High Availability and backup details of your fleet of primary and Oracle Data Guard-configured ...
Use Database Management for External MySQL DB Systems
You can now use Database Management to monitor and obtain comprehensive performance and configuration information for External MySQL DB ...
Search SQLs in Database Management
You can now search for the SQL statements currently running on a Managed Database or available in retained AWR ...
Use a Management Agent to enable Database Management for ExaDB-D
When enabling Diagnostics & Management in Database Management for Oracle Databases running on Exadata Database Service on Dedicated Infrastructure ...
Search sessions in Database Management
You can now specify conditions and filters to search for current sessions in a Managed Database. A dynamic search ...
Set up alarm definitions for HeatWave DB systems
You can now set up alarm definitions in Database Management for HeatWave DB systems to simplify the process of ...
Advanced Diagnostics and Management features for Autonomous Databases
In Database Management, you can now use advanced Diagnostics & Management features for Autonomous Databases Serverless and Autonomous Databases ...
SQL Performance Watch in Database Management
You can use SQL Performance Watch in Database Management to proactively predict and prevent the SQL execution performance issues ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Monitor the primary and standby ...
Database Management for Oracle Exadata Database Service on Cloud@Customer
You can now enable and use Database Management for Oracle Databases running on Exadata Database Service on Cloud@Customer. For more ...
Monitor HeatWave Clusters in Database Management
You can now use Database Management to monitor the HeatWave clusters attached to MySQL HeatWave DB systems and obtain a ...
Oracle Cloud Infrastructure Tags and Search in Database Management
Database Management now supports Oracle Cloud Infrastructure Tagging and Search services. In Database Management, you can now:
- Use ...
Named Credentials in Database Management
You can now create named credentials in Database Management to store, manage, and use database user credentials. Once a named ...
Use Database Management for MySQL HeatWave
You can now use Database Management to monitor and obtain comprehensive performance and configuration information for MySQL DB systems in ...
Set Up Alarm Definitions in Database Management
You can now set up alarm definitions in Database Management to simplify the process of creating and managing alarms.
...Instance level details in AWR Reports from Performance Hub
The Automatic Workload Repository (AWR) Report in Performance Hub has an additional option for instance level reports. You can now ...
Manage AWR snapshot collection for your database using Performance Hub
You can now customize the settings for AWR snapshot collection using the Performance Hub application in OCI. This feature helps ...
Manage SQL Tuning Sets in Database Management
You can now manage SQL tuning sets in Database Management and perform tasks such as:
- Creating SQL tuning ...
New Oracle-defined Dashboard in Database Management
The Oracle-defined Autonomous Database Performance dashboard is now available in Database Management. This dashboard provides an overview of the performance ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Use SQL plan management (SPM) ...
Discover and Monitor Exadata Storage Servers in Database Management
You can now discover the Exadata Infrastructure resource for a previously discovered DB system in the Exadata Database machine, and ...
New Services available in US Government Cloud
The following services are now available in the US Government Cloud with DISA Impact Level 5 Authorization:
Discover and Monitor External Database Systems in Database Management
You can now discover an External Database System, which is an Oracle Database System located outside of Oracle Cloud Infrastructure, ...
Database Management and Operations Insights Support ADBs Configured Using ECPU
The Database Management and Operations Insights services are certified to support Autonomous Databases that are configured using the ECPU compute ...
Automatically Generate and Add Policies for Database Management
You can now use the guided policy setup in Database Management to automatically generate and add the IAM user and ...
Database Management Support for PDBs on the Base Database Service and Exadata Cloud Infrastructure
You can now enable Database Management for Oracle Cloud Pluggable Databases (PDBs on the Base Database Service and Exadata Database ...
Top Activity Lite: A new mode in Performance Hub for live performance monitoring
Performance Hub has a new mode, called Top Activity Lite, that is optimized for live performance monitoring. This mode ...
Dashboards in Database Management
You can now use the dashboards functionality in Database Management to visualize, explore and analyze database performance metrics in easy-to-interpret ...
Preferred Credentials in Database Management
You can now set preferred credentials in Database Management to provide default connectivity to the database based on user roles ...
Enhanced Integration with Database Management
From the OCI Database Management service console, you can now access Operations Insights SQL Warehouse and Capacity Planning functionality directly ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Monitor the total number of ...
Optimizer Statistics Monitoring in Database Management
You can now monitor the optimizer statistics for a Managed Database, analyze the statistics collection tasks and Optimizer Statistics Advisor ...
TCPS Support for Oracle Cloud Databases
You can now use the TCP/IP with Transport Layer Security (TCPS) protocol when enabling Database Management for Oracle Cloud Databases. ...
A new release for Database Management is now available!
You can now:
- Monitor the alert and attention logs generated for a Managed Database in the new Alert ...
A new release for Database Management is now available!
This release has the following enhancements:
- The Last 7 days option is now available in the Time Period ...
Storage Management Enhancement
With the Storage Management enhancement, you can perform the following tasks in Database Management:
- Create or drop tablespaces ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Monitor Autonomous Databases on the ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Enable and use Database Management ...
AWR Explorer for On-premises Oracle Databases
Using AWR Explorer, you can now explore and analyze AWR data for a database being monitored by Database Management and ...
External Database Service: Support for RAC databases
You can now register and manage RAC databases located outside of Oracle Cloud Infrastructure (OCI) alongside your OCI Oracle Databases ...
Monitor and Manage RAC Databases Using Database Management
You can now monitor and manage Oracle Real Application Clusters (RAC) databases using Database Management. Database Management provides an overview ...
New Release for Database Management
A new release for Database Management is now available!
You can now:
- Monitor the tablespaces and data ...
Performance Hub for External Databases
The Performance Hub for External Databases feature extends the capability of using Performance Hub to monitor the performance of OCI ...
Performance Hub for External Databases in Database Management
Performance Hub is now available in Database Management. Using Performance Hub, you can monitor the performance of the External Databases ...
External Database service for Oracle Databases located outside of OCI
Oracle Cloud Infrastructure (OCI) now offers a way to register, manage, and monitor Oracle Databases that are located outside of ...
Database Management available in Oracle Cloud Infrastructure Console
Database Management provides comprehensive database performance diagnostics and management capabilities to monitor and manage Oracle Databases located on premises and ...