• Force Upgraded Password File to be Case Sensitive

Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive. 

  • SYSLOG Destination for Common Unified Audit Policies

Certain predefined columns of unified audit records from common unified audit policies can be written to the UNIX SYSLOG destination.

  • Unified Audit Policies Enforced on the Current User

Starting with this release, unified audit policies are enforced on the current user who executes the SQL statement.

  • Unified Audit Policy Configuration Changes Effective Immediately

Starting with this release, changes made to a unified audit policy become effective immediately in the current session and in all other on-going active sessions.

  • Ability to Set the Default Tablespace Encryption Algorithm

You now can set the TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM 

dynamic parameter to define the default encryption algorithm for tablespace creation operations.

  • Oracle Blockchain Table

Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time

  • Data Guard Broker Far Sync Instance Creation

The Data Guard Broker now enables users to create and add a Far Sync instance to a Data Guard Broker configuration using a single command.

  • Standby CDB Continuity

PDB data files that are in an inconsistent state with the primary (i.e. cloned, flashback events) are recovered separately without the need to impact normal Active Data Guard operations for the Standby CDB(s) which required a short pause in operations previously.

  • Oracle ASM Flex Disk Group Support for Cloning a PDB in One CDB to a New PDB in a Different CDB

This feature enables you to use Oracle ASM cloning for test and development cloning where the cloned PDB must be in a separate CDB.

  • Enable ASMCA to Configure Flex ASM on an Existing NAS Configuration

This feature enables you to install Oracle Flex ASM on a configuration previously configured on network file storage (NFS). In particular, Oracle ASM Configuration Assistant (ASMCA) can be run in silent mode to configure Oracle ASM after an Oracle Clusterware installation has been performed using network attached storage (NAS) for Oracle Cluster Registry (OCR) and Voting disks.

  • Oracle ACFS File Based Snapshots

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) file-based snapshots provide the ability to create snapshots of individual Oracle ACFS files in a space efficient manner on Linux.

  • Pluggable Database Cluster Resources

Pluggable Database (PDB) Cluster Resources enables direct mapping and control of those PDB resources.

  • Clusterware REST API

The Clusterware REST APIs enable customers to remotely execute commands on their cluster and to monitor the execution, including output, error codes and time to execute. 

  • PDB Point-in-Time Recovery or Flashback to Any Time in the Recent Past

PDBs can be recovered to an orphan PDB incarnation within the same CDB incarnation or an ancestor incarnation.

  • MAX_IDLE_BLOCKER_TIME Parameter

MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination.

  • Cache Fusion Hardening

Cache Fusion Hardening increases availability by reducing outages, particularly in consolidated environments in which multiple Pluggable Databases (PDBs) are operated in the same Oracle RAC Container Database.

  • Support for Deploying Grid Infrastructure Management Repository (GIMR) into a Separate Oracle Home

Starting with Oracle Grid Infrastructure 20c, you must configure the Grid Infrastructure Management Repository (GIMR) in a separate Oracle home, instead of in the Grid home. 

  • Remote GIMR Support for Oracle Standalone Clusters

The remote Grid Infrastructure Management Repository (GIMR) feature for Oracle Standalone Cluster enables you to use a centralized GIMR. This feature does not require local cluster resources to host the GIMR.

  • Oracle Data Pump Includes and Excludes in the Same Operation

Starting with Oracle Database 20c, Oracle Data Pump can include and exclude objects in the same export or import operation.

  • Oracle Data Pump Resumes Transportable Tablespace Jobs

Starting with Oracle Database 20c, Oracle Data Pump resumes transportable tablespace export and import jobs that are stopped.

  • Oracle Data Pump Provides Optional Index Compression

In Oracle Database 20c, Oracle Data Pump supports optional index compression on imports, including for Oracle Autonomous Database.

  • Oracle Data Pump Exports from Oracle Autonomous Database

Starting with Oracle Database 20c, Oracle Data Pump can perform exports from Oracle Autonomous Database into dump files in a cloud object store.

  • Oracle Data Pump Checksums Support Cloud Migrations

Starting with Oracle Database 20c, a checksum is now added to the dumpfile. You can use the checksum to help to confirm that the file is valid after a transfer to or from the object store and also after saving dumpfiles on on-premises and that it has no accidental or malicious changes.

  • Oracle Database Automates Database Upgrades with AutoUpgrade

Oracle Database AutoUpgrade enables you to upgrade one or many databases without human intervention, all with one command, and with a single configuration file.

  • FLASHBACK_ARCHIVE_MIGRATE Package

A new PL/SQL package called FLASHBACK_ARCHIVE_MIGRATE enables the migration of Flashback Data Archive enabled tables from a database on any release (in which the package exists) to any database on any release (that supports Flashback Data Archive).

Books

Download the Oracle Database 20c book from zip file.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.