Table of Contents
- Title and Copyright Information
- Preface
-
1
Oracle Database Release 19c New Features
- Application Development
-
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
-
General
-
Big Data and Data Warehousing
-
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
-
General
-
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
-
Automated Installation, Configuration and Patching
-
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
-
General
-
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
-
General
-
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
-
General
-
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
-
General
-
2
New Features in 19c Release Updates
- Release Update 19.7 Features
- Release Update 19.8 Features
- Release Update 19.9 Features
-
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
- Release Update 19.12 Features