• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• Availability
  • General
    • Dynamically Change Oracle Data Guard Broker Fast-Start Failover Target
    • Simplified Database Parameter Management in Oracle Data Guard Broker
    • Observe-only Mode for Oracle Data Guard Broker's Fast-Start Failover
    • Propagate Restore Points from Primary to Standby Site
    • Flashback Standby Database When Primary Database is Flashed Back
    • Oracle Data Guard Multi-Instance Redo Apply Works with the In-Memory Column Store
    • Active Data Guard DML Redirection
    • PDB Recovery Catalog
    • Clear Flashback Logs Periodically for Increased Fast Recovery Area Size Predictability
    • New Parameters to Tune Automatic Outage Resolution with Oracle Data Guard
    • Finer Granularity Supplemental Logging
  • Sharding
    • Support for Multi-Shard Query Coordinators on Shard Catalog Standby Databases
    • Generation of Unique Sequence Numbers Across Shards
    • Support for Multiple PDB Shards in the Same CDB
    • Multiple Table Family Support for System-Managed Sharding
    • Propagation of Parameter Settings Across Shards
• Application Development
  • Application Express
    • Improved Create Application Wizard
    • REST Enabled SQL Support
    • Social Sign-In Authentication
    • Web Source Modules
    • Improved Create Page Wizard
    • New REST Workshop
  • General
    • Application Continuity for Java: Declarative Request Demarcation
    • Application Continuity for Java: New States Management
    • Easy Connect Plus
    • Oracle Network Log File Segmentation
    • SQL*Net: Auto-Detection of Support for Out-of-Band Breaks
  • JSON
    • Materialized View Support for Queries Containing JSON_TABLE
    • JSON Update Operations
    • SQL/JSON Syntax Simplifications
    • JSON Object Mapping
    • New SQL/JSON Function JSON_SERIALIZE and JSON Data Guide Support for GeoJSON Data
  • SQL
    • DISTINCT Option for LISTAGG Aggregate
• Big Data and Data Warehousing Solutions
  • General
    • Automatic Indexing
    • SQL Diagnostics and Repair Enhancements
    • Bitmap Based Count Distinct SQL Function
    • Big Data and Performance Enhancements for In-Memory External Tables
    • Automatic SQL Plan Management
    • Real-Time Statistics
    • High-Frequency Automatic Optimizer Statistics Collection
    • Hybrid Partitioned Tables
  • Machine Learning for Python
    • Oracle Machine Learning for Python (OML4Py)
• Database Overall
  • Automated Installation, Configuration and Patching
    • Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode
    • Ability to Relocate a PDB to Another CDB Using DBCA in Silent Mode
    • Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode
    • Simplified Image-Based Oracle Database Client Installation
    • Root Scripts Automation Support for Oracle Database Installation
    • Support for Dry-Run Validation of Oracle Clusterware Upgrade
  • AutoUpgrade and Database Utilities
    • AutoUpgrade for Oracle Database
    • Oracle Data Pump Ability to Exclude ENCRYPTION Clause on Import
    • Oracle Data Pump Allows Tablespaces to Stay Read-Only During TTS Import
    • Oracle Data Pump Support for Resource Usage Limitations
    • Oracle Data Pump Test Mode for Transportable Tablespaces
    • Oracle Data Pump Prevents Inadvertent Use of Protected Roles
    • Oracle Data Pump Loads Partitioned Table Data One Operation
    • Oracle Data Pump Allows Wildcards for Dump File in Object Store
    • Oracle Data Pump Import Supports More Object Store Credentials
• Diagnosability
  • General
    • Oracle Trace File Analyzer Support for Using an External SMTP Server for Notifications
    • Oracle Cluster Health Advisor Integration into Oracle Trace File Analyzer
    • Oracle Trace File Analyzer REST API Support
    • Oracle Trace File Analyzer Search Extended to Support Metadata Searches
    • Oracle ORAchk and Oracle EXAchk REST Support
    • Oracle ORAchk and Oracle EXAchk Support for Encrypting Collection Files
    • Oracle ORAchk and Oracle EXAchk Support for Remote Node Connections Without Requiring Passwordless SSH
    • Oracle ORAchk and Oracle EXAchk Now Show Only the Most Critical Checks by Default
    • Oracle Trace File Analyzer Supports New Service Request Data Collections
• Performance
  • General
    • SQL Quarantine
    • Database In-Memory Wait on Populate
    • Resource Manager Automatically Enabled for Database In-Memory
    • Memoptimized Rowstore Fast Ingest
    • Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
    • Resource Manager Automatically Enabled for Database In-Memory
    • High-Frequency SQL Plan Management Evolve Advisor Task
    • Workload Capture and Replay in a PDB
    • MAX_IDLE_BLOCKER_TIME Parameter
• RAC and Grid
  • General
    • Standard Edition High Availability
    • Parity Protected Files
    • Secure Cluster Communication
    • Automated PDB Relocation
    • Zero-Downtime Oracle Grid Infrastructure Patching
    • Automated Transaction Draining for Oracle Grid Infrastructure Upgrades
    • Oracle Restart Patching and Upgrading
    • Colocation Tag for Client Routing
    • Optional Install for the Grid Infrastructure Management Repository
    • Resupport of Direct File Placement for OCR and Voting Disks
    • Dynamic Services Fallback Option
