Oracle Database 19c: New Features for Administrators

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data 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 the user is connected to the 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.

Audience

This course is intended for experienced Oracle Database Administrators, System Administrators, Developers

Prerequisites

Good knowledge of Oracle Database previous versions

Course topics

  • Using General Database Overall Enhancements
  • Using Security Enhancements
  • Using Availability Enhancements
  • Using Performance Enhancements
  • Using Big Data and Data Warehousing Enhancements
  • Using Diagnosability Enhancements
  • Sharding Enhancements

Other relevant courses

16. November
5 days
Classroom On Demand
14. December
3 days
Classroom On Demand
14. December
3 days
Classroom On Demand
16. November
5 days
Classroom Connect2Classroom On Demand