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 SolutionsIn-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 PropertyGraph 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 OptionsStandby 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:
More Oracle Cloud Documents: https://suggestcloud.com/category/oci/
Learn Oracle Cloud for Free For Paid Course whats apps- +91-7607456651 (Shweta Dutta)
No comments:
Post a Comment