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