General
Cluster Health Monitor Improved Diagnosability
Cluster Health Monitor introduces a new diagnostic ability to listen for critical component events that could indicate pending or actual failure and report these with recommended corrective actions. In some cases, these actions may be executed autonomously. Such events and actions could then be captured and admins notified through components such as Trace File Analyzer.
Improving the robustness and reliability of Oracle AI Database hosting infrastructure is a critical business requirement for enterprises. This improved ability to detect and correct at first failure and self-heal autonomously delivers value by improving business continuity.
Diagnosability 26ai Improvements
These are existing features but changes and enhancements to functionality and default values.
Decreases time to identify and address critical events in the database. Changes tracing limits to be more reasonable than being unlimited and facilitates content identification so that customers are aware what trace data is provided to Oracle for further diagnosis.
Enhanced Cluster Health Advisor Support for Oracle Pluggable Databases
Cluster Health Advisor's (CHA) diagnostics capability is extended to support 4K pluggable databases (PDBs) from 256. This is critical for Oracle Autonomous Database deployments. CHA's problem detection and root cause analysis improves accuracy by considering database events such as reconfiguration. This improves detection, analysis, and targeted preventative actions for problems, such as instance evictions.
By adding this support to Cluster Health Advisor, performance and availability are kept in line with the deployment size. The business continuity of critical applications is preserved with improved prognostics and targeted preventive actions.
Oracle Update Advisor
Oracle Update Advisor is a software update recommendation framework that provides information to keep software at recommended versions.
Using Oracle Update Advisor simplifies software maintenance. In combination with tools such as the Database Creation Assistant (DBCA) and Fleet Patching and Provisioning (FPP), Oracle Update Advisor provides you with your software status and provides update and maintenance recommendations.
Oracle Update Advisor Support with Oracle FPP
You can leverage Oracle Update Advisor with Oracle Fleet Patching and Provisioning (Oracle FPP). Oracle Update Advisor is a software recommendation framework that analyzes the health of Oracle AI Database and Oracle Grid Infrastructure, provides patch recommendations, and creates fully functional gold images based on your patch maintenance policy. These gold images are downloaded automatically into the Oracle FPP Gold Image repository.
Using Oracle Fleet Patching and Provisioning in conjunction with Oracle Update Advisor greatly simplifies and streamlines the update experience. You can use the Oracle Update Advisor for both Oracle FPP Local Mode and Oracle FPP Central Server Mode.
SQL Diagnostic Report
The SQL diagnostic package (DBMS_SQLDIAG) includes a new function called REPORT_SQL which generates a zip archive containing a deep-level HTML diagnostic report for a specified SQL statement. The report includes important diagnostic information such as a plan history, non-default database parameters, optimizer statistics history, statistics status, index details, and more. The archive will also include, where available, captured SQL Monitor reports for the SQL.
This feature makes it easier to diagnose SQL performance issues.
Telemetry Streaming
Telemetry Streaming offers a comprehensive, turnkey solution for metrics streaming and observability with Oracle AI Database. It supports ultra-fast metrics ingestion using REST and PL/SQL. It enables users to query metrics data for monitoring and alerting purposes through SQL, PL/SQL, or PromQL (Prometheus' Query Language). Additionally, Telemetry Streaming automates data lifecycle management, including compression and downsampling for older metrics data, optimizing storage and performance over time.
Metrics streaming is essential for modern enterprise use cases, such as DevOps monitoring, asset tracking, and anomaly detection. While Oracle AI Database offers best-of-breed features for building a metrics streaming solution, assembling these components can be complex and time-consuming. Telemetry Streaming simplifies this process by packaging Oracle's powerful technologies into a streamlined, ready-to-use solution, enabling faster deployment, easier management, and reduced operational overhead for metrics streaming applications.