Oracle 19c new features

 Oracle 19c new features

 

 

 

Oracle 19c, released in 2019, introduced several new features and enhancements across various areas of the database. Here are some notable features introduced in Oracle 19c:

1. Automatic Indexing: Oracle 19c introduced the Automatic Indexing feature, which uses machine learning algorithms to identify and create indexes on tables automatically. This feature can improve query performance by automatically creating and maintaining indexes based on usage patterns.

2. Real-Time Statistics: Oracle 19c enhanced the statistics gathering process by introducing real-time statistics. Instead of relying solely on scheduled statistics collection jobs, real-time statistics allow the optimizer to use more accurate and up-to-date statistics during query optimization, resulting in better query plans.

3. Hybrid Partitioned Tables: With Oracle 19c, you can create hybrid partitioned tables that combine the benefits of both partitioning and non-partitioned tables. This allows for more flexible data management and improved performance for specific use cases.

4. Multitenant Database Improvements: Oracle Multitenant, introduced in earlier versions, received several enhancements in 19c. These include increased capacity limits for pluggable databases (PDBs), improved cross-container operations, and simplified management operations for PDBs.

5. Automatic Data Optimization: Oracle 19c introduced Automatic Data Optimization (ADO), which allows for the automatic compression and movement of data between different storage tiers based on usage patterns and policies. ADO enables cost-effective data lifecycle management and improves storage efficiency.

6. Real Application Clusters (RAC) Improvements: Oracle 19c brought enhancements to Real Application Clusters (RAC), including better workload management and performance with the introduction of application continuity and the capability to prioritize resource allocation for specific workloads.

7. Database In-Memory Improvements: The In-Memory column store feature, introduced in earlier versions, received performance and usability enhancements in Oracle 19c. This includes improved in-memory join performance, support for larger In-Memory column stores, and the ability to dynamically track usage statistics for In-Memory objects.

8. Security Enhancements: Oracle 19c introduced several security enhancements, such as the ability to manage user privileges through a role commonality feature, support for password-less authentication using external services, and enhancements to Oracle Data Redaction for sensitive data protection.

These are just a few of the key features and enhancements introduced in Oracle 19c. Oracle regularly releases updates and patches, so it's always recommended to consult the official Oracle documentation and release notes for the most up-to-date information on features and enhancements in a specific version.