Oracle Database New Features (12c to 19c)
From Oracle database 12c on-wards, whole architecture was changed. And it comes with many new features. Oracle also changed the policy of releasing database patches and version. Now we are seeing new version every year from 2018 on-wards, i.e. 18c in the year of 2018, 19, in the year of 2019 and now very soon 20c is coming this year.
Here I am highlighting Oracle database new features which was introduce in different Oracle database versions. My focus is to highlight most important features from version 12c onwards up to 19c.
This will help you to understand which feature we can use in which version.
|
Category
|
DB
Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
|
High
Availability
|
Comprehensive HA and disaster
recovery functionality
|
Sharding
|
Sharded RAC
|
Data Guard DML Redirect
|
|
Oracle Golden Gate for heterogeneous replication
|
Autonomous Health Framework
|
User-defined Sharding Methods
|
Sharding: Supports multiple PDB shards in a CDB
Unique sequence number generation per shard
|
|
|
|
Zero Downtime Grid Infrastructure
Patching
|
|
|
|
PDB Recovery Catalog
|
|
|
|
|
Improvements to Application
Continuity
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
|
Performance and Salability
|
In-Memory Column Store
|
In Memory JSON Queries
|
Memory Optimized Row
Store
|
Fast ingest support for
IoT type workloads
|
|
Engineered Systems
|
In Memory Active Standby
|
New Approximate Functions
|
Quarantine for SQL Statements
|
|
Optimizer Adaptive
Feature
|
Optimizer Adaptive
Feature
|
|
Stats Only Queries
|
|
Approximate Query Processing
|
New Approximate Functions
|
|
Improvements for COUNT DISTINCT and GROUP BY queries
|
|
Optimizer Statistics
Advisor
|
|
Automatic Indexing
|
|
|
|
Realtime Statistics
|
|
|
|
|
Automatic Resolution of
SQL Plan Regressions
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
|
Multitenant
|
Container managed
database virtualization
|
Online cloning &
relocation
|
Transportable backups
|
DBCA Silent mode
operations for PDB
|
|
Manage Many as one
|
Incremental refresh of test/dev master
|
Snapshot carousel
|
RAT and ADDM at PDB level
|
|
Patching, Backup,
Security, Online Cloning, Online Relocation
|
Application containers
|
Refreshable PDB
switchover
|
Automated PDB Relocation
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
Security
|
Security In-Depth
Access Controls, Encryption, Redaction, Masking, Auditing, SQL Firewalls Key
Vault
|
Online encryption
|
Integration with Active
Directory
|
Data Dictionary
Encryption
|
|
Audit Vault Database Firewall
|
|
Password-less schema creation
|
Password-less Schema-only Oracle accounts
|
|
Security Assessment Tool
|
|
|
Database Vault Operations
Control
|
|
|
|
|
Privilege Analysis available in EE
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
Application
Development
|
Application Express 5.1
|
Long Identifiers
|
Improved JSON Support
|
SQL JSON Enhancements
|
|
Comprehensive Language support
PL/SQL, SQL , Python, Node.js, PHP, Java, C, .NET, REST
JSON
|
Case Insensitive Databases
|
C, Python, JavaScript JSON SODA API
|
Materialized View for JSON_TABLE
|
|
|
Private Temporary Tables
|
Partial JSON Update
support
|
|
|
|
|
Realtime SQL Monitoring for Developers
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
Data Warehousing and Big Data
|
Partitioning,
Compression, SQL, Analytical Views, Analytical SQL, Data Mining
|
Partitioned External
Tables
|
In-Memory for external
tables
|
Hybrid Partitioned Tables
|
|
Easily analyze data held in Hadoop with Big Data SQL
|
Analytical Views
|
Automatic propagation of nologged data to standby
|
Stats only Queries
|
|
Big Data Appliance
|
|
Machine Learning :
Random Forrest, Neural Network
|
|
|
Category
|
DB Versions
|
|
12.1
|
12.2
|
18c
|
19c
|
|
|
|
|
|
|
Other
Improvements
|
|
|
|
EZConnect Improvements
|
|
|
|
Oracle Database XE
Free to use
Includes most EE features
no RAC, Data Guard, GoldenGate
|
|
|
|
Oracle Database 19c RPM
Install, Yum install of Oracle Instant Clients
|
|
|
|
Oracle Read Only Homes
|
|
|
|
No click through client
software install
|
|
|
|
Oracle Docker images
|
|
|
|
SQLDeveloper Web
|
|
|
|
|
Oracle Data REST Services (ORDS)
|
Thanks & Regards,
Chandan Tanwani
Oracle Performance Tuning Certified Expert
