New features of Oracle 20c:
1. Security
– Force Upgraded Password File to be Case Sensitive
– Connect to Multiple Databases with Different Certificates from a single client
– Ability to Specify the Location of the CMU Wallet and dsi.ora File with a Database Property
– Addition of USER_APPLICATION_ROLES Data Dictionary View
– Predefined Unified Audit Policies for Security Technical Implementation Guides (STIG) Compliance
– SYSLOG Destination for Common Unified Audit Policies
– Unified Audit Policies Enforced on the Current User
– Unified Audit Policy Configuration Changes Effective Immediately
– Auditing for Oracle XML DB HTTP and FTP Services
– Oracle Blockchain Table
– Enterprise User Manager Support for Per-PDB Directory Service Connections
– Ability to Set the Default Tablespace Encryption Algorithm
– Improved Performance for Wallets with Large Numbers of TDE Keys in Wallets and Oracle Key Vault
– Enhanced Database Availability with Zero Downtime to Switch Over to an Updated PKCS#11 Library
– Ability to Prevent Local Oracle Database Vault Policies from Blocking Common Operations
2. Performance and High-Availability Options
– Advanced Queuing: PL/SQL Enqueue and Dequeue Support for JMS Payload in Transactional Event Queues
– Advanced Queuing: PL/SQL Enqueue and Dequeue Support for non-JMS Payload in Transactional Event Queues
– Advanced Queuing: Transactional Event Queues for Performance and Scalability
– Advanced Queuing: Simplified Metadata and Schema in Transactional Event Queues
– Advanced Queuing: Kafka Java Client for Transactional Event Queues
– Advanced Queuing Support for JSON Data Type
– Reset Session State
– SecureFiles Defragmentation
– Automatic Index Optimization
– Automatic Zone Maps
– Automatic In-Memory
– In-Memory Hybrid Scans
– Database In-Memory External Table Enhancements
– PDB Point-in-Time Recovery or Flashback to Any Time in the Recent Past
– Autonomous Health Framework
– MAX_IDLE_BLOCKER_TIME Parameter
3. Tools and Languages
– New Analytical and Statistical Aggregate Functions
– New Data Upload
– New Form Region
– New Data Upload
– New Form Region
– New Pragma SUPPRESSES_WARNING_6009
– New PL/SQL Iterator Constructs
– New C Client Interface APIs for JSON Data Type
– New German Linguistic Sorts for Capital Sharp S Support
– New Era Support for Japanese Imperial Calendar
– New JSON Data Type
– New Oracle SQL Function JSON_TRANSFORM
– Oracle Machine Learning XGBoost Algorithm
– Oracle Machine Learning MSET-SPRT Algorithm
– Adam Optimization Solver for the Neural Network Algorithm
– SQL/JSON Syntax Improvements
– Improvements to OCI Data Interface for LOBs
– PL/SQL Support For New JSON SQL Data Type
4. Oracle Database Utilities
– Oracle Data Pump Includes and Excludes in the Same Operation
– Oracle Data Pump Resumes Transportable Tablespace Jobs
– Oracle Data Pump Parallelizes Transportable Tablespace Metadata Operations
– Oracle Data Pump Provides Optional Index Compression
– Oracle Data Pump Exports from Oracle Autonomous Database
– Oracle Data Pump Checksums Support Cloud Migrations
– Oracle SQL*Loader Supports Native JSON Data Type
– Oracle SQL*Loader Support for Object Store Credentials
5. Oracle Database Automates Database Upgrades with AutoUpgrade
6.Oracle Text
– New NETWORK_DATASTORE Data Store Type for Oracle Text
– New DIRECTORY_DATASTORE Data Store Type for Oracle Text
– New Oracle Text Index Type: Search Index
– Facet Navigation Support for JSON Search Indexes
– JSON Support in Result Set Interface
– Improved Index Synchronization and Automatic Index Optimization
– In-Memory Full Text Columns
Download a zip file containing all the books of Oracle Database 20c https://docs.oracle.com/en/database/oracle/oracle-database/20/zip/oracle-database_20.zip
References
Oracle Database Release 20c New Features. Avalilable at: https://docs.oracle.com/en/database/oracle/oracle-database/20/newft/new-features.html