What’s new in Oracle Database 20c
The latest annual release of the world’s most popular database, Oracle Database 20c, is available for preview on Oracle Cloud (Database Cloud Service Virtual Machine).
Oracle Database 20c introduces key new features and enhancements that further extend Oracle’s multi-model converged architecture with the introduction of Native Blockchain Tables and more performance enhancements such as Automatic In-Memory (AIM) and a binary JSON datatype.
Starting with Oracle Database 20c, the installation of non-CDB Oracle Database architecture is no longer supported.
The New Features List of Oracle 20c Database for DBAs: –
General
- Blockchain tables
- SQL_MACRO instead functions
- Expressions in Parameters
- Multiple Datapump enhancements
- PDB Point in Time recovery
- MAX_IDLE_BLOCKER_TIME Parameter
- SecureFile Lob online defragmentation
- Namespace integration with Nest for CDB/PDB
Dataguard
- Data Guard Broker Far Sync Instance Creation
- Standby CDB Continuity
- Active data guard — result cache in standby
RAC
- Clusterware REST API
- Pluggable Database Cluster Resources
- Remote GIMR Support for Oracle Standalone Clusters
- Support for Deploying Grid Infrastructure Management Repository (GIMR) into a Separate Oracle Home
- Cache Fusion Hardening
- New Datatype “JSON”
ASM
- Oracle ASM Flex Disk Group Support for Cloning a PDB in One CDB to a New PDB in a Different CDB
- Enable ASMCA to Configure Flex ASM on an Existing NAS Configuration
- Oracle ACFS File-Based Snapshots
Performance Troubleshooting
- Index Optimization
- TAC — Reset_sessions service attribute
- Planned failover with TAC
Security
- Force Upgraded Password File to be Case Sensitive
- SYSLOG Destination for Common Unified Audit Policies
- Unified Audit Policies Enforced on the Current User
- Unified Audit Policy Configuration Changes Effective
- Ability to Set the Default Tablespace Encryption Algorithm
The Atlas Advantage:
Atlas Systems provides businesses with comprehensive database support services that manage all the database support requirements. Our team of experts works with clients to recommend and perform every database support task required.
We provide end to end database services across the globe including — Database Engineering, Support for DB Administration, SME, Backup & Recovery, 24/7 Coverage along with Upgrade / Migration Tuning, and Health Assessment / Performance Tuning.
The original article was published on — https://www.atlassystems.com/blog/whats-new-in-oracle-database-20c/