Oracle Database 19c New features

Installation and Upgrades

1.        Simplified Image based installation, RPM Based Installation, RPM method with Vagrant Virtual box and via ansible playbook
https://docs.oracle.com/en/database/oracle/oracle-database/19/install-and-upgrade.html               

2.       Docker Container for Oracle 19c

3.        Auto Upgrade Utility for Oracle Database
https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/using-autoupgrade-oracle-database-upgrades.html    

4.       DryRun mode for GridSetup in Clusterware Installation
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/running-oui-in-dry-run-upgrade-mode.html       

 General

1.        Auto Space Management for Flashback Logs in the FRA.

2.       Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions

3.        Schema-only accounts

4.       Flush Metadata Cache for Passwords

5.       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

Support:

Oracle 19c database release is a Long Term Release with 5 years of Premier Support followed by 3 years of Extended Support.

 

Pluggable Databases

1.        From Oracle 19 onwards, UNDO_RETENTION parameter can be set separately in each PDB, provided local undo is being used.

2.       ADDM Analysis at PDB Level

3.        Creation Duplicate of an Oracle Database using CreateDuplicateDB command, in DBCA Silent Mode

4.       Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode

5.       Ability to relocate a PDB to another CDB Using DBCA in Silent Mode

 Data Pump

1.        Oracle Data Pump Ability to Exclude ENCRYPTION Clause on Import - new transform parameter OMIT_ENCRYPTION_CLAUSE

2.       Oracle Data Pump Support for Resource Usage Limitations - new parameter MAX_DATAPUMP_PARALLEL_PER_JOB

3.        Oracle Data Pump Test Mode for Transportable Tablespaces (TTS)

4.       Oracle Data Pump Prevents Inadvertent Use of Protected Roles -  new ENABLE_SECURE_ROLES parameter is available

Performance

1.        SQL Quarantine (restricted to Enterprise Edition on Engineered Systems) - Starting Oracle 19c, Cancelling a runaway query is helpful to prevent wasting system resources, but if that problem query is run repeatedly, it could still result in a considerable amount of wasted resources. SQL Quarantine solves this problem by quarantining cancelled SQL statements, so they can't be run multiple times. ex: cpu limit, elapsed_time limit etc. To define the thresholds you can use DBMS_SQLQ package.quarantine configuration for an execution plan for a SQL statement

2.       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".

3.        select * from dba_auto_index_config;

4.       SQL Statement Diagnosability with SQL Advisor repair and SQL Test case for procedures

5.       Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)

6.       Realtime statistics for DML Operations - Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements

7.        Statistics Collection on custom frequency automatically - From 19c onwards,  High-frequency automatic optimizer statistics collection complements the standard statistics collection job

8.       Workload Capture and Replay in a PDB

Data Guard

1.        Replicate Restore Points from Primary to Standby

2.       Dynamically change Fast-Start Failover (FSFO) target standby database to another standby database in the target list without disabling FSFO.

3.        Automatic Flashback of Standby

4.       Re-creation of broker configuration

5.       Propagate Restore Points from Primary to Standby site

6.       DML redirect to standby/ADG for read-mostly applications

7.        Simplified Dataguard broker parameter configurations

8.       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.

9.       Observe Only Mode for Data Guard Broker's Fast-Start Failover (FSFO)

10.    Oracle Data Guard Multi-Instance Redo Apply Works with the In-Memory Column Store

11.     Finer Granularity Supplemental Logging for logical standby databases

New tables/views in Oracle 19c Database

dba_auto_index_config

dba_sql_quarantine

V$SQL_TESTCASES

DBA_REGISTRY_BACKPORTS

New packages in 19c Database Release 1

dbms_auto_index

dbms_auto_index_internal

DBMS_SQLQ