Oracle 19.28 - New features

Source: Dev.to

New Features in Oracle 19.28

• DBMS_DEVELOPER PL/SQL Packages – New PL/SQL package to retrieve object metadata as JSON (instead of XML), improving integration and performance for developers.
• Enhancements to RADIUS Configuration – Updated RADIUS support with RFC 6613/6614 guidelines and TLS by default, improving MFA security.
• IF NOT EXISTS Syntax Support – Adds IF EXISTS / IF NOT EXISTS syntax for DDL statements, reducing errors in scripts.
• Multi‑Factor Authentication (MFA) for Database Authentication – Native MFA support including push notifications and integration with MFA solutions (e.g., Cisco Duo, Oracle Mobile Authenticator) and PKI combos.
• Oracle Database Cloud Backup Module for Azure Blob Storage – Enables RMAN backups directly to Azure Blob Storage (on‑premises or Azure VM).
• Oracle Update Advisor Support with Oracle Fleet Patching and Provisioning (FPP) – Integrates Oracle Update Advisor with FPP for automated patch recommendations and gold image management.
• Schema Annotations – Allows storing/retrieving free‑form metadata (name–value pairs) on schema objects — useful for application metadata.
• SQL Diagnostic Report (NEW REPORT_SQL in DBMS_SQLDIAG) – New function that generates a detailed HTML diagnostic report for a specified SQL statement, including plan history, optimizer stats, index details, SQL Monitor info, etc.