Feature Oracle Database 12c, 19c, 21c
Introduction:
Oracle is by far the leader in all key leading research reports for On-prem and Cloud Database Management Systems. Oracle is continuously building new features on Database on Oracle Cloud Infrastructure (OCI) Autonomous Database (including the Autonomous Transaction Processing and Autonomous Data Warehouse services) are available in OCI
Cause of the issue:
Feature of the oracle database comparison.
Comparing Top 10 Features in Oracle Database:
| Feature | 12.x | 19c | 21c |
| ASM Database Cloning | No | ASM database cloning provides cloning of Multitenant databases (PDBs). This feature works by leveraging ASM redundancy. | ASM database cloning provides cloning of Multitenant databases (PDBs). This feature works by leveraging ASM redundancy. |
| Ability to Create Schema Only Accounts | No | You now can create schema only accounts, for object ownership without allowing clients to log in to the schema. | You now can create schema only accounts, for object ownership without allowing clients to log in to the schema. |
| Ability to Create a PDB by Cloning a Remote PDB Using DBCA in Silent Mode | No | You can now create a pluggable database (PDB) by cloning a remote PDB using the create From Remote PDB parameter of the create Pluggable Database | You can now create a pluggable database (PDB) by cloning a remote PDB using the create From Remote PDB parameter of the create Pluggable Database |
| Ability to Prevent Local Oracle Database Vault Policies from Blocking Common Operations | No | NO | Starting with this release, a DV_OWNER common user in the CDB root can prevent local users from creating Oracle Database Vault controls on Oracle Database Vault |
| Ability to Use Encrypted Passwords for Database Links with Oracle Data Pump | No | The behavior for handling database link passwords has changed in this release. Passwords in database links are now encrypted. | The behavior for handling database link passwords has changed in this release. Passwords in database links are now encrypted. |
| Active Data Guard – Standby Result Cache | No | NO | The result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database |
| Analytic View Enhancements to SQL and PL/SQL | NO | NO | SQL and PL/SQL enhancements for analytic views are the following: (1) Star views can be created on fact and dimension tables (2) Analytic views are created automatically for queries of the tables and views |
| Application Backups | NO | NO | Oracle Application Express automatically backs up modified applications as a part of daily maintenance. |
| Auto Upgrade Automates Upgrade and Conversion of Non-CDB to PDB | NO | NO | In Oracle Database 21c, Auto Upgrade automates all the steps needed to upgrade an Oracle Real Application Clusters (Oracle RAC) database. |
| Auto Upgrade Automates Steps Required for Oracle RAC Database Upgrade | NO | NO | To simplify upgrades to Oracle Database 21c, Auto Upgrade automates steps to convert a database from a non-CDB to a PDB as part of a database |
Recent Posts
