Top Oracle Database 21c new features

            New Features in Oracle Database 21c  (21.1)

Oracle 21c - Innovation Release includes 2 years of Premier Support, but there is no Extended Support.

21c Oracle Database released in January 2021.

• Multilingual Engine - JavaScript Execution in the Database
• Binary JSON Data Type - Oracle 21c includes several enhancements to the JSON functionality in the database JSON_SCALAR function creates an instance of a JSON type from a SQL scalar value. JSON_TRANSFORM function was introduced in Oracle Database 21c to simplify the modification of JSON data.

• Per-PDB Data Guard Physical Standby (aka Multitenant Data Guard)
• Per-PDB GoldenGate (OGG) Change Capture
• Multitenant : Dynamic CPU Scaling - Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle calls this Dynamic CPU Scaling.

• Self-Managing In-Memory
• In-Memory Hybrid Columnar Scan
• In-Memory Vector Joins with SIMD
• Blockchain Tables & Immutable Tables in Oracle 21c Databases - A blockchain/immutable table is a tamper-proof, insert-only table with an associated table-level and row-level retention period.
• Sharding Advisor Tool
• Property Graph Visualization Studio
• Automatic Materialized Views
• Automatic Zone Maps

• Oracle 21c makes it easier to populate collections using qualified expressions.
• SQL Macros - to improve code reuse by factoring out common expressions and statements into reusable components.
• Gradual Password Rollover
• FOR LOOP iteration control has been enhanced in Oracle 21c, making it much more flexible.
• Oracle Database 21c introduced the ability to use expressions to set initialization parameters. These expressions can reference other parameters and environment variables.




• export and import utilities include support for the new JSON data type
• CHECKSUM (yes/no), CHECKSUM_ALGORITHM (CRC32, SHA256, SHA384, SHA512), VERIFY_ONLY(yes/no) and VERIFY_CHECKSUM(yes/no) Parameters.
• In Oracle database 21c, INCLUDE and EXCLUDE parameters can be part of the same command. In previous releases INCLUDE and EXCLUDE parameters were mutually exclusive.
• In Oracle database 21c we can optionally compress indexes on import using the TRANSFORM parameter and the INDEX_COMPRESSION_CLAUSE.
• Import the table from the dump file, using the TRANSFORM parameter to compress the table using the TABLE_COMPRESSION_CLAUSE and the indexes using the INDEX_COMPRESSION_CLAUSE.
• In Oracle 21c transportable tablespace exports (expdp) and imports (impdp) can now use the PARALLEL parameter to parallelize the operations.
• In Oracle 21c Data Pump can resume failed transportable tablespace jobs at, or near, the point of failure. In previous releases transportable tablespace jobs could not be resumed.
• Data Pump supports cloud object stores as a dumpfile location for on-prem installations from Oracle 21c onward.
• New parameter MAX_IDLE_BLOCKER_TIME specifies the maximum number of minutes that a blocking session can be idle. After that point, the session is automatically terminated.

Related Oracle Articles: What's New in Oracle 19c Release 1