Oracle Corporation
11/15/2024 | Press release | Distributed by Public on 11/14/2024 23:27
OCI Database Management: Level up your Autonomous Database
The Autonomous Database (ADB) helps resolve the overhead of administration efforts associated with traditional databases. It is a self-driving, modular "vehicle" to adopt for building powerful, scalable applications with low effort, quickly. For customers utilizing ADB for custom workloads; oftentimes, additional insights into database workload is necessary to ensure optimum performance of the application for end users.
The Database Management service (DBM) in OCI now provides easy-to-use tools that enable advanced monitoring and management of ADB resources, delivering enhanced insights and ensuring optimal performance for applications running on the database. Along with existing features, the service provides a full suite of capabilities for monitoring and administrating your entire ADB fleet:
In-depth application performance details
Database fleet overview to monitor all databases in one location
Performance Hub for real-time monitoring of database workload
AWR Explorer to visualize AWR data over time
AWR and ADDM reports for in-depth performance analysis
SQL Monitoring to view top and current running SQL statements with detailed execution statistics
SQL performance tuning to optimize database performance
Administration tasks and details
Storage administration tasks in an easy-to-use GUI interface
User administration to track configuration and details of database users
Parameter configuration to update and monitor database configuration parameters
Database jobs to streamline collections and run at scale utilizing Database Groups
Database Management ADB tools
Figure 1: New features in Database Management for ADB
Optimize application's performance running on ADB
All new performance administration capabilities are available for ADB's in Database Management. Obtain performance recommendations for specific SQLs running against the ADB by invoking the SQL Tuning Advisor. This powerful tool provides recommendations on tuning a query's performance by iterative tests comparing execution plans for the most efficient access to the data objects in the database. Quickly get started by creating a SQL tuning set comprised of your application workflow. All SQL plan details are stored as an object in the database which offers quick integration into the SQL Tuning Advisor for analysis on access.
Once created, you can utilize the SQL Plan Management feature to assess current configuration of SQL profiles running in your ADB. Rich visualizations provide quick analysis of the overall performance of plans, such as how often they are executed, running in the ADB.
The AWR Explorer converts traditional AWR data into rich visualizations which reduces the effort and time to pinpoint performance issues in your database. Granular performance details from individual snapshots are exposed over longer periods of time to quickly assess degradation of performance in the ADB. You no longer need to worry about how the AWR wait metrics are aggregated and averaged over report snapshot intervals which dilutes the capability of exposing intermittent anomalies.
Figure 2: AWR Explorer provides visualization of AWR metrics over timeCaption
Finally, the Optimizer Statistics feature provides detailed analysis into the statistics collections of database objects. Without up-to-date statics, the Optimizer will not be able to provide the best SQL plans for accessing the data in the underlying tables.
Administer Autonomous Database with minimal console navigation
New visualizations in the alert log console for managed databases in DBM allows quick assessment and attention to critical Oracle errors generated in the ADB.
Storage utilization and administration capabilities are provided in a single, easy-to-use console in Database Management. View allocations of ADB tablespaces and quickly perform storage administration tasks for ADB-D databases.
View the Users console with detailed user information including expiration date of passwords and profile details. Parameter configuration details and administration are a single click away. This includes editing modifiable parameters and downloading parameter files for your ADB.
Finally, jobs can be run against the database with SQL, PL/SQL, DML, and DDL as input for collection to object storage. These can be one-time runs or scheduled collections to generate custom reports and analytics. These jobs provide scalability as they can be run against a group of databases.
These new features are available for all ADBs except those running on Exadata Cloud@Customer deployments which will be supported at a later date. Certain metrics and Performance Hub features continue to be available free of cost for ADBs; however, you must to enable Database Management to use the advanced monitoring and management features. These features are available at an additional cost, which can be calculated using the Cost Estimator. For detailed information, see Diagnostics & Management Feature Support Matrix for Oracle Databases..
Enable Database Management for ADB
Figure 3: Easily enable Database Management for your ADB
If you have applications running on ADB, you should utilize the DBM service in OCI to achieve maximum application performance for end users. Quickly assess all ADBs health in your fleet, utilize new tools for optimizing SQL performance, and run at scale with database jobs against your ADB databases. DBM simplifies the management of ADBs across the entire fleet.
Resources:
Database Management videos
Database Management blogs
OCI Database Management documentation