Introduction
Below are some of my favourite new features of 19c .
New features
Automatic Indexing
Oracle 19c introduces a new feature that uses machine learning algorithms to automatically create, tune, and drop indexes. This feature can significantly reduce the workload required to manage indexes.
exadata and engineered systems only
click for more info
Real-Time Statistics
Oracle 19c introduces a new feature that enables the collection of statistics on tables and indexes in real-time, without impacting performance. This feature can provide more accurate statistics for the optimizer to use when generating execution plans.
exadata and engineered systems only
click for more info
Quarantine SQL Statements
Oracle 19c introduces a new feature that enables the quarantine of SQL statements that are identified as problematic. This feature can help prevent performance degradation caused by SQL statements that are poorly written or have a high resource consumption.
exadata and engineered systems only
click for more info
In-Memory Database
Oracle 19c introduces improvements to the In-Memory Database feature, including support for External Tables and Partitioning. This feature can improve performance for queries that access large amounts of data.
click for more info
Multitenant
Oracle 19c introduces several enhancements to the Multitenant architecture, including support for PDB snapshots, and enhancements to the PDB Fleet feature.
click for more info
JSON Enhancements
Oracle 19c introduces several new features to enhance JSON processing, including JSON_TABLE enhancements, the ability to index JSON documents, and the ability to use JSON in PL/SQL.
click for more info
Hybrid Partition Tables
Oracle 19c introduces a new feature that enables Hybrid partition tables. That is a partitioned table that contains both standard partitions and external partitions.
click for more info
Data Guard
Oracle 19c introduces several new features to improve Data Guard manageability including enhancements to Automatic Failover and Fast-Start Failover.
click for more info
Sharding
Oracle 19c introduces several new features to enhance Sharding, including support for Cross-Container Query, Smart Deployment, and Automatic Health Monitoring.
click for more info
Security Enhancements
Oracle 19c introduces several new security enhancements, including support for Privilege Analysis and enhancements to Oracle Database Vault.
click for more info
Max Idle Blocker Time
Oracle 19c introduces a parameter that specifies the maximum amount of time that a session can hold a lock on a resource without actively using it.
click for more info
Published 28th February 2023
