Oracle Database 19c: New Features for Administrators

Course overview

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.

Topics of the database overall module cover new features such as DBCA, OUI and Data Pump enhancements.

Topics of the security module cover enhancements such as key management of encrypted Oracle-managed tablespaces in TDE, and Database Vault operations control.

Topics of the availability module cover enhancements in RMAN such as recovery catalog connection when user is connected to target database as PDB.

Topics of the performance module cover enhancements such as PDB-level ADDM analysis, Memoptimized Rowstore — Fast Ingest deferred writes, and enabling SQL developers to use Real-Time SQL Monitor.

Topics of the data warehousing module cover enhancements such as hybrid partitioned tables and automated indexing.

Topics of the diagnosability module cover new features such as an end-to-end automated service for fault prediction, detection and fixation to avoid or minimize the human intervention, and new service request data collections determining the data to collect for crucial errors.

Topics of the sharding module cover enhancements such as the support for multiple PDB-shards in the same CDB and of multiple table family for system-managed sharding.

Course Objectives

Upon completion of this course, the student should be able to:

• Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area
• Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area