Oracle Database 19c: New Features for Administrators

Secirity Enhancements

• Database Vault
• Privilege Analysis

Avaibility Enhancements

• Recovery catalog with PDB
• Flashback and restore points
• Automatic Flashback Pn Physical Standby Databases

Performance Enhancements

• Memoptimized Rowstore
• Comparing SQL Execution Plans
• Hint Usage Reporting
• Supplemental Logging

Big Data and Warehousing Enhancements

• Automatic indexing
• Hybrid Partitioned Tables
• In-Memory External Tables

Diagnosability Enhancements

• SQL Test Case Builder
• SQL Diagnostic Advisor
• SQL Doagnostic and Repair
• Trace File Analyser
• Automatic Data Redaction

Sharding Enhancements

• Multi Table Family in System-Managed Sharding
• Support for Multiple PDB Shards in the Same CDB
• Generation of Unique Sequence Numbers Across Shards
• Support forMulti-Shard Query Coordinators on Shard Catalog Shards

Previous courses

Oracle Database: Administration Workshop [ORADM1]