Oracle 20c New Features and Step by Step Installation Oracle Database 20c on Oracle Cloud

The latest annual release of the world's most popular database, Oracle Database 20c, is now available. Learn Oracle Cloud Infrastructure:

Introduction:

Oracle Database 18c,19c and now 20c  is the latest generation of the world’s most popular database, and may be deployed on-premises and/or in Oracle Cloud running on general purpose hardware or engineered systems specifically designed for database workloads such as Oracle Exadata and Oracle Database Appliance.

Oracle Database Release 20C New Features:

 Big Data and Data Warehousing Solutions

• In-Memory Deep Vectorization: Oracle Database optimizes hash joins by pushing operations down into the scans of both sides of the join.
• Self-service Low-code Spatial Studio.
• Property Graph: Graph Server and Client Kit : You no longer have to copy the Property 
• Graph in-memory analytics server (PGX) and client tools and libraries from $ORACLE_HOME.
• New NETWORK_DATASTORE Data Store Type for Oracle Text: Starting with Oracle Database 20c, you can use a new data store type called NETWORK_DATASTORE instead of the deprecated URL_DATASTORE data type.
• Automatic Synchronization and Index Optimization: Automatic synchronization is now the default for new indexes. Automatic background optimization works on all index tables. 

Security Solutions

• Force Upgraded Password File to be Case Sensitive.
• Connect to Multiple Databases with Different Certificates from a single client.
• 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. 
• Rows in a blockchain table are made tamper-resistant by special sequencing & chaining algorithms. Users can verify that rows have not been tampered. A hash value that is part of the row metadata is used to chain and validate rows.

Performance and High-Availability Options

• 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.
• Active Data Guard - Standby Result Cache
• Oracle ASM Flex Disk Group Support for Cloning a PDB in One CDB to a New PDB in a Different CDB
• Hybrid In-Memory Scans: Oracle Database supports in-memory scans when not all columns in a table have been populated into the In-Memory Column Store (IM column store).
• Database In-Memory External Table Enhancements

 Tools and Languages

• Analytical SQL and Statistical Functions
• Bitwise Aggregate Functions
• Oracle Machine Learning for SQL
• Oracle JVM Security Enhancements
• Database Upgrade and Utilities: Oracle Data Pump Includes and Excludes in the Same Operation
• Oracle Data Pump Resumes Transportable Tablespace Jobs
• The FLASHBACK_ARCHIVE_MIGRATE Package
• Oracle Database Automates Database Upgrades with AutoUpgrade

 Database Upgrade and Utilities

• Database Upgrade and Utilities: Oracle Data Pump Includes and Excludes in the Same Operation
• Oracle Data Pump Resumes Transportable Tablespace Jobs
• The FLASHBACK_ARCHIVE_MIGRATE Package
• Oracle Database Automates Database Upgrades with AutoUpgrade

Installation:

Oracle 20c database is only available in Preview mode. Learn how to install Database in Oracle Cloud Click Here

Preview Image of Oracle 20c Database

Oracle Database 20c – Documentation and Cloud availability: Ref (Oracle Doc)

 More Oracle Cloud Documents: https://suggestcloud.com/category/oci/ 

 Learn Oracle Cloud for Free 

Follow Us:

Twitter - Linkedin - Instagram- Facebook- Youtube Videos