Over 300 new features focused on AI and developer productivity • Generated by oramad on 15-Feb-2026
| Vector Data Type | Built-in VECTOR data type enabling AI-powered similarity searches directly within the database. |
| Sparse Vectors | Support for high-dimensional vectors with few non-zero values, ideal for keyword-sensitive search models like SPLADE and BM25. |
| BINARY Vector Dimension Format | Single-bit-per-dimension format offering 32x less storage and up to 40x faster distance computations. |
| Arithmetic & Aggregate Operations on Vectors | Apply +, -, * arithmetic and SUM/AVG aggregates directly on vector columns. |
| AI Vector Search: SQL Execution | SQL execution support for vector indexes, vector functions, and row-level restrictions on partitions. |
| AI Vector Search: Optimizer | Optimizer can now use vector indexes instead of full table scans for efficient vector queries. |
| AI Vector Search: PL/SQL | New vector type in PL/SQL with operations for similarity searches within PL/SQL blocks. |
| PL/SQL BINARY Vector Support | PL/SQL supports BINARY dimension format for vectors, matching SQL capabilities. |
| Sparse Vector Support in PL/SQL | Native sparse vector creation and usage directly from within PL/SQL. |
| Dimension-Wise Arithmetic in PL/SQL | Vector arithmetic (+, -, *) now available natively in PL/SQL without calling out to SQL. |
| Support of Vector in JSON Type (OSON) | Vector data type embedded in JSON scalar types for interoperability between SQL and JSON. |
| User-Defined Vector Distance Functions | Create custom distance metrics using JavaScript for domain-specific similarity searches. |
| Vector Data Type in External Tables | Access and search vector data stored outside the database via external tables. |
| JDBC Support for Vector Data Type | Full JDBC driver support for the VECTOR data type including metadata, conversions, and binding. |
| OCI Support for Vector Type | Oracle Call Interface supports the VECTOR data type for OCI-based applications. |
| Client Support for SPARSE Vectors | JDBC and ODP.NET client drivers now support sparse vector types. |
| JDBC Support for SPARSE Binary Vectors | SparseBooleanArray interface added for sparse binary vector data in Java applications. |
| Sharding Support for AI Vector Search | Vector tables auto-distributed across shards with parallelized similarity searches. |
| Set COMPATIBLE to 23.6.0 | New vector search features require COMPATIBLE parameter set to 23.6.0. |
| Hybrid Vector Index (HVI) | Combined full-text search and semantic vector search in a single index for higher quality results. |
| Vector Indexes (IVF) | Specialized indexing for efficient approximate similarity searches on high-dimensional data. |
| Partition-Local Neighbor Partition Vector Index | LOCAL indexing for partitioned tables enabling partition-pruned vector searches. |
| Persistent Neighbor Graph Vector Indexes | Disk checkpoint for HNSW graphs to speed up index reload after database restart. |
| Transactional HNSW Indexes | DMLs now allowed on tables with HNSW indexes with transactionally consistent search results. |
| Distributed HNSW Indexes with RAC | HNSW indexes scale across all RAC instances' total available memory. |
| Duplicated HNSW on RAC | Full HNSW index duplication across all RAC cluster instances for ultra-fast searches. |
| Scalar Quantized HNSW Indexes | Compress HNSW indexes using scalar quantization to reduce storage footprint. |
| Auto IVF Vector Index Reorganization | Automatic rebuild of IVF indexes when performance degradation is detected. |
| IVF Index Online Reorganization | Reorganize IVF indexes while they remain available for DMLs and queries. |
| Online Index Rebuild | Create or rebuild vector indexes while the base table stays open for updates. |
| Included Columns in Vector Indexes | Store non-vector columns in IVF/HNSW indexes to eliminate base table lookups. |
| Hybrid Vector Index for JSON | Hybrid vector index extended to support JSON columns for text + semantic search. |
| Partition Maintenance with Global Vector Indexes | Add, drop, merge, split partitions on tables with global IVF and HNSW indexes. |
| Additional Predicate Support in Hybrid Search | WHERE clause predicates on non-indexed columns now supported in hybrid vector search. |
| Jaccard Distance Metric | New Jaccard distance metric for measuring similarity between binary vectors. |
| PL/SQL JACCARD Distance Support | JACCARD distance metric available in PL/SQL VECTOR_DISTANCE operator. |
| ONNX-Format Models as DB Objects | Import ONNX models as first-class MINING MODEL objects for in-database inference. |
| Enable Larger ONNX Models | Support for ONNX models larger than 1GB using external initializers. |
| Image Transformer Models via ONNX Runtime | Import and use image transformer models for in-database image vectorization. |
| Vector Utility API (VECTOR_CHUNKS) | SQL function to chunk text into pieces for embedding generation. |
| Chainable Utility Functions | Pipeline text-to-embedding functions together for streamlined vector index creation. |
| Select AI with RAG & Synthetic Data | Natural language to SQL with retrieval augmented generation and synthetic data generation. |
| Hybrid Vector Search API (DBMS_HYBRID_VECTOR) | JSON_EXISTS and JSON_TEXTCONTAINS support in hybrid search queries. |
| Elastic Vector Memory Management | Vector memory pool auto-resizes to accommodate HNSW index changes dynamically. |
| Vector Memory Pool Auto Management | Autonomous DB automatically manages vector pool sizing for HNSW indexes. |
| JSON-Relational Duality Views | Fully updatable JSON views over normalized relational data, combining document and relational benefits. |
| JSON Schema Validation | Validate JSON data structure and types using IS JSON condition and PL/SQL utility. |
| JSON Collections | Native document-store-compatible JSON tables/views integrated with SQL. |
| JSON Collection Views | Read-only views exposing JSON objects, conceptually close to duality views with fewer restrictions. |
| GoldenGate Replication of Duality Views | Replicate duality view data as JSON documents to Oracle and non-Oracle databases. |
| JSON Replication (Partial JSON Logging) | Log only modified portions of JSON for efficient replication, reducing network overhead. |
| JSON-to-Duality Migrator | PL/SQL tools to migrate document collections from document databases to duality views. |
| Enhancement to JSON_TRANSFORM | Extended with RHS path expressions, nested paths, arithmetic operations, and array sorting. |
| GraphQL Syntax for Duality Views | Enhanced GraphQL directives, comments, QBE predicates for creating duality views. |
| JSON Type Modifiers | Constrain JSON columns to objects, arrays, or scalars with size and element limits. |
| Comparing and Sorting JSON Types | Use JSON data type directly in WHERE, ORDER BY, and GROUP BY clauses. |
| JSON_EXPRESSION_CHECK Parameter | Detect incorrect JSON path expressions at compile time instead of runtime. |
| Simple Dot-Notation for JSON Indexes | Create indexes on JSON data using simple dot notation for improved query performance. |
| WHERE Clauses in Duality Views | Limit rows in duality views with WHERE clauses for fine-grained document control. |
| Precheckable Constraints using JSON Schema | Applications can precheck data validity using JSON schemas before sending to the database. |
| ORDERED in JSON_SERIALIZE | Sort key-value pairs alphabetically in JSON_SERIALIZE output for easy comparison. |
| DBMS_AQ Support for JSON Arrays | Use JSON array payloads for Advanced Queuing bulk message passing. |
| SODA Enhancements | Merge, patch, embedded keys, sampling, flashback, and more for SODA API. |
| BOOLEAN Data Type | ISO SQL standard-compliant BOOLEAN type for storing TRUE/FALSE values. |
| Direct Joins for UPDATE and DELETE | Join target table to other tables using FROM clause in UPDATE/DELETE statements. |
| IF [NOT] EXISTS Syntax | DDL creation/modification/deletion supports conditional existence checks. |
| SELECT Without FROM Clause | Run expression-only SELECT queries without requiring a FROM clause. |
| GROUP BY Column Alias or Position | Use column aliases or positions in GROUP BY, ROLLUP, CUBE, and GROUPING SETS. |
| GROUP BY ALL | Automatically group by all non-aggregated columns without listing them. |
| Table Value Constructor (VALUES) | Materialize rows on the fly in SELECT, INSERT, and MERGE using VALUES clause. |
| QUALIFY Clause | Filter results of analytic functions without nesting queries. |
| Non-Positional INSERT (SET & BY NAME) | Self-documenting INSERT SET clause and BY NAME matching for subquery inserts. |
| DEFAULT ON NULL for UPDATE | Columns auto-set to default value when an UPDATE tries to set NULL. |
| Aggregation Filters (FILTER Clause) | Apply conditions directly within aggregate functions per SQL standard. |
| Aggregation over INTERVAL Types | Pass INTERVAL data types to SUM and AVG aggregate/analytic functions. |
| Time Bucketing (TIME_BUCKET) | Native SQL operator for fixed-time interval bucketing of time series data. |
| Calendar Functions | Extract year, quarter, month, week, day across calendar, fiscal, and retail calendars. |
| DATEDIFF / TIMESTAMPDIFF | Standard date/time difference calculations for easier migration from other databases. |
| UUID() Function | Generate RFC 9562-compliant version 4 UUIDs for unpredictable unique identifiers. |
| UPDATE RETURN Clause Enhancements | RETURNING INTO clause reports old and new values for INSERT/UPDATE/DELETE/MERGE. |
| Extended CASE Controls | Dangling predicates and multiple choices in WHEN clauses per SQL:2003 standard. |
| Schema Annotations | Store and retrieve application metadata as name-value pairs on database objects. |
| Data Use Case Domains | Centralized declaration of column intent (email, URL, currency) with constraints. |
| Unicode 15.0 Support | NLS data files updated to match Unicode Standard version 15.0. |
| Automatic PL/SQL to SQL Transpiler | PL/SQL functions in SQL automatically converted to SQL expressions for speed. |
| Materialized View Rewrite with Bind Variables | Query rewrite now supports SQL with bind variables via bind peeking. |
| Native Property Graphs in SQL | Built-in property graph data structures and queries directly in Oracle AI Database. |
| ISO SQL/PGQ Standard Support | Among the first to support ISO SQL standard for property graph queries. |
| Graph from JSON Collections | Execute SQL/PGQ queries on graphs represented as JSON columns. |
| Graph from Database Views | Create property graphs from views, database links, external tables, and more. |
| RDF Graph Analytics | Use PageRank, Community Detection, and other graph algorithms with RDF graphs. |
| Kafka APIs for TxEventQ | Run Kafka applications directly against the database using Transactional Event Queues. |
| TxEventQ Propagation | Propagate events/messages between databases as a reliable and secure Event Mesh. |
| Saga APIs (Oracle Saga Framework) | Framework for maintaining atomic data consistency across microservices transactions. |
| Python & REST Drivers for TxEventQ | TxEventQ now accessible via Python and Kafka-compatible REST APIs. |
| Prometheus/Grafana for Oracle | Database metrics dashboards for developers in Kubernetes/Docker environments. |
| ODP.NET: AQ and TxEventQ | .NET drivers support Advanced Queuing and Transactional Event Queues APIs. |
| MLE JavaScript Modules & Environments | Persist and manage JavaScript code as schema objects in the database. |
| JavaScript Module Calls from SQL/PL/SQL | Invoke JavaScript functions stored in modules from SQL and PL/SQL via call specs. |
| JavaScript SODA API | Client-side and server-side SODA document access for JavaScript developers. |
| Foreign Function Interface (JS to PL/SQL) | Use native JavaScript constructs to call PL/SQL code units directly. |
| Restricted Execution Contexts (PURE) | Limit JavaScript to pure computation without database interaction for safety. |
| JavaScript Post-Execution Debugging | Collect runtime state during execution for post-mortem debugging of JS code. |
| Java in DB: JDK 11 + Modules | Re-architected Oracle JVM supporting JDK 11 capabilities and the Java module system. |
| Java Web Services Callout Enhancement | More efficient web services callout from Java, PL/SQL, and SQL in the database. |
| Reset Database Session State | Automatically clean session state at request end to prevent data leaks. |
| Implicit Connection Pooling (DRCP) | Auto-assign DRCP servers to/from connections without explicit app pooling. |
| Multiple Named DRCP Pools | Create multiple named pools for finer control over DRCP usage. |
| OCI Pipelined Operations | Submit multiple database operations without waiting for server responses. |
| ODP.NET: Application Continuity | .NET drivers support transparent recovery of in-flight sessions during outages. |
| ODP.NET: Pipelining | Queue database requests transparently while awaiting responses for better throughput. |
| ODP.NET: OpenTelemetry | Instrumented APIs for distributed tracing using the OpenTelemetry framework. |
| JDBC Pipelined Database Operations | Asynchronously submit multiple SQL requests without waiting for preceding calls. |
| JDBC OAuth 2.0 (OCI IAM & Azure AD) | Simplified Java authentication using OAuth 2.0 in multi-cloud environments. |
| Java Support for True Cache | JDBC transparently routes read-only workloads to True Cache instances. |
| DBMS_DEVELOPER Package | Efficient JSON-format metadata retrieval for database objects replacing XML-based methods. |
| GraphQL Table Function & Schema API | Query Oracle Database using GraphQL language via SQL table function. |
| SQLPlus Enhancements (PING, OERR, CONFIG) | New commands for connectivity testing, error lookup, and configuration management. |
| Automatic Data Clustering | Transparently clusters data based on workload for better zone map/storage index pruning. |
| Data Quality Operators | PHONIC_ENCODE and FUZZY_MATCH for pronunciation-based and fuzzy string matching. |
| Oracle SQL Access to Kafka | Query or load Apache Kafka/OCI streaming data via SQL using DBMS_KAFKA. |
| Hybrid Partitioned Tables (Interval/Auto-List) | Hybrid partitioned tables now support interval and automatic list partitioning. |
| Text Indexes with Automatic Maintenance | Background auto-sync for text indexes eliminates manual SYNC_INDEX operations. |
| Enhanced Automatic Indexing | Accounts for DML costs, supports range predicates and function-based indexes. |
| Enhanced Automatic Materialized Views | Auto-partitioning and improved cost model for automatic MV selection and refresh. |
| Enhanced Automatic SQL Plan Management | Faster detection and repair of SQL plan regressions at parse-time. |
| Concurrent MV Refresh (on-commit) | Multiple sessions can refresh the same on-commit materialized views simultaneously. |
| MV Support for ANSI Joins | Full rewrite capabilities for materialized views with ANSI join syntax. |
| Semi-Join Materialized Views | Replace large unified dimension tables with join-specific MVs for faster analytics. |
| Ubiquitous Search (DBMS_SEARCH) | Index multiple schema objects in a single index for cross-object full-text search. |
| Transportable Binary XML | Self-contained XMLType storage supporting sharding, search index, and Exadata pushdown. |
| Automatic In-Memory Enhancements | Auto-enable/disable join groups, hashed dictionaries, and optimized arithmetic. |
| Automatic In-Memory Sizing (ADB) | In-Memory column store grows/shrinks dynamically based on workload for Autonomous DB. |
| Vectorized Query Processing | SIMD-exploiting multi-level hash joins and group-by aggregations for faster analytics. |
| In-Memory RAC-Level Global Dictionary | Synchronized common dictionaries across RAC nodes for improved join performance. |
| In-Memory Optimized Dates | Extract and cache DATE components in IM column store for faster date-based queries. |
| Selective In-Memory Columns | ALL sub-clause to easily enable/disable all columns for in-memory. |
| Automated Time Series Model Search | Auto-select Exponential Smoothing model type and hyperparameters for forecasting. |
| XGBoost: Constraints & Survival Analysis | XGBoost supports survival analysis (AFT model) and feature interaction constraints. |
| GLM Link Functions (probit, cloglog, cauchit) | Additional link functions for logistic regression expanding model quality options. |
| Multiple Time Series | Construct time series regression models with multivariate inputs and indicator data. |
| Outlier Detection using EM Clustering | Distribution-based anomaly detection via Expectation Maximization algorithm. |
| ESA Dense Projection with Embeddings | Explicit Semantic Analysis outputs doc2vec representations for text analytics. |
| OML4Py & OML4R Enhancements | Additional algorithms (NMF, ESM, XGBoost, Random Forest, Neural Network) for Python and R. |
| In-Database Vector Predictors | Use VECTOR columns as predictors alongside structured data in ML algorithms. |
| Partitioned Model Performance | Improved performance for up to 32K partitions in partitioned models. |
| Spatial: 3D Models & Analytics | Point cloud change detection via SQL/PL/SQL for landscape and infrastructure monitoring. |
| Spatial: REST APIs for GeoRaster | REST APIs for querying and manipulating satellite imagery and raster data. |
| Spatial Vector Tiles (PL/SQL API) | Generate vector tiles from geometries for efficient web map rendering. |
| Enhanced Partitioning Metadata | Partition boundary info available in JSON and CLOB format for programmatic use. |
| Extended Language Support in Oracle Text | Up to 48 languages supported with on-demand language file downloads. |
| External Table Partition Values in File Path | Derive partition values from directory/file names for Hive-style external tables. |
| Logical Partition Change Tracking | Fine-grained MV staleness tracking at logical partition level without MV logs. |
| Staging Tables | Heap tables pre-optimized for fast data ingestion and volatile data handling. |
| JSON Materialized Views (Enhanced) | Faster refresh and broader query rewrite for JSON table materialized views. |
| Heat Map Retention Time | Control how long Heat Map access/modification tracking data is retained. |
| Classic Queue to TxEventQ Migration | Online tool to migrate from AQ Classic Queues to high-performance TxEventQ. |
| Cloud Premigration Advisor Tool (CPAT) | Proactively identifies and recommends fixes for migration incompatibilities. |
| Hybrid Read-Only Mode for PDBs | PDB operates read-write for common users, read-only for local users during maintenance. |
| Real-Time SQL Monitoring Enhancements | Per-PDB/CDB monitoring, AWR export, and SQL History Reporting integration. |
| Control PDB Open Order | Define startup priority for PDBs so critical databases open first. |
| Inter-Instance Resource Management | Fine-grained CPU control with limits and guarantees across CDBs, PDBs, and processes. |
| Read-Only Users and Sessions | Disable/re-enable read-write capabilities for any user or session without revoking privileges. |
| App Continuity with Database Templates | Checkpoint and restore session state using templates for broader AC protection. |
| Smart Connection Rebalance | Automatically reshuffle RAC connections based on real-time performance monitoring. |
| Smooth RAC Reconfiguration | Reduced brownout time when nodes join/leave an Oracle RAC cluster. |
| Adaptive Result Cache Exclusion | Auto-blocklist objects where result caching is not beneficial. |
| Cloud Developer Packages | Built-in DBMS_CLOUD packages for cloud storage, pipelines, notifications, and AI integration. |
| Unified Memory | Single MEMORY_SIZE parameter replaces SGA_TARGET and PGA_AGGREGATE_LIMIT. |
| Read-Only Tablespace on Object Storage | Move read-only tablespaces to Oracle Object Storage for cost-effective tiering. |
| Azure Blob Storage Backup | RMAN backup and recovery directly to/from Microsoft Azure Blob Storage. |
| Auto SQL Compile-Time Error Repair | Automatically detect and repair severe compile-time SQL exceptions. |
| Data Guard Redo Decryption (Hybrid DR) | Decrypt redo in hybrid cloud DR where cloud DB is TDE-encrypted and on-prem is not. |
| Per-PDB Data Guard Enhancements | Independent switchover/failover per PDB with simplified setup and Real-Time Query. |
| Configuration & Member Tagging | User-defined key-value tags for Data Guard members for logical grouping. |
| JSON Output for DGMGRL | Data Guard command-line output available in JSON for automation integration. |
| Restrict Switchover/Failover Candidates | PrimaryDatabaseCandidates property controls which databases can become primary. |
| Optimized Fast-Start Failover Lag Detection | New lag type and grace time properties for improved Maximum Performance mode. |
| Flashback Time Travel Enhancements | Automatically track and archive transactional changes with schema evolution history. |
| Database Native Transaction Guard | Enhanced Transaction Guard without extra redo generation or performance overhead. |
| Oracle RAC Two-Stage Rolling Updates | Apply non-rolling fixes in rolling fashion, reducing downtime for RAC patches. |
| General Purpose Cluster Configuration | Simplified cluster deployment with minimal network/storage configuration. |
| Local Rolling Database Maintenance | Rolling patching locally on one RAC node without affecting other cluster nodes. |
| Single-Server Rolling Maintenance | Rolling patching on a single server hosting RAC or RAC One Node databases. |
| Oracle DBCA: Standard Edition HA | Quickly create Standard Edition HA databases with automatic failover via DBCA. |
| Application Continuity for DBMS_ROLLING | Continuous availability during rolling upgrades using Application Continuity. |
| Oracle SQL Firewall | Real-time protection blocking unauthorized SQL and SQL injection attacks, built into the database. |
| TLS 1.3 Support | Latest TLS protocol with improved session setup performance and stronger ciphers. |
| Post-Quantum Cryptography (ML-KEM, ML-DSA) | Quantum-resistant cryptographic algorithms for future-proof data protection. |
| AES-XTS Encryption for TDE Tablespace | XTS mode for tablespace encryption with improved security and parallel performance. |
| TDE Default Changed to AES256 | Default encryption algorithm upgraded to AES256 for both column and tablespace encryption. |
| Simplified TLS Configuration | Streamlined parameters and client wallets not required for well-known CA certs. |
| Improved Local Auto-Login Wallets | More tightly bound to host, more secure, no root access required. |
| Changes to DBMS_CRYPTO | Added AES-XTS mode, SHA-3, and SM2/3/4 to cryptographic package. |
| Password Length Increased to 1024 Bytes | Database and client passwords now support up to 1024 bytes for stronger authentication. |
| Multi-Factor Authentication | MFA via push notifications (Cisco Duo/Oracle Mobile Auth) or PKI certificates. |
| Microsoft Azure AD Integration | Single sign-on to Oracle databases using Azure AD OAuth2 tokens. |
| Schema Privileges | Grant privileges at schema level instead of broad system-wide ANY privileges. |
| DB_DEVELOPER_ROLE | Pre-built role with all necessary privileges for application development. |
| Updated Kerberos Library (v1.21.2) | MIT Kerberos 1.21.2 with cross-domain support for multi-domain environments. |
| RADIUS Enhancements (RFC 6613/6614) | TCP over TLS by default for RADIUS MFA authentication. |
| OCI IAM Integration | Log in to OCI DBaaS databases using IAM password or token-based authentication. |
| Column-Level Auditing | Create unified audit policies for individual columns in tables and views. |
| Database Vault Audit Controls | Control AUDIT_ADMIN/AUDIT_VIEWER role grants via Database Vault APIs. |
| Data Dictionary Protection Extended | Non-SYS Oracle schemas get data dictionary protection with separation of duties. |
| Oracle Data Redaction Enhancements | Optimized capabilities and removed previous limitations for data redaction. |
| IP Rate Limiting in CMAN | Limit new connections per IP to protect against denial-of-service attacks. |
| Digital Signature for Installation Archives | Oracle-signed installation files ensure integrity before deployment. |
| Secure Distributed Transaction Recovery | Additional security for the RECO background process in distributed transactions. |
| True Cache | In-memory, consistent, diskless cache for read-only workloads with automatic management. |
| Raft Replication for Globally Distributed DB | Built-in consensus-based replication with sub-second failover, no GoldenGate needed. |
| Directory-Based Sharding | Dynamic data placement with key location stored in a directory for flexible scaling. |
| Priority Transactions | Auto-abort lower priority transactions blocking higher priority ones past timeout. |
| Lock-Free Reservation | Reserve column values without row locks for improved concurrency. |
| Sessionless Transactions | Suspend/resume transactions across sessions without external transaction managers. |
| Automatic Data Move on Sharding Key Update | Data auto-moves to correct shard/partition when sharding key value changes. |
| Automatic Transaction Quarantine | Quarantine problematic transactions while keeping the database open and operational. |
| Immutable Backups Using RMAN | RMAN compatible with immutable OCI Object Storage for ransomware protection. |
| Parallel Cross-Shard DML | Cross-shard updates and inserts execute in parallel across multiple shards. |
| Blockchain Table User Chains | User-defined chains for isolated verification based on custom column values. |
| Blockchain Table Row Versions | Maintain multiple historical versions of rows within blockchain tables. |
| Blockchain Table Log History | Track changes to regular tables in cryptographically secure blockchain audit log. |
| Add/Drop Columns in Blockchain Tables | Evolve blockchain/immutable table schemas while preserving crypto-hash chain integrity. |
| Blockchain Table Countersignature | Database countersigns rows for non-repudiation with external storage options. |
| Blockchain Table Delegate Signer | Allow alternate users to sign blockchain table rows on behalf of the primary user. |
| Wide Tables (4096 Columns) | Maximum columns per table increased from 1000 to 4096 for ML/IoT workloads. |
| Partition by Expression | Define partition keys using expressions directly, eliminating virtual column overhead. |
| Assertions for Data Integrity | Declarative multi-table business rules as database-level assertions. |
| Unrestricted Direct Loads | Query and DML allowed on same table after direct load before commit. |
| Unrestricted Bulk Transactions | Multiple parallel DMLs and queries on same object within a single transaction. |
| System Timezone Autonomy for PDBs | Each PDB controls its own SYSDATE/SYSTIMESTAMP timezone independently. |
| Memory Speed Columnar | Next-gen HCC with in-memory format, eliminating columnar format mismatch across tiers. |
| HCC Compression Improvements | Faster compression/decompression speeds and better ratios for Hybrid Columnar Compression. |
| Bigfile Tablespace Shrink | Reliably shrink bigfile tablespaces to reclaim unused space. |
| Smallfile Tablespace Shrink | Reliably shrink smallfile tablespaces to close to actual used space. |
| BIGFILE Default for SYS Tablespaces | SYSAUX, SYSTEM, and USER tablespaces default to bigfile, reducing datafile count. |
| Automatic SecureFiles Shrink | Background auto-shrink of SecureFile LOB segments without manual intervention. |
| Automatic Storage Compression | Direct load into uncompressed format, then gradually move to HCC in background. |
| Fast Ingest Enhancements | Memoptimize for Write now supports partitioning, compressed tables, and direct In-Memory population. |
| Ordered Sequence Optimizations in RAC | Better performance for ordered sequences in RAC without manual tuning. |
| Materialized Expression Columns | Persist virtual columns on disk to avoid repeated computation. |
| SQL*Loader Auto Parallel Direct Load | Automatic parallel loading without splitting data files or starting multiple clients. |
| Centralized Configuration Providers | Pull connection descriptors and config from Azure or OCI cloud stores. |
| Enhanced Query History Tracking | Track complete query history including sub-5-second non-parallel queries. |
| RMAN Enhancements (AES256 Default) | Encrypted backups default to AES256; includes cross-platform migration improvements. |
| Database Observability (KSTRC) | Distributed tracing with OpenTelemetry integration for end-to-end issue debugging. |
| Telemetry Streaming | Turnkey metrics streaming with REST/PL/SQL ingestion and PromQL querying. |
| SQL Diagnostic Report (DBMS_SQLDIAG) | Deep-level HTML diagnostic report for SQL statements with plan history and statistics. |
| Network Monitor (NMON) | Always-on network monitoring with health scores at system, interface, IP, and flow levels. |
| Oracle Update Advisor | Software update recommendation framework for keeping software at recommended versions. |
| Cluster Health Monitor Improvements | Listen for critical events, recommend corrective actions, and self-heal autonomously. |
| Enhanced Cluster Health Advisor | Support for 4K PDBs (up from 256) with improved problem detection accuracy. |
| DBMS_DICTIONARY_CHECK | Lightweight PL/SQL package to identify and remediate data dictionary inconsistencies. |
| In-Memory Advisor (Built-in) | Built-in eligibility test and enhanced analysis to identify Database In-Memory candidates. |
| Add Verified SQL Plan Baseline | Automatically find and baseline the best execution plan from cache, AWR, or tuning set. |
| CMAN Diagnostics Enhancements | Monitor service registration stats and diagnose registration issues in CMAN logs. |
| OCI Client-Side Tracing APIs | Dynamic OCI diagnostic tracing without configuration file changes. |
| HA Diagnosability (DBMS_SCHEDULER) | In-memory tracing for scheduler jobs during forced shutdowns and patching. |
| Extent-Based ASM Scrubbing | Scrub specific extents instead of entire files for faster turnaround and less impact. |
| DB Installer Command-Line Support | Specify install commands and parameters via CLI in addition to GUI. |
| Grid Infrastructure Installer Improvements | Gold image management and out-of-place patching with reduced inventory metadata. |
| Oracle FPP Local Mode (No Java Container) | Fleet Patching without GIMR or Java container for simpler, faster patching. |
| Store/Transfer Gold Images as ZIP | Save storage and bandwidth by storing/transferring FPP gold images as ZIP files. |
| Archiving/Unarchiving Gold Images | Archive unused FPP gold images to external storage to free repository space. |
| AutoUpgrade Release Update (RU) Upgrades | Out-of-place Oracle home patching with AutoUpgrade for seamless RU application. |
| AutoUpgrade Auto-Parallelism | Auto-evaluates system resources to determine simultaneous upgrade job count. |
| AutoUpgrade TDE Keystore Support | Automated keystore management for TDE-enabled database upgrades. |
| AutoUpgrade Unplug-Plugin to Different Systems | Unplug PDB from one server, plug into another, and upgrade in a single operation. |
| REST APIs for AutoUpgrade | ORDS and OCI REST APIs for secure remote AutoUpgrade operations. |
| Gold Image Out-of-Place Patching (DBCA) | DBCA applies RUs out-of-place using gold images for Grid Infrastructure and DB homes. |