Call Us on +49 32 121 237 207

TK1012

Course Modules

Explore new Oracle Data Pump features and SQL*Loader Express Mode

• Explore new Oracle Data Pump features and SQL*Loader Express Mode
• Create, manage and monitor multitenant container databases and pluggable databases and their resources consumption with Resource Manager
• Manage datafile online operations, heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and Temporal History
• Manage security by using the new unified auditing, the new privileges, such as SYSBACKUP, the privilege analysis, and by creating and managing Data Redaction policies
• Use the Recovery Manager enhancements
• Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM
• Understand the new in-memory capabilities of the Database In-Memory, Full Database In-Memory
• Caching, and Automatic Big Table Caching
• Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements
• Use online operations during partition movement and compression, and other DDL operations
• Use partial global partitioned indexes
• Explain new SQL enhancements such as extended data type column and SQL row limiting clause
• Gain an understanding of the Oracle Database Cloud Service

Subcribe weekly newsletter