8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 21c » Here


Oracle 21c Articles

Innovation Release Warning

Oracle 21c is an innovation release, which means it has a short support lifespan. For many production systems you should probably stick with Oracle 19c until the next long term release (23c) is available. Please consider carefully if Oracle 21c is correct for your situation. You can read more about this here.

Oracle Database 21c : Miscellaneous Articles

Analytic Function Syntax Enhancements in Oracle Database 21c - This article describes the syntax enhancements to analytic function introduced in Oracle database 21c.

ANY_VALUE Aggregate Function in Oracle Database 21c - The ANY_VALUE function allows us to safely drop columns out of a GROUP BY clause to reduce any performance overhead.

Attention Log in Oracle Database 21c - The attention log is a JSON formatted file introduced in Oracle 21c to capture critical events, making system diagnostics easier.

Auditing Enhancements in Oracle Database 21c - This article gives an overview of the auditing enhancements in Oracle database 21c.

BIT_AND_AGG, BIT_OR_AGG and BIT_XOR_AGG Analytic Functions - This article gives an overview of the BIT_AND_AGG, BIT_OR_AGG and BIT_XOR_AGG analytic functions, introduced in Oracle database 21c.

Blockchain Tables in Oracle Database 21c - A blockchain table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.

CHECKSUM Analytic Function - This article gives an overview of the CHECKSUM analytic function introduced in Oracle database 21c.

Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 21c - This article contains an example of setting up a physical standby database for Oracle 21c using the Data Guard Broker.

Data Guard : The PREPARE DATABASE FOR DATA GUARD Command in Oracle Database 21c - The PREPARE DATABASE FOR DATA GUARD command simplifies the setup of the primary database when configuring Data Guard in Oracle database 21c.

Data Pump (expdp, impdp) Enhancements in Oracle Database 21c - This article gives an overview of the Data Pump enhancements in Oracle Database 21c.

Data Pump Export (expdp) to and Import (impdp) From Cloud Object Stores in Oracle Database 21c - Data Pump supports cloud object stores as a dumpfile location for on-prem installations from Oracle 21c onward.

DBMS_CLOUD : Installation on 19c and 21c On-Prem Databases - This article describes how to install the DBMS_CLOUD package in on-prem 19c and 21c databases.

DBMS_CLOUD Package - This article describes the basic usage of the DBMS_CLOUD package.

DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c (COMPARE_PLANS, COMPARE_CURSORS and COMPARE_EXPLAIN) - This article demonstrates how to compare execution plans using the DBMS_XPLAN package in Oracle Database 19c and 21c.

Immutable Tables in Oracle Database 21c - An immutable table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.

FOR LOOP Iteration Enhancements in Oracle Database 21c - The FOR LOOP iteration control has been enhanced in Oracle database 21c, making it much more flexible.

Gradual Database Password Rollover Time (PASSWORD_ROLLOVER_TIME) in Oracle Database 19c and 21c - From Oracle 21c onward we can define a password rollover time, which allows us to connect using both the old and the new passwords during the gradual rollover time period. This feature was backported to Oracle 19c in the 19.12 release update.

JSON Support Enhancements in Oracle Database 21c - Oracle 21c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

JSON Data Type in Oracle 21c - The JSON data type was introduced in the Oracle 20c preview release to provide native JSON support and improve the performance of JSON processing. It has become generally available in Oracle 21c.

JSON_SCALAR in Oracle Database 21c - The JSON_SCALAR function creates an instance of a JSON type from a SQL scalar value.

JSON_TRANSFORM in Oracle Database 21c - The JSON_TRANSFORM function was introduced in Oracle database 21c to simplify the modification of JSON data.

KURTOSIS_POP and KURTOSIS_SAMP Analytic Functions - The KURTOSIS_POP and KURTOSIS_SAMP analytic functions were added in Oracle 21c to describe the "tailedness" or shape of a probability distribution.

Multitenant : Common Mandatory Profiles in the CDB Root in Oracle Database 21c - This article demonstrates using a common mandatory profile to enforce password complexity in all PDBs without affecting existing user-level profiles.

Multitenant : Dynamic CPU Scaling - Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT - Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling.

Multivalue Function-Based Indexes for JSON_EXISTS in Oracle Database 21c - Multivalue function-based indexes allow us to index multiple scalar values in JSON documents stored in the JSON data type.

Oracle Cloud : Autonomous Database (ADW or ATP) - Export Data to an Object Store (expdp) - This article demonstrates how to export data from an Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP) service on the Oracle Cloud using the expdp utility.

Oracle SQL and PL/SQL Enhancements in Oracle Database 21c - This page provides links to all the separate articles on SQL and PL/SQL enhancements in Oracle Database 21c.

