Oracle Database Release 19c – New Features

We received this question during our recent webinar, Executive Roundtable: Oracle E-Business Suite and 19C Upgrade: “Is there a list of 19c features somewhere I can review?”  See below for the answer and a link to Oracle.com where you can learn more.

Released in January 2019, Oracle 19c is the final release of the Oracle Database 12c product family. This article includes the complete list of updated features for the release. For additional information on each feature, visit the Oracle 19c New Features Guide on Oracle.com.

Oracle Database 19c represents the next phrase of autonomous database optimizations and builds upon the innovations of previous releases. 19c introduces new functionality and provides users with a multi-model, enterprise-class database for all typical business use cases.

New features for the release are grouped into the following categories:

  • Application Development
  • Availability
  • Big Data and Data Warehousing
  • Database Overall
  • Diagnosability
  • Performance
  • RAC and Grid
  • Security
APPLICATION DEVELOPMENT

Application Express:

  • Improved Create Application Wizard
  • REST Enabled SQL Support
  • Social Sign-In Authentication
  • Web Source Modules
  • Improved Create Page Wizard
  • New REST Workshop

General:

  • Application Continuity for Java: Declarative Request Demarcation
  • Application Continuity for Java: New States Management
  • Easy Connect Plus
  • Oracle Network Log File Segmentation
  • SQL*Net: Auto-Detection of Support for Out-of-Band Breaks

JSON:

  • Materialized View Support for Queries Containing JSON_TABLE
  • JSON Update Operations
  • SQL/JSON Syntax Simplifications
  • JSON Object Mapping
  • New SQL/JSON Function JSON_SERIALIZE and JSON Data Guide Support for GeoJSON Data

SQL:

  • DISTINCT Option for LISTAGG Aggregate
AVAILABILITY

General:

  • Dynamically Change Oracle Data Guard Broker Fast-Start Failover Target
  • Simplified Database Parameter Management in Oracle Data Guard Broker
  • Observe-only Mode for Oracle Data Guard Broker’s Fast-Start Failover
  • Propagate Restore Points from Primary to Standby Site
  • Flashback Standby Database When Primary Database is Flashed Back
  • Oracle Data Guard Multi-Instance Redo Apply Works with the In-Memory Column Store
  • Active Data Guard DML Redirection
  • PDB Recovery Catalog
  • Clear Flashback Logs Periodically for Increased Fast Recovery Area Size Predictability
  • New Parameters to Tune Automatic Outage Resolution with Oracle Data Guard
  • Finer Granularity Supplemental Logging

Sharding:

  • Support for Multi-Shard Query Coordinators on Shard Catalog Standby Databases
  • Generation of Unique Sequence Numbers Across Shards
  • Support for Multiple PDB Shards in the Same CDB
  • Multiple Table Family Support for System-Managed Sharding
  • Propagation of Parameter Settings Across Shards
BIG DATA AND DATA WAREHOUSING
  • Automatic Indexing
  • SQL Diagnostics and Repair Enhancements
  • Bitmap Based Count Distinct SQL Function
  • Big Data and Performance Enhancements for In-Memory External Tables
  • Automatic SQL Plan Management
  • Real-Time Statistics
  • High-Frequency Automatic Optimizer Statistics Collection
  • Hybrid Partitioned Tables
DATABASE OVERALL

Automated Installation, Configuration and Patching:

  • Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode
  • Ability to Relocate a PDB to Another CDB Using DBCA in Silent Mode
  • Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode
  • Simplified Image-Based Oracle Database Client Installation
  • Root Scripts Automation Support for Oracle Database Installation
  • Support for Dry-Run Validation of Oracle Clusterware Upgrade

AutoUpgrade and Database Utilities:

  • AutoUpgrade for Oracle Database
  • Oracle Data Pump Ability to Exclude ENCRYPTION Clause on Import
  • Oracle Data Pump Allows Tablespaces to Stay Read-Only During TTS Import
  • Oracle Data Pump Support for Resource Usage Limitations
  • Oracle Data Pump Test Mode for Transportable Tablespaces
  • Oracle Data Pump Prevents Inadvertent Use of Protected Roles
  • Oracle Data Pump Loads Partitioned Table Data One Operation
  • Oracle Data Pump Allows Wildcards for Dump File in Object Store
  • Oracle Data Pump Import Supports More Object Store Credentials
DIAGNOSABILITY
  • Oracle Trace File Analyzer Support for Using an External SMTP Server for Notifications
  • Oracle Cluster Health Advisor Integration into Oracle Trace File Analyzer
  • Oracle Trace File Analyzer REST API Support
  • Oracle Trace File Analyzer Search Extended to Support Metadata Searches
  • Oracle ORAchk and Oracle EXAchk REST Support
  • Oracle ORAchk and Oracle EXAchk Support for Encrypting Collection Files
  • Oracle ORAchk and Oracle EXAchk Support for Remote Node Connections Without Requiring Passwordless SSH
  • Oracle ORAchk and Oracle EXAchk Now Show Only the Most Critical Checks by Default
  • Oracle Trace File Analyzer Supports New Service Request Data Collections
PERFORMANCE
  • SQL Quarantine
  • Database In-Memory Wait on Populate
  • Resource Manager Automatically Enabled for Database In-Memory
  • Memoptimized Rowstore Fast Ingest
  • Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
  • Resource Manager Automatically Enabled for Database In-Memory
  • High-Frequency SQL Plan Management Evolve Advisor Task
  • Workload Capture and Replay in a PDB
RAC AND GRID
  • Standard Edition High Availability
  • Parity Protected Files
  • Secure Cluster Communication
  • Automated PDB Relocation
  • Zero-Downtime Oracle Grid Infrastructure Patching
  • Automated Transaction Draining for Oracle Grid Infrastructure Upgrades
  • Oracle Restart Patching and Upgrading
  • Colocation Tag for Client Routing
  • Optional Install for the Grid Infrastructure Management Repository
  • Resupport of Direct File Placement for OCR and Voting Disks
  • Dynamic Services Fallback Option
SECURITY
  • New ALTER SYSTEM Clause FLUSH PASSWORDFILE_METADATA_CACHE
  • Transparent Online Conversion Support for Auto-Renaming in Non-Oracle-Managed Files Mode
  • Support for Additional Algorithms for Offline Tablespace Encryption
  • Key Management of Encrypted Oracle-Managed Tablespaces in Transparent Data Encryption
  • Support for Host Name-Based Partial DN Matching for Host Certificates
  • New PDB_GUID Audit Record Field for SYSLOG and the Windows Event Viewer
  • New EVENT_TIMESTAMP_UTC Column in the UNIFIED_AUDIT_TRAIL View
  • Passwords Removed from Oracle Database Accounts
  • Signature-Based Security for LOB Locators
  • Unified Auditing Top-Level Statements
  • Privilege Analysis Now Available in Oracle Database Enterprise Edition
  • Support for Oracle Native Encryption and SSL Authentication for Different Users Concurrently
  • Ability to Grant or Revoke Administrative Privileges to and from Schema-Only Accounts
  • Automatic Support for Both SASL and Non-SASL Active Directory Connections
  • Database Vault Operations Control for Infrastructure Database Administrators
  • Database Vault Command Rule Support for Unified Audit Policies

DO YOU NEED TO SPEAK WITH AN ORACLE DATABASE OR ERP EXPERT?

Contact us here.