Table of Contents
- Title and Copyright Information
- 1 Introduction
- About
- Feature Highlights
- JSON Relational Duality
- Operational Property Graphs in SQL
- Microservice Support
- Lock-Free Reservations
- Kafka APIs for TxEventQ
- JavaScript Stored Procedures
- Priority Transactions
- Application Usage Domains
- Many Datatype and SQL Enhancements
- Up to 4096 Columns per Table
- Improved Machine Learning Algorithms
- Sharding Enhancements
- Schema Privileges
- Developer Role
- SQL Firewall
- Azure AD OAuth2 Integration
- 2 Application Development
- JSON
- JSON-Relational Duality
- JSON Schema
- XML and JSON Search Index Enhancements
- Changes for JSON Search Index and Data Guide
- DBMS_AQ Support for JSON Arrays
- Enhancement to JSON_TRANSFORM
- JSON Type Support for External Tables
- JSON/JSON_VALUE will Convert PL/SQL Aggregate Type to/from JSON
- JSON_ARRAY Constructor by Query
- JSON_EXPRESSION_CHECK Parameter
- New JSON Data Dictionary Views
- ORDERED in JSON_SERIALIZE
- Precheckable Constraints using JSON SCHEMA
- Predicates for JSON_VALUE and JSON_QUERY
- Tools to Migrate JSON Text Storage to JSON Type Storages
- SQL
- Application Usage Annotations
- Direct Joins for UPDATE and DELETE Statements
- IF [NOT] EXISTS Syntax Support
- New Database Role for Application Developers
- Aggregation over INTERVAL Data Types
- Application Usage Domains
- Automatic PL/SQL to SQL Transpiler
- Client Describe Call Support for Tag Options
- DEFAULT ON NULL for UPDATE Statements
- DESCRIBE Now Supports Column Annotations
- Error Improvement
- Extended CASE Controls
- GROUP BY Column Alias or Position
- Improved TNS Error Messages
- ODP.NET: Annotations
- ODP.NET: SQL Domain Name and Schema
- Oracle C++ Call Interface (OCCI) Support for SQL BOOLEAN Data Type
- Oracle Client Driver Support for SQL BOOLEAN Data Type
- SELECT Without FROM Clause
- SQL BOOLEAN Data Type
- SQL Domain Metadata Support in OCCI
- SQL*Plus Support for SQL BOOLEAN Data Type
- Table Value Constructor
- Unicode 15.0 Support
- Graph
- Native Representation of Graphs in Oracle Database
- Support for the ISO/IEC SQL Property Graph Queries (SQL/PGQ) Standard
- Property Graph: Native Representation of Graphs in Oracle Database
- Property Graph: Support for the ISO/IEC SQL Property Graph Queries (SQL/PGQ) Standard
- Property Graph: Use JSON Collections as a Graph Data Source
- Property Graph: Use Native Representation of Graphs in Oracle Database with Graph Tools
- Microservices
- General
- Efficient Table DDL Change Notification
- Enhanced Inter-Session Communication with DBMS_PIPE
- GB18030-2022 Support
- JDBC RSI Support for Data Load Mode
- ODP.NET: Asynchronous Programming
- Oracle Call Interface (OCI) Support for String Indexed PL/SQL Associative Arrays
- SQL*Plus ARGUMENT Command
- SQL*Plus OERR Command and Improved HELP Syntax
- SQL*Plus PING Command and Command Line Option
- SQL*Plus SET ERRORDETAILS Command
- Session Exit on Invalidation
- Unicode IVS (Ideographic Variation Sequence) Support
- Java
- JavaScript
- Application Connectivity
- Reset Database Session State
- Implicit Connection Pooling for Database Resident Connection Pooling (DRCP)
- Implicit Connection Pooling for Oracle Connection Manager in Traffic Director Mode (CMAN-TDM)
- Improved Oracle Connection Manager in Traffic Director Mode (CMAN-TDM) Pool Configuration Settings for Autonomous Database
- JDBC Enhancements to Transparent Application Continuity
- JDBC Extensions for Apps Configuration Providers
- JDBC Support for Kerberos Authentication using JAAS Configuration
- JDBC Support for Kerberos Authentication using User and Password Properties
- JDBC Support for OAuth 2.0 Including OCI IAM and Azure AD
- Multiple Named Pools for Database Resident Connection Pooling (DRCP)
- ODP.NET: Application Continuity
- ODP.NET: OpenTelemetry
- ODP.NET: Pipelining
- ODP.NET: Sharding Split Partitionset
- Oracle Call Interface (OCI) Pipelined Operations
- Oracle Call Interface (OCI) Session Pool Statistics
- Oracle Connection Manager in Traffic Director Mode (CMAN-TDM) Support for Direct Path Applications
- Oracle Connection Manager in Traffic Director Mode (CMAN-TDM) Usage Statistics
- Resumable Cursors
- Shut Down Connection Draining for Database Resident Connection Pooling (DRCP)
- UCP Support for XA Transactions with Sharded Databases
- Database Drivers API Enhancements
- JDBC Support for Database Annotation
- JDBC Support for Pipelined Database Operations
- JDBC Support for SQL BOOLEAN Data Type
- JDBC Support for Self-Driven Diagnosability
- ODBC Support for SQL BOOLEAN Data Type
- Oracle Call Interface (OCI) Support for SQL BOOLEAN Data Type
- Precompiler Support for SQL BOOLEAN Data Type
- UCP Asynchronous Extension
- UCP Support for Self-Driven Diagnosability
- JSON
- 3 Data Analytics
- General
- SQL
- Text Indexes with Automatic Maintenance
- Transportable Binary XML
- Concurrent Materialized View Refresh for on-commit
- Enhanced Automatic Indexing
- Enhanced Automatic Materialized Views
- Enhanced Automatic SQL Plan Management
- Enhanced LOB Support for Distributed and Sharded Environments
- Enhanced Parallel Processing Resources Management
- Increased Maximum Size of Inline LOBs of 8000 Bytes
- Materialized View Support for ANSI Joins
- Read-Only Value LOBs
- Semi-Join Materialized Views
- Ubiquitous Search With DBMS_SEARCH Packages
- In-Memory
- Machine Learning - Enhancements
- Automated Time Series Model Search
- Explicit Semantic Analysis Support for Dense Projection with Embeddings
- GLM Link Functions
- Improved Data Prep for High Cardinality Categorical Features
- Lineage: Data Query Persisted with Model
- Multiple Time Series
- Outlier Detection using Expectation Maximization (EM) Clustering
- Partitioned Model Performance Improvement
- XGBoost Support for Constraints and for Survival Analysis
- Spatial
- 4 Data Warehousing/Big Data
- 5 Cloud Migration
- 6 Cloud Operations
- 7 High Availability
- 8 Security
- SQL Firewall
- Encryption
- Transport Layer Security (TLS) 1.3 Now Supported in Oracle Database
- New Parameter to Control the Behavior of TLS Certificate DN Match
- Simplified Transport Layer Security Configuration
- Ability to Configure Transport Layer Security Connections Without Client Wallets
- New sqlnet.ora Parameter to Prevent the Use of Deprecated Cipher Suites
- AES-XTS Encryption Mode Support for TDE Tablespace Encryption
- Changes for TDE Encryption Algorithms and Modes
- Improved and More Secure Local Auto-Login Wallets
- Audit
- Authentication
- ODP.NET: Azure Active Directory Single Sign-On
- Increased Oracle Database Password Length
- JDBC-Thin Support for Longer Passwords
- Oracle Data Pump Export and Import Support for Longer Encryption Passwords
- Oracle Call Interface (OCI) and Oracle C++ Call Interface (OCCI) Password Length Increase
- Updated Kerberos Library and Other Improvements
- Enhancements to RADIUS Configuration
- UTL_HTTP Support for SHA-256 and Other Digest Authentication Standards
- XDB HTTP SHA512 Digest Authentication
- Authorization
- Autonomous Database
- Other
- 9 OLTP and Core Database
- Availability
- Directory-Based Sharding Method
- Oracle Globally Distributed Database Raft Replication
- Automatic Data Move on Sharding Key Update
- Automatic Transaction Quarantine
- Creating Immutable Backups Using RMAN
- Fine-Grained Refresh Rate Control For Duplicated Tables
- Global Partitioned Index Support on Subpartitions
- JDBC Support for Split Partition Set
- Managing Flashback Database Logs Outside the Fast Recovery Area
- Move Data Chunks Between Shardspaces
- New Duplicated Table Type - Synchronous Duplicated Table
- New Partition Set Operations for Composite Sharding
- Oracle Globally Distributed Database Coordinated Backup and Restore Enhancements
- PL/SQL Function Cross-Shard Query Support
- Parallel Cross-Shard DML Support
- Pre-Deployment Diagnostic for Oracle Globally Distributed Database
- Priority Transactions
- RMAN Backup Encryption Algorithm Now Defaults to AES256
- RMAN Operational, Diagnostics, and Upgrade Enhancements
- Simplified Database Migration Across Platforms Using RMAN
- Support for Oracle Database Version Specific RMAN SBT Library
- Blockchain
- Database Architecture
- General
- Unrestricted Parallel DMLs
- ACFS Auto Resize Variable Threshold
- ACFS Cross Version Replication
- ACFS Encryption Migration from OCR to OKV
- ACFS Replication Switchover
- ACFS Snapshots RMAN Sparse Backup and Restore
- ACFS Sparse Backup and Restore of Snapshots
- ACFSutil plogconfig Log Files Wrapping Info
- CEIL and FLOOR for DATE, TIMESTAMP, and INTERVAL Data Types
- Centralized Config Providers
- Oracle Data Pump Filters GoldenGate ACDR Columns from Tables
- PDB Snapshot Carousel ACFS Support
- SQL*Loader Supports SODA (Simple Oracle Document Access)
- Manageability and Performance
- Advanced LOW IOT Compression
- Automatic SecureFiles Shrink for Autonomous Database
- Automatic Storage Compression
- Enhanced Query History Tracking and Reporting
- Fast Ingest (Memoptimize for Write) Enhancements
- Improved Performance of LOB Writes
- Improved System Monitor (SMON) Process Scalability
- Pluggable Database Support in Oracle Data Guard Environments
- Refreshable PDBs in DBCA
- Availability
- 10 Diagnosability
- General
- Reduce Time to Resolve
- Add Verified SQL Plan Baseline
- CMAN Diagnostics and Logging Enhancements
- DBMS_DICTIONARY_CHECK PL/SQL Package
- Estimate the Space Saved with Deduplication
- Extent-Based Scrubbing
- High Availability Diagnosability Using the DBMS_SCHEDULER Package
- In-Memory Advisor
- Oracle Call Interface (OCI) APIs to Enable Client-Side Tracing
- Rename LOB Segment
- Selective In-Memory Columns
- 11 Installation, Upgrade, and Patching