Here are a few reasons why you should migrate to the long term support release 19c of the Oracle Database. The purpose of this article isn’t to make you panic, no … just to inform you about the nice and useful features of the latest Oracle Database releases.
Oracle Database 19c is the terminal release of the Oracle 12c database family and with long term support until the end of March 2026. When the next long term support release will be available isn’t known yet!
From Oracle Database 12c version 220.127.116.11 the non-CDB architecture was announced to be deprecated and in Oracle Database 20c de-supported, meaning that 19c was the last supported version with a non-CDB architecture. We at Exitas recommend using the CDB architecture as soon as possible to avoid surprises, from 19c onwards 3 user-defined PDBs are allowed without needing the paid Multitenant option.
The Oracle Database 20c version 20.2.0 is available in preview from the Oracle Cloud, here are some new useful features and some enhancements briefly explained:
- Data Pump
INCLUDE and EXCLUDE parameters in the same export or import operation can be used.
This enhancement makes it easier to migrate, because the process will use the INCLUDE parameter first, and then it processes the EXCLUDE parameter and eliminate the specified objects.
Export and import jobs of transportable tablespaces are resumable and can be done in parallel.
- Blockchain Tables
Deleting records is either prohibited or restricted in a blockchain table, an append-only table made tamper-resistant by special sequencing and chaining mechanisms. A new security feature that reduces database administration.
- Multitenant Architecture
Starting in Oracle Database 20c, a multitenant container database is the only supported architecture, previous releases are still supporting non-container databases (non-CDBs). Prior to Oracle Database 19c only one single user-defined pluggable database was allowed without having to license the full multitenant option, since 19c up to 3 PDBs in a given container can be used if not licensed for Oracle Multitenant.
- Oracle ACFS
Automatic shrinking of an Oracle Automatic Storage Management Cluster File System based on a policy and if there is enough free storage.
Oracle ACFS is de-supported with Microsoft Windows.
- Data Encryption
Package DBMS_OBFUSCATION_TOOLKIT was already deprecated since Oracle Database 11g version 11.2 and is de-supported in 20c, functionality is replaced by DBMS_CRYPTO and some older encryption and hashing algorithms are deprecated.
A new dynamic parameter TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM can define the default encryption algorithm for tablespace creation operations. The parameter ENCRYPT_NEW_TABLESPACES was already available starting from Oracle Database 12c Release 2 version 18.104.22.168.
- SQL Macros
Encapsulate complex processing within a macro so it can be used anywhere inside a SQL statement within Oracle Database 20c. The SQL and PL/SQL are two separate engines that are regularly used together, but that usage is causing context switching and so slowing down the execution. The introduction of the UDF pragma in Oracle Database 12c Release 1 (a compiler directive) was already reducing the runtime overhead of the context switch, but SQL Macros (SQM) are functions that are executed only once at parse time and will be encapsulated within the SQL statement, as a result … no context switch at all.
… and many, many more useful features in Oracle 19c and higher.
Direct upgrade paths to Oracle Database 19c are:
When direct upgrade is not supported, other methods of upgrading to Oracle Database 19c will be:
- Command-Line with dbupgrade or the new autoupgrade or DBUA.
- Transportable tablespaces, using database feature full transportable or traditional TTS.
- Data Pump, using either files or a network link.
Already stressing to upgrade your environment? Indeed, complex environments can be tricky to upgrade. Exitas provides consultancy to support you during the upgrade traject. Your options?
– We can perform the upgrade from A-Z.
– Let us perform a POC and get a personalised overview of the different steps you need to take in order to successfully upgrade your environment.
– Want to have an(other) expert standby during the upgrade? Ask for a flexible standby offer.