• Security
  • General
    • New ALTER SYSTEM Clause FLUSH PASSWORDFILE_METADATA_CACHE
    • Transparent Online Conversion Support for Auto-Renaming in Non-Oracle-Managed Files Mode
    • Support for Additional Algorithms for Offline Tablespace Encryption
    • Key Management of Encrypted Oracle-Managed Tablespaces in Transparent Data Encryption
    • Support for Host Name-Based Partial DN Matching for Host Certificates
    • New PDB_GUID Audit Record Field for SYSLOG and the Windows Event Viewer
    • New EVENT_TIMESTAMP_UTC Column in the UNIFIED_AUDIT_TRAIL View
    • Passwords Removed from Oracle Database Accounts
    • Signature-Based Security for LOB Locators
    • Unified Auditing Top-Level Statements
    • Privilege Analysis Now Available in Oracle Database Enterprise Edition
    • Support for Oracle Native Encryption and SSL Authentication for Different Users Concurrently
    • Ability to Grant or Revoke Administrative Privileges to and from Schema-Only Accounts
    • Automatic Support for Both SASL and Non-SASL Active Directory Connections
    • Database Vault Operations Control for Infrastructure Database Administrators
    • Database Vault Command Rule Support for Unified Audit Policies
    • SYSLOG Destination for Common Unified Audit Policies
• New Features in 19c Release Updates
  • Release Update 19.4 Features
  • Release Update 19.5 Features
  • Release Update 19.6 Features
  • Release Update 19.7 Features
    • SQL Macros (SQM)
  • Release Update 19.8 Features
    • Database In-Memory Base Level
    • CellMemory Level
  • Release Update 19.9 Features
    • Oracle Grid Infrastructure SwitchHome
    • Support for DBMS_CRYPTO Asymmetric Key Operations
  • Release Update 19.10 Features
    • Ability to Use Multiple Kerberos Principals with a Single Database Client
    • DBMS_CLOUD Package
    • New Database Initialization Parameters for Database Resident Connection Pooling (DRCP)
    • Oracle Blockchain Table
    • Oracle Instant Client Support for Linux for ARM
    • Support Per-PDB Capture for Oracle Autonomous Database
    • Updated Support for Micro Edition Suite (MES) for FIPS 140.2
  • Release Update 19.11 Features
    • Application Continuity Protection Check
    • Immutable Tables
    • New Database Initialization Parameter for Database Resident Connection Pooling (DRCP)
    • Oracle Fleet Patching and Provisioning Zip Copy Image Transfer
  • Release Update 19.12 Features
    • Gradual Database Password Rollover for Applications
    • Oracle Memory Speed Support for PMEM Devices
  • Release Update 19.13 Features
  • Release Update 19.14 Features
  • Release Update 19.15 Features
  • Release Update 19.16 Features
    • Enhancements for Identity and Access Management Integration with Oracle Database Environments
    • Oracle Data Guard Redo Decryption for Hybrid Disaster Recovery Configurations
  • Release Update 19.17 Features
  • Release Update 19.18 Features
    • All Time Zone Files (DST) Included in Release Updates (RUs)
  • Release Update 19.19 Features
  • Release Update 19.20 Features
    • In-Memory Eligibility Test
  • Release Update 19.21 Features
    • AutoUpgrade Automates Data Guard Operations During Database Upgrade
    • AutoUpgrade Automates Steps Required for Oracle RAC Database Upgrade
    • AutoUpgrade Automates Upgrade and Conversion of Non-CDB to PDB
    • AutoUpgrade Automates Upgrade of a PDB via Unplug-Plug-Upgrade
    • AutoUpgrade Release Update (RU) Upgrades
    • AutoUpgrade Sets Parallelism Based on System Resources
    • AutoUpgrade Supports Upgrades with Keystore Access to Databases Using TDE
    • AutoUpgrade Unplug-Plugin Upgrades to Different Systems
    • FPP Integration with AutoUpgrade
    • Oracle Database Automates Database Upgrades with AutoUpgrade
    • REST APIs for AutoUpgrade
  • Release Update 19.22 Features
    • Enabling Scrambled Dequeues and Dequeue Flow Control
    • Enhanced Online DDL Capabilities in the Presence of Supplemental Logging
  • Release Update 19.23 Features
    • Session Exit on Invalidation
  • Release Update 19.24 Features
  • Release Update 19.25 Features
  • Release Update 19.26 Features
  • Release Update 19.27 Features
  • Release Update 19.28 Features
    • DBMS_DEVELOPER PL/SQL Package
    • Enhancements to RADIUS Configuration
    • IF [NOT] EXISTS Syntax Support
    • Multi-Factor Authentication for Database Authentication
    • Oracle Database Cloud Backup Module for Azure Blob Storage
    • Oracle Update Advisor Support with Oracle FPP
    • Restricting Access to DBA_TAB_STAT_PREFS, CDB_TAB_STAT_PREFS, CDB_TAB_PENDING_STATS, and CDB_IND_PENDING_STATS to DBAs Only
    • Schema Annotations
    • SQL Diagnostic Report
  • Release Update 19.29 Features
    • Ability to Control Heartbeats in United Mode and Isolated Mode PDBs
  • Release Update 19.30 Features
    • PRE_PAGE_SGA
    • Restricting Directory Paths for PDBs Configured Without PATH_PREFIX
  • Release Update 19.31 Features
    • Kerberos Constrained Delegation for DBLink