Qualified Expressions Enhancements in Oracle Database 21c - Oracle database 21c makes it even easier to populate collections using qualified expressions.

Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 18c, 19c and 21c - This post summarises the enhancements to the scheduler in Oracle Database 18c, 19c and 21c.

SKEWNESS_POP and SKEWNESS_SAMP Analytic Functions - The SKEWNESS_POP and SKEWNESS_SAMP analytic functions were added in Oracle 21c to measure asymmetry, or skew, in the distribution of data.

Space Management Enhancements in Oracle Database 21c - This article describes the space management enhancements in Oracle database 21c.

SQL Macros in Oracle Database 21c - SQL Macros improve code reuse by factoring out common expressions and statements into reusable components.

SQL Set Operator Enhancements (EXCEPT, EXCEPT ALL, MINUS ALL, INTERSECT ALL) in Oracle Database 21c - Oracle 21c includes a number of enhancements to SQL set operators including EXCEPT, EXCEPT ALL, MINUS ALL and INTERSECT ALL.

Using Expressions in Initialization Parameters in Oracle Database 21c - Oracle database 21c introduced the ability to use expressions to set initialization parameters. These expressions can reference other parameters and environment variables.

Oracle 21c : Upgrade Overview - An overview of the process of upgrading to Oracle database 21c, with links to more detailed articles.

Multitenant : Upgrade to Oracle Database 21c (AutoUpgrade) - This article provides an overview of upgrading an existing multitenant database to Oracle 21c on the same server using AutoUpgrade.

Multitenant : Unplug/Plugin PDB Upgrade to Oracle Database 21c (AutoUpgrade) - This article provides an overview of upgrading an existing PDB to Oracle 21c on the same server using AutoUpgrade Unplug/Plugin.

Upgrade Non-CDB to Oracle Database 21c (AutoUpgrade) - This article provides an overview of upgrading a non-CDB database to Oracle 21c on the same server using AutoUpgrade.

Upgrade Non-CDB to Oracle Database 21c (Manual) - Replay Upgrade - This article provides an overview of a manual upgrade of an existing non-CDB database to Oracle 21c using Replay Upgrade.

Upgrade the Database Time Zone File Online Using the DBMS_DST Package - The DBMS_DST package was introduced to simplify the process of upgrading the database time zone file, as well as the time zone data based on new time zone file.

Oracle Database 21c : Installations

Oracle Database 21c Installation On Oracle Linux 7 (OL7) - This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Database 21c Installation On Oracle Linux 8 (OL8) - This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 8 (OL8) 64-bit.

Oracle Database 21c RPM Installation On Oracle Linux 7 (OL7) and Oracle Linux 8 (OL8) - This article describes the RPM installation of Oracle Database 21c 64-bit on Oracle Linux7 (OL7) 64-bit.

Oracle Database 21c Installation On Fedora 34 (F34) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 34 (F34).

Oracle Database 21c Installation On Fedora 35 (F35) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 35 (F35).

Oracle Database 21c Installation On Fedora 36 (F36) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 36 (F36).

Oracle Database 21c Installation On Fedora 37 (F37) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 37 (F37).

Oracle Database 21c Installation On Fedora 38 (F38) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 38 (F38).

Oracle Database 21c Installation On Fedora 39 (F39) - This article describes the installation of Oracle Database 21c 64-bit on Fedora 38 (F39).

Oracle Database 21c Express Edition (XE) RPM Installation On Oracle Linux 7 (OL7) and 8 (OL8) - This article describes the Oracle Database 21c Express Edition (XE) RPM installation on Oracle Linux 7 (OL7) and 8 (OL8) 64-bit.

Oracle Database 21c RAC On Oracle Linux 7 Using VirtualBox and Vagrant - This article describes the hands-off installation of Oracle Database 21c RAC on Oracle Linux 7 using VirtualBox and Vagrant with no additional shared disk devices.

Oracle Database 21c RAC On Oracle Linux 8 Using VirtualBox and Vagrant - This article describes the hands-off installation of Oracle Database 21c RAC on Oracle Linux 8 using VirtualBox and Vagrant with no additional shared disk devices.

External 21c Links

Documentation: Oracle Database 21c

Introducing Oracle Database 21c

What Happened to Oracle Database 20c?

Oracle 20c was a preview-only release and was never generally available. As a result, all the new features of Oracle database 20c are now considered new features of Oracle database 21c, as this was the first generally available release to contain these features.

What Happened to Oracle Database 22c?

Oracle have announced there will be no 22c release, so the next release after 21c will be 23c, which will be the next long term release.