New Features in Oracle Database 19c

General

Multi-model partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs
New ALTER SYSTEM statement clause FLUSH PASSWORDFILE_METADATA_CACHE
Clear flashback logs periodically
Flush Metadata Cache for Passwords
Hybrid Partitioned Tables – to integrate internal partitions and external partitions into a single partition table. partitions to reside in both Oracle Database segments and in external files and sources
Passwords removed from schema accounts (default accounts)

Automatic Indexing

Automatic Indexing is one of the great feature included in 19c .It automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle Database based on changes in the application workload.
This feature improves database performance by managing indexes automatically in an Oracle Database.
Oracle has provided new package DBMS_AUTO_INDEX for this

SQL Quarantine

SQL statements that are terminated by Oracle Database Resource Manager due to their excessive consumption of CPU and I/O resources are automatically quarantined.
The execution plans associated with the terminated SQL statements are quarantined to prevent them from being executed again.
This feature protects an Oracle Database from performance degradation by preventing execution of SQL statements that excessively consume CPU and I/O resources.

Pluggable Databases

ADDM Analysis at PDB Level
Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent
Mode Ability to relocate a PDB to another CDB Using DBCA in Silent Mode
Creation Duplicate of an Oracle Database, CreateDuplicateDB command, in DBCA Silent Mode

Data Pump

Oracle Data Pump Allows Tablespaces to Stay Read-Only During TTS Import
Oracle Data Pump Test Mode for Transportable Tablespaces (TTS)
Oracle Data Pump Support for Resource Usage Limitations – new parameter MAX_DATAPUMP_PARALLEL_PER_JOB
Oracle Data Pump Loads Partitioned Table Data One Operation – GROUP_PARTITION_TABLE_DATA, a new value for the Import DATA_OPTIONS command line parameter
Oracle Data Pump Import Supports More Object Store Credentials
Oracle Data Pump Ability to Exclude ENCRYPTION Clause on Import – new transform parameter OMIT_ENCRYPTION_CLAUSE
Oracle Data Pump Prevents Inadvertent Use of Protected Roles – new ENABLE_SECURE_ROLES parameter is available

Performance

SQL Statement Diagnosability with SQL Advisor repair and SQL Test case for procedures
Realtime statistics for DML Operations – Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements
Workload Capture and Replay in a PDB
Statistics Collection on custom frequency automatically – From 19c onwards, High-frequency automatic optimizer statistics collection complements the standard statistics collection job
Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
Automatic Indexing – Manage Auto Indexes with Advisory task like Monitor, Capture, Identify, Verify, Decide – to enable auto index mode is below, we have options “Implement”, “Report-Only”, “OFF”.

Data Guard

DML redirect to standby/ADG for read-mostly applications
Propagate Restore Points from Primary to Standby site
Re-creation of broker configuration
Simplified Data-guard broker parameter configurations
Re-creation of broker configuration
Finer Granularity Supplemental Logging for logical standby databases
Flashback Standby Database when Primary Database is Flashed Back – Oracle 19c onwards, DBA can put the standby database in MOUNT mode without managed recovery and then flashback primary database; the standby will also be reverted, thus keeping it in sync with the primary
Oracle Data Guard Multi-Instance Redo Apply Works with the In-Memory Column Store
Finer Granularity Supplemental Logging for logical standby databases

New init parameters

New tables/views

New packages

ORA-AM