Table of Contents
- Title and Copyright Information
- Preface
-
1
Oracle Database Release 19c New Features
- Application Development
-
Availability
-
General
- Simplified Database Parameter Management in a Broker Configuration
- Dynamically change Fast-Start Failover (FSFO) target
- Observe only mode for Broker's Fast_Start Failover (FSFO)
- Flashback Standby database when Primary database is flashed back
- Propagate Restore Points from Primary to Standby site
- 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 FRA size predictability
- New Parameters for tuning automatic outage resolution with Data Guard
- Finer granularity Supplemental Logging
- Sharding
-
General
-
Big Data and Data Warehousing
-
General
- SQL Diagnostics and Repair Enhancements
- Automatic Indexing
- Bitmap based count distinct SQL Function
- Big Data and Performance Enhancements for In-Memory External Tables
- Automatic Resolution of SQL Plan Regressions
- Real-Time Statistics
- High-Frequency Automatic Optimizer Statistics Collection
- Hybrid Partitioned Tables
-
General
-
Database Overall
-
Automated install, config, and patch
- Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode
- Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode
- Ability to Relocate a PDB to Another CDB 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
- Automated upgrade, migration and utilities
- General
-
Automated install, config, and patch
-
Diagnosability
-
General
- Oracle Trace File Analyzer REST API Support
- Oracle Trace File Analyzer Search Extended to Support Metadata Searches
- Oracle Trace File Analyzer Supports New Service Request Data Collections
- Oracle ORAchk and Oracle EXAchk Support for Encrypting Collection Files
- Oracle ORAchk and Oracle EXAchk REST Support
- Oracle Cluster Health Advisor Integration into Oracle Trace File Analyzer
- 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 Support for Using an External SMTP Server for Notifications
-
General
-
Performance
-
General
- SQL Quarantine
- Resource Manager Automatically Enabled for Database In-Memory
- Database In-Memory Wait on Populate
- Memoptimized Rowstore - Fast Ingest
- Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
- Real-Time SQL Monitoring for Developers
- Workload Capture and Replay in a PDB
-
General
- RAC and Grid
-
Security
-
General
- New ALTER SYSTEM Clause FLUSH PASSWORDFILE_METADATA_CACHE
- Transparent Online Conversion Support for Auto-Renaming in Non-Oracle-Managed Files Mode
- Key Management of Encrypted Oracle-Managed Tablespaces in Transparent Data Encryption
- Support for Additional Algorithms for Offline Tablespace Encryption
- Support for Host Name-Based Partial DN Matching for Host Certificates
- 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
- Unified Auditing Top-Level Statements
- Passwords Removed from Oracle Database Accounts
- Signature-Based Security for LOB Locators
- New EVENT_TIMESTAMP_UTC Column in the UNIFIED_AUDIT_TRAIL View
- New PDB_GUID Audit Record Field for SYSLOG and the Windows Event Viewer
- Database Vault Operations Control for Infrastructure Database Administrators
- Database Vault Command Rule Support for Unified Audit Policies
-
General
- 2 Oracle Database 19c Release 19.3 New Features