Oracle 19c – New Features List & Documentation

Hello

Today morning I opened twitter and saw lot of posts on Oracle 19c available on exadata, Thanks to Maria & others pointing me out to blogs.oracle.com. I started surfing through the links and found Oracle 19c Documentation is available and especially new features link. Here it is.

For Database Admin and Dataguard new documentation link set.

Admin New Features

Dataguard Features

and there is nicest interactive apex url for new features list for Databases 11g, 12c, 18c, 19c to scroll through. Thanks to the creators.

https://apex.oracle.com/database-features/

The features that are interesting to me are (also in https://blogs.oracle.com/database/oracle-database-19c-available-exadata ). By the way, Oracle 19c release is labelled as concentrating on stability hence expect less features.

Visit my blog dedicated page:- http://db.geeksinsight.com/19c-database/

• Installation & Upgrades
  • Simplified Image based installation of client as well
  • RPM Based Installation
  • Docker Container for 19c
  • Auto Upgrade Utility
  • CreateDuplicateDB in DBCA Silent Mode
  • DryRun mode for GridSetup in clusterware Installation

  General

  • SQL Quarantine
  • Clear flashback logs periodically
  • Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs.
  • Passwords removed from schema accounts (default accounts)
  • ADDM Analysis at PDB Level
  • Flush Metadata Cache for Passwords

  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
  • Simplified dataguard broker parameter configurations

  Deprecated & De Supported features

  Grid

  • Clone.pl
  • addnode.sh

  Database

I have created a separate page for all this here.

Started reading the documentation and you?

Thanks

Suresh