Oracle 19c New Features Articles & Installation Page.
Not lot but good exciting ones.
Installation & Upgrades
- Standard Edition 2- RAC Desupported
- Simplified Image based installation of client as well
- RPM Based Installation
- Docker Container for 19c
- Auto Upgrade Utility
- DryRun mode for GridSetup in clusterware Installation
- CreateDuplicateDB in DBCA Silent Mode
General
- SQL Quarantine
- Clear flashback logs periodically
- EZConnect Enhancements
- Max_Idle_Time_Blocker to terminate blocking sessions automatically
- ADDM Analysis at PDB Level
- Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs.
- Password Enhancements
Performance
- Automatic Indexing - Manage Auto Indexes with Advisory task like MOnitor, Capture, Identify, Verify, Decide
- SQL Statement Diagnostability with SQL Advisor repair and SQL Test case for procedures
- Realtime statistics for DML Operations
- Statistics Collection on custom frequency automatically
RAC
- Zero downtime Grid Patching
- Root.sh script automation's
Dataguard
- Replicate Restore Points from Primary to Standby
- Automatic Flashback of Standby
- DML redirect to standby
- Configure FSFO in observer mode
- Dynamic Service Failover to Standby
Deprecated & De Supported features
Grid
- Clone.pl
- addnode.sh
Follow Me!!!