We can host this training at your preferred location. Contact us!

This course covers the latest additions and improvements in Oracle Database 23ai. It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on performance, architecture, security, and database sharding. The topics include updates to Blockchain Tables, Data Migration with RMAN, Wide Tables, and Lock-Free Reservations.

Existing database administration experience on a modern version of Oracle Database.

Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.

Module 1: Blockchain Table

Blockchain Tables 23c New Features

Objectives
Blockchain Table Overview
Blockchain Table User Chains
Blockchain Table Delegate Signer
Blockchain Table Countersignature
Summary

Module 2: Availability

Simplified Database Migration Across Platforms Using RMAN Backups

Objectives
Overview
Methods of transporting with Recovery Catalog
Methods of transporting in NOCATALOG mode
Methods of transporting over network link
Prerequisites generic
Prerequisites specific
Recovery Catalog methods for PDBs
Transport a PDB by using a pre-existing Backup with Recovery Catalog
Transport a PDB using multiple increamental Backups with Recovery Catalog
Recovery Catalog methods for Tablespaces
Recovery Catalog method for Tablespaces
Transport a Tablespace by using a pre-existing Backup with Recovery Catalog
Transport a Tablespace using multiple incremental Backups with Recovery Catalog
Transport a by using multiple incremental Backups with Recovery Catalog
Methods of transporting in NOCATALOG mode
NOCATALOG mode for PDBs
Quickly transport a PDB NOCATALOG
Transport a PDB using a pre-existing Backup NOCATALOG
Transport a PDB using multiple incremental Backups NOCATALOG
NOCATALOG mode for Tablespaces
Quickly transport a Tablespace NOCATALOG
Transport a Tablespace by using a pre-existing Backup NOCATALOG
Transport a Tablespace using multiple incremental Backups NOCATALOG
Methods of transporting over Network Link
Quickly transport a PDB over Network Link
Transporting PDBs by Restoring Backups Incrementally over the network
Methods of transporting over Network Link
Transporting Tablespaces over Network Link
Quickly transport a Tablespace over Network Link
Transporting Tablespaces by Restoring Backups Incrementally over the network
Summary

Automatic Transaction Rollback

Objectives
Overview
Using Automatic Transaction Rollback
Automatic Transaction Rollback
Using Automatic Transaction Rollback
Monitoring
Benefits
Summary

Automatic Transaction Quarantine

Objectives
Overview
Automatic Transaction Quarantine: Workflow
Monitoring Quarantined Transactions
Resolving Quarantined Transactions
Resolving Quarantined Transaction examples
Dropping Quarantined Transactions
Quarantined Transactions escalation
Summary

Flashback Log Placement

Objectives
Flashback Log overview
Flashback Log parameters
Flashback Log management
Summary

Module 3: Database Architecture

Unrestricted Direct Loads

Objectives
Direct Loads pre 23c
Direct Loads 23c
Benefits
Summary

Lock-Free Reservations

Objectives
Optimistic vs Lock Free
Optimistic approach
Lock-Free approach
Frequently modified values
Lock-Free reservations
Lock-Free reservation features
Lock-Free reservation benefits
Functionality requriements
Create, Modify, Delete
Lock-Free Journal Table
Journal Table restrictions
Lock-Free reservations
Views
Summary

Unrestricted Parallel DMLS

Objectives
Overview parallel DML
23c parallel DML improvements
Benefits
Summary

Wide Columns

Objectives
Priori challenges
Benefits
Increase Column Limits
Performance
Summary

Improved Performance Hybrid Columnar Compression (HCC)

Objectives
HCC pre 23c
HCC in 23c
Database compatibility
Performance
Summary

Module 4: Performance

Fast Inserts Enhancements

Objectives
Fast Ingest overview (AKA Deferred Inserts)
Using Fast Ingests
Enhancements
Benefits
Management
Summary

Accelerate SecureFiles LOB Write Performance

Objectives
Overview
Benefits
Summary

Data Storage Improvements

Objectives
SecureFiles
Traditional SecureFiles Shrinking
Automatic SecureFiles Shrinking: Advantages
High-level view
Controlling Automatic SecureFiles Shrink
Automatic storage compression
Automatic storage compression and automatic clustering
Automatic storage compression: Advantages
Controlling Automatic storage compression
Summary

Module 5: Data Analytics

Oracle Dataase 23c Automatic SQL Plan Management: New Features

Objectives
Automatic SQL Plan Management: Overview
SPM Evolve Advisor
Benefits
Problems it solves
When to use
how to use it
Summary

Module 6: Manageability

Time and Date Handling Changes

Objectives
Enhanced Time Zone data upgrade
Time Zone definitions change: Considerations
Optimizing Time Zone file upgrade
Benefits of enhanced Time Zone update
Tables with TIMESTAMP WITH TIME ZONE data
New parameter in the init.ora file
Configuring database parameters
SYSDATE and SYSTIMESTAMP
Data and Time in Oracle databases
Database time verus OS System time
Database-specific time in Oracle database 23c
Setting Database-specific time: Example
Summary

Module 7: Security

Oracle Database 23c Security: New Features

Objectives
Database Security
Pluggable Database Hybrid Read-only mode
Read-Only user and session
New Developer role
Simplified Schema privileges
Simplified Schema privilages: Example
Audit object actions at the column level
Ability to control authorizations for Unified Auditing with Database Vault
Integration of Microsoft Azure Active Directory with additional Oracle database environments
Summary

Module 8: Sharding

Oracle Database 23c Sharding New Features

Objectives
Database Sharding
Oracle database Sharding
Oracle database 23c Sharding new features
Sharding native replication (RAFT-based)
Directory-based Sharding
Coordinated Backup and Restore for Sharded databases
Centralized Backup recovery
Automatic bulk data move on Sharding key update
Split/Move of a partitionset with bulk data movement
Summary

Oracle Database 23ai: New Features for Administrators Training Course in South Africa

Formerly known as Union of South Africa, now officially known as Republic of South Africa is the Southernmost country in Africa. South Africa's population is over 60 million people, which makes the country the world's 23rd-most populous nation. South Africa has three capital cities: executive Pretoria, judicial Bloemfontein and legislative Cape Town, while the largest city is Johannesburg. The official languages of South Africa are Afrikaans, English, Ndebele, Pedi, Sotho, Swati, Tsonga, Tswana, Venda, Xhosa and Zulu.

South Africa can be rainy from November to February, so the best time to visit South Africa is from May to September. Despite the rainy season South Africa is a year-round destination, with varying regional climates. Blyde River Canyon, Durban, Drakensberg, Kruger National Park and of course, Cape Town are the tourist attractions of the country.

Expand your IT knowledge with our comprehensive range of courses, including programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our skilled instructors will facilitate hands-on training and share practical insights, all conveniently conducted at your preferred location within South Africa.

Oracle Database 23ai: New Features for Administrators Training in South Africa

Upcoming Trainings

Oracle Database 23ai: New Features for Administrators Training in South Africa

Prerequisites

Outline

Upcoming Trainings