Oracle 20c New Features for DBA

Oracle 20c is available for preview mode on the Oracle Public Cloud. Preview version databases are not intended for production use and have limited functionality. Provisioning database on cloud is very easy with less configuration required compare to earlier released.


We are highlighting few changes which we observed during test.


Architecture Change.

From Oracle 20c onwards only multitenant container database architecture is supported.

Blockchain tables

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

PDB Point in time recovery

Form Oracle 20c onwards flashback and PITR are supported when recovering PDBs to an ancestor or orphan PDB incarnations. Which will help you in recovery for specific PDB if the PDB is in the same CDB level incarnation.

Automatic Index Optimization

Oracle 20c onwards, you do not need to bother about index rebuilding, shrinking and managing them. DBA can automate this using feature Automatic Data Optimization option + marking the indexing to certain tier/policies.

The optimization process includes actions such as compressing, shrinking, or rebuilding the indexes:

Data Pump Enhancement

Lots of new features included in Data Pump for DBA to minimize operation time day to day activity. Oracle Data Pump can include and exclude objects in the same export or import operation meaning that now, Oracle Data Pump commands can include both INCLUDE and EXCLUDE parameters in the same operation. Please make a note when you include both parameters in a command, Oracle Data Pump processes the INCLUDE parameter first, and includes all objects identified by the parameter. Then it processes the EXCLUDE parameters, eliminating the excluded objects from the included set.

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

Oracle Data Pump Provides Optional Index Compression

Oracle Data Pump supports optional index compression on imports, including for Oracle Autonomous Database. Oracle Data Pump supports adding, changing and eliminating table compression. Oracle Database 20c supports index compression as well by introducing a new TRANSFORM parameter clause, INDEX_COMPRESSION_CLAUSE. This clause enables you to control whether index compression is performed during import. Adding this clause also enables you to specify index compression on import with the autonomous services.

Oracle Data Pump Exports from Oracle Autonomous Database

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.

Lots of change on parameter level also.

New Initialization Parameters

  • DBNEST_ENABLE: DbNest provides operating system resource isolation and management, file system isolation, and secure computing for PDBs.

  • DBNEST_PDB_FS_CONF: specifies the dbNest file system configuration file for a PDB. ( only on Linux systems)

  • DIAGNOSTICS_CONTROL : Enables you to control and monitor the users who perform potentially unsafe database diagnostic operations.

  • INMEMORY_DEEP_VECTORIZATION: Enables or disables the deep vectorization framework. Deep vectorization can optimize complex SQL operations (such as joins) by pipelining physical operators inside each SQL operator and vectorizing them.

  • PMEM_FILESTORE: Specifies the Persistent Memory Filestores (PMEM Filestores) that the database automatically mounts during instance startup.

  • TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM: specifies the default algorithm the database uses when encrypting a tablespace.

Few parameters is also depreciated as well.

Deprecated/Dropped Initialization Parameters

  • AUDIT_FILE_DEST

  • AUDIT_SYS_OPERATIONS

  • AUDIT_SYSLOG_LEVEL

  • AUDIT_TRAIL

  • IGNORE_CASE

  • UNIFIED_AUDIT_SGA_QUEUE_SIZE

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.

Force Upgraded Password File to be Case Sensitive

Old method for the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive.

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.

For More Details, you can reach us using the below link. 

YOUTUBE: HTTPS://WWW.YOUTUBE.COM/DBATRAINING

TELEGRAM APP: HTTPS://T.ME/DBAHELP

WEBSITE: HTTP://DBATRAININGS.COM/ EMAIL: INFO@DBATRAININGS.COM

LINKEDIN: HTTPS://WWW.LINKEDIN.COM/IN/DBATRAININGS/ FB PAGE: HTTPS://WWW.FACEBOOK.COM/DBATRAININGS/ FB GROUP: HTTPS://WWW.FACEBOOK.COM/GROUPS/402208687087064/


87 views

ADDRESS :

LOCATION :

701, Linden, Rosalie Complex Khadakpada, Kalyan (W) Mumbai, Maharashtra 421301)

CONTACT US :

+919322846017  &   +919867493019

EMAIL: 

QUICK LINKS :

SUBSCRIBE HERE :

Don’t Miss a Lecture. Subscribe Today. 

telegram-512.png

© 2019 DBA Trainings. Proudly Managed By Pearl Organisation

  • Grey LinkedIn Icon
  • Grey YouTube Icon
  • Grey Twitter Icon
  • Grey Facebook Icon