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 Finland

Finland is a country located in northern Europe. Helsinki is the capital and largest city of the country. The majority of the people are Finns but there is also a small Lapp population in Lapland, where the country is famous for the Northern Lights. Finland's national languages are Finnish and Swedish.

Known for its vast forests, lakes, and natural beauty, Finland is one of the world's largest producers of forest products, such as paper, pulp, and lumber. One of the world's largest sea fortresses Suomenlinna, Rovaniemi with the "White Nights", dogsled safaris and of course the Northern Lights are what makes Finland so popular for tourists. Finland is one of the best places in the world to see the Northern Lights and attracts millions of tourists during its seasons.

Finland is home to a thriving technology industry and is widely recognized as one of the world's leading technology hubs. Companies such as Nokia and Rovio (creator of the popular game Angry Birds) are based in Finland. Some of the key factors that have contributed to Finland's success in technology include; strong investment in research and development, a highly educated workforce and fundings.

Finland has a strong educational system, and is widely regarded as one of the world's most literate countries. In fact, Finland's literacy rate is one of the highest in the world, and its students consistently perform well in international tests of math and reading ability.

Also, as a pioneer in environmental sustainability, Finland is known for its efforts to reduce its carbon footprint and promote clean energy. This Nordic country is also famous for its unique and distinctive cultural heritage, including its traditional folk music and its elaborate traditional costumes.

Helsinki, Finland's capital city, is the country's business center. Helsinki is Finland's largest city, and it is home to many of the country's major corporations and organizations, including many of the country's leading technology firms. The city is also a commercial, trade, and financial center, as well as one of the busiest ports in the Nordic region.

Take advantage of our diverse IT course offerings, spanning programming, software development, business skills, data science, cybersecurity, cloud computing and virtualization. Our knowledgeable instructors will provide you with practical training and industry insights, delivered directly to your chosen venue in Finland.

Oracle Database 23ai: New Features for Administrators Training in Finland

Upcoming Trainings

Oracle Database 23ai: New Features for Administrators Training in Finland

Prerequisites

Outline

Upcoming Trainings