Oracle Database 19c

Oracle Database 19c is the final, and therefore 'long term support' release of the Oracle Database 12c family of products (which includes Oracle Database 18c). 'Long term support' means that Oracle Database 19c comes with 4 years of premium support and a minimum of 3 years extended support.

This was released on 16 January 2019.

Changes in Oracle Database Release 19c, Version 19.1

Oracle Database Concepts for Oracle Database release 19c, version 19.1 has the following changes.

New Features

The following major features are new in this release:

• Deferred inserts

Applications can stream single-row inserts into special buffers stored in the large pool. The inserts are “deferred” because the database writes these buffers to data files asynchronously. The inserts are committed automatically and cannot be rolled back.

See "Large Pool Buffers for Deferred Inserts"

• Hybrid partitioned tables

A table can contain internal and external partitions. Internal partitions consume space inside the database (segments). External partitions are stored outside the database using external table functionality. For example, a sales table might contain two partitions stored in data files and three partitions stored in text files.

See "Segments for Partitioned Tables"

Desupported Features

The following features are desupported in this release.

• Oracle Multimedia

Starting in Oracle Database 19c, Oracle Multimedia is desupported. Unless deselected, the Oracle Multimedia component (ORDIM) in dba_registry displays as VALID in upgraded and newly created databases. Oracle Locator (installed with Oracle Multimedia if Spatial and Graph is not installed) continues to be installed and supported. Oracle recommends that you store multimedia content in SecureFiles LOBs, and use third-party products for image processing and conversion.

See "SecureFiles"

• Oracle Streams

Starting in Oracle Database 19c, Oracle Streams is desupported.

See "Oracle GoldenGate"

Oracle Database 19c white paper is attached in this page.

Upgrade to 19c

https://oracledbwr.com/oracle-19c-database-upgrade-from-11-2-0-4-to-19-2-0-0-using-manual-method/

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html