Table of Contents
- Title and Copyright Information
- 1 Introduction
- About
- Feature Highlights
- AI Vector Search
- JSON Relational Duality
- Operational Property Graphs in SQL
- Microservice Support
- Lock-Free Reservations
- Kafka APIs for TxEventQ
- JavaScript Stored Procedures
- Priority Transactions
- Data Use Case Domains
- Many Data Type 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 AI Vector Search
- Vector Data Type
- Vector Indexes
- AI Vector Search: SQL Execution
- Vector Utility API
- Chainable Utility Functions for Vectors
- Support for ONNX-Format Models as First-Class Database Objects
- AI Vector Search: Optimizer
- AI Vector Search: PL/SQL
- JDBC Support for Vector Data Type
- Oracle Call Interface Support for Vector Type
- Support of Vector Data Type in JSON Type (OSON)
- 3 Application Development
- JSON
- JSON-Relational Duality
- JSON Schema
- XML and JSON Search Index Enhancements
- Changes for JSON Search Index and Data Guide
- Comparing and Sorting JSON Data Types
- DBMS_AQ Support for JSON Arrays
- EMPTY STRING ON NULL for JSON Generation
- Enhancement to JSON_TRANSFORM
- JSON Data Guide Format FORMAT_SCHEMA
- JSON Type Modifiers
- JSON Type Support for External Tables
- JSON-to-Duality Converter
- JSON-to-Duality Importer
- JSON/JSON_VALUE will Convert PL/SQL Aggregate Type to/from JSON
- JSON_ARRAY Constructor by Query
- JSON_BEHAVIOR Parameter to Override ON ERROR Default
- JSON_EXPRESSION_CHECK Parameter
- JSON_TRANSFORM Operators ADD_SET and REMOVE_SET
- LOBs Returned by SQL Functions for JSON can be Value-Based
- New JSON Data Dictionary Views
- ORDERED in JSON_SERIALIZE
- Precheckable Constraints using JSON SCHEMA
- Predicates for JSON_VALUE and JSON_QUERY
- SCORE Ancillary Operator for JSON_TEXTCONTAINS()
- SODA Enhancements
- Tools to Migrate JSON Text Storage to JSON Type Storages
- WHERE Clauses in JSON-Relational Duality Views
- SQL
- Schema Annotations
- Direct Joins for UPDATE and DELETE Statements
- IF [NOT] EXISTS Syntax Support
- New Database Role for Application Developers
- Aggregation over INTERVAL Data Types
- Automatic PL/SQL to SQL Transpiler
- Client Describe Call Support for Tag Options
- DEFAULT ON NULL for UPDATE Statements
- DESCRIBE Now Supports Column Annotations
- Data Use Case Domain Metadata Support in OCCI
- Data Use Case Domains
- Error Message Improvement
- Extended CASE Controls
- GROUP BY Column Alias or Position
- Improved TNS Error Messages
- Multilingual Engine Support for SQL BOOLEAN Data Type
- 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 UPDATE RETURN Clause Enhancements
- 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
- RDF Graph: Execute Graph Analytics Algorithms with RDF Graphs
- Microservices
- General
- .NET Metrics
- Dynamic Performance Views for Table and Partition Access Tracking
- 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
- ODP.NET: OpenTelemetry
- Oracle Call Interface (OCI) Support for String Indexed PL/SQL Associative Arrays
- Result Cache Integrity Mode
- SQL*Plus ARGUMENT Command
- SQL*Plus CONFIG Command
- SQL*Plus OERR Command and Improved HELP Syntax
- SQL*Plus PING Command and Command Line Option
- SQL*Plus SET ERRORDETAILS Command
- SQL*Plus SHOW CONNECTION 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
- Java Support for True Cache
- Multiple Named Pools for Database Resident Connection Pooling (DRCP)
- ODP.NET Transparent Application Failover
- ODP.NET: Application Continuity
- ODP.NET: Pipelining
- 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
- Easy Connect Plus Support for LDAPS/LDAP
- Enhanced UCP Connection Borrow
- JDBC Connection Property sendBooleanAsNativeBoolean
- 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
- 4 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 in OML4SQL
- GLM Link Functions
- Improved Data Prep for High Cardinality Categorical Features
- Lineage: Data Query Persisted with Model
- Multiple Time Series
- OML4Py and OML4R Algorithm and Data Type Enhancements
- Outlier Detection using Expectation Maximization (EM) Clustering
- Partitioned Model Performance Improvement
- XGBoost Support for Constraints and for Survival Analysis in OML4SQL
- Machine Learning - Enhancements for R
- Machine Learning - Enhancements for Python
- Spatial
- 5 Data Warehousing/Big Data
- 6 Cloud Migration
- 7 Cloud Operations
- 8 High Availability
- 9 Security
- SQL Firewall
- Encryption
- Transport Layer Security (TLS) 1.3 Now Supported in Oracle Database
- Strict DN Matching with Both Listener and Server Certificates
- 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
- Changes to DBMS_CRYPTO
- New Parameter to Control the TDE Rekey Operations for Oracle Data Guard
- Audit
- Authentication
- Microsoft Azure Active Directory Integration
- 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
- Ability of OCI and Instant Client to Directly Retrieve Microsoft Entra ID (Azure AD) OAuth2 Tokens
- Microsoft Entra ID (Azure AD) Integration Now Supported on AIX, Solaris, and HPUX
- New Parameters to Specify Wallet Certificate and Keys
- mkstore Features Included in orapki
- Authorization
- Schema Privileges to Simplify Access Control
- Oracle Label Security Triggers Are Now Part of the New LBAC_TRIGGER Schema
- Oracle Data Dictionary Protection Extended to Non-SYS Oracle Schemas with Separation of Duties Protection
- GoldenGate Capture and Apply User Roles
- New Utility Functions for Finding Client Host and IP Information
- Ability to Set Tracing Using Oracle Database Vault APIs
- Fewer Parameters to Specify When Creating or Updating Controls
- Autonomous Database
- Other
- 10 OLTP and Core Database
- Availability
- True Cache
- 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
- New Duplicated Table Type - Synchronous Duplicated Table
- New Partition Set Operations for Composite Sharding
- Oracle Data Pump Adds Support for Sharding Metadata
- 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
- Blockchain Table User Chains
- Blockchain Table Row Versions
- Blockchain Table Log History
- Add and Drop User Columns in Blockchain and Immutable Tables
- Blockchain Table Countersignature
- Blockchain Table Delegate Signer
- New Special Privilege Required to Set Long Idle Retention Times for Blockchain and Immutable Tables
- Database Architecture
- General
- Unrestricted Bulk Transactions
- ACFS Auto Resize Variable Threshold
- ACFS Cross Version Replication
- ACFS Encryption Migration from OCR to OKV
- ACFS Replication Password-less SSH Setup Tool
- ACFS Replication Switchover
- ACFS SSH-less Replication
- ACFS Snapshots RMAN Sparse Backup and Restore
- ACFS Sparse Backup and Restore of Snapshots
- ACFSutil plogconfig Log Files Wrapping Info
- Automatic Parallel Direct Path Load Using SQL*Loader
- BIGFILE Default for SYSAUX, SYSTEM, and USER Tablespaces
- Bigfile Tablespace Shrink
- CEIL and FLOOR for DATE, TIMESTAMP, and INTERVAL Data Types
- Centralized Configuration Providers
- LONG_TO_LOB, a Data Pump import TRANSFORM parameter
- 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
- Automatic Storage Compression
- DBCA Silent Options Changes
- Enhanced Query History Tracking and Reporting
- Fast Ingest (Memoptimize for Write) Enhancements
- Improved Performance of LOB Writes
- Improved System Monitor (SMON) Process Scalability
- Migrate BasicFile LOBs Using the SecureFiles Migration Utility
- Ordered Sequence Optimizations in Oracle RAC
- Pluggable Database Support in Oracle Data Guard Environments
- Refreshable PDBs in DBCA
- Availability
- 11 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
- 12 Installation, Upgrade, and Patching
- 13 New Features in 23ai Release Updates
- Release Update 23.5 Features
- Archiving and Unarchiving of Gold Images
- BINARY Vector Dimension Format
- Backup, Restore, and Relocation for FPP Server
- Custom Certificates for Oracle FPP Server Authentication
- Duplicated HNSW Vector Indexes on RAC
- FPP Metadata on External Databases
- General Improvements for Oracle FPP Job Scheduler
- General Purpose Cluster Configuration
- Gold Image Based Out of Place Patching
- JSON Collections
- JSON_ID SQL Operator
- Optimized Oracle Native Access to NVMe Devices Over Fabric
- Oracle DBCA Support for PMEM Storage
- Oracle DBCA Support for Standard Edition High Availability
- Oracle Database Installer Command-Line Support
- Oracle FPP Local Mode Without Java Container
- Oracle Grid Infrastructure Installer Command-Line Support
- Oracle Grid Infrastructure Installer Improvements
- Single-Server Rolling Database Maintenance
- Store Images and Transfer Working Copies as ZIP Files
- Vector Memory Pool Automatic Management
- Verifying Digital Signature and Integrity of Installation Archive Files
- Release Update 23.6 Features
- AI Vector Search: New Vector Distance Metric
- Hybrid Vector Index
- Partition-Local Neighbor Partition Vector Index
- Persistent Neighbor Graph Vector Indexes
- Sparse Vectors
- Transactional Support for Neighbor Graph Vector Indexes
- Vector Format Output for Feature Extraction Algorithm
- GoldenGate Replication of JSON-Relational Duality Views
- JSON-Relational Duality Views: Hidden and Generated Fields
- JSON-Relational Duality Views: Add Fields With Calculated Values
- JSON Collection Views
- JSON Replication
- JSON Search Index Path Subsetting
- Replication Support for JSON Collection Tables
- CONSTRAINT_NOVALIDATE, a Data Pump Import TRANSFORM Parameter
- Disable Statistics Gathering During Autonomous Database Import Operations
- Enhancements to Oracle Data Redaction
- Parallel Index Creation Parameters for Data Pump Import
- Sessionless Transactions
- XMLTYPE_STORAGE_CLAUSE, a Data Pump Import TRANSFORM Parameter
- Release Update 23.7 Features
- AI Vector Search: Arithmetic and Aggregate Operations
- Additional Flexibility Defining JSON-Relational Duality Views
- Change Compatible to 23.6.0 to Use New AI Vector Search Features in 23.6 or Later Releases
- Cloud Developer Packages
- DBMS_DEVELOPER Package
- Dimension-Wise Arithmetic Support in PL/SQL
- Foreign Function Interface for JavaScript to Call PL/SQL Code Units
- Hybrid Vector Index for JSON
- In-Database Algorithms Support for VECTOR Data Type Predictors
- Included Columns in Neighbor Partition Vector Indexes
- JSON to Duality Migrator: Multi-Collection Import API
- JSON to Duality Migrator: Validation of Schema and Data
- Materialized Expression Columns
- Move Data Chunks Between Shardspaces
- PL/SQL BINARY Vector Support
- PL/SQL JACCARD Distance Support
- SQL Time Bucketing
- Sharding Support for AI Vector Search
- Smallfile Tablespace Shrink
- Support for Image Transformer Models with AI Vector Search Using the In-Database ONNX Runtime
- Vector Data Type Support in External Tables
- Release Update 23.5 Features