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 Norway

The Nordic country Norway, is in Northern Europe. Known for its stunning natural beauty, including fjords, mountains, and forests, Norway is also famous for its high standard of living and strong social welfare system. Norway's capital and largest city is Oslo. Tromsø, Bergen, Trondheim and Stavanger are the other tourist attracting cities of Norway.

Norway is a constitutional monarchy with King Harald V as the head of state. The country has a population of 5,425,270 as of January 2022. Norway is a relatively small country and has a relatively low population density, with much of its land area covered by forests, mountains, and fjords. Despite its small size, Norway is known for its rich cultural heritage, strong economy, and stunning natural beauty, which attracts millions of visitors every year. This Nordic country is also known for its winter sports, such as skiing and snowboarding, and is a popular destination for outdoor enthusiasts.

Norway has a long history of invention and is home to numerous more top-tier tech firms and research facilities, such as; Kongsberg Gruppen, Telenor, Atea, Evry and Gjensidige Forsikring.

Due to the country's high latitude, there are large seasonal variations in daylight. From late May to late July, the sun never completely descends beneath the horizon. Which attracts many tourists around the world to see the "Land of the Midnight Sun". Tourists mainly visit Sognefjord, Norway's Largest Fjord, Pulpit Rock, one of the most photographed sites in Norway and of course the capital; Oslo.

Oslo is considered the business center of Norway. It is the country's largest city and the capital of Norway. The city is home to many of Norway's largest and most important companies, as well as several international organizations and research institutions. Additionally, the city is a popular tourist destination, known for its scenic location on the Oslo Fjord, its many museums and cultural attractions, and its vibrant nightlife and dining scene. Some of the most popular museums in Oslo are The Norwegian Museum of Cultural History, The Nobel Peace Center, The National Museum of Art, Architecture, and Design, The Munch Museum and The Vigeland Museum.

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

Upcoming Trainings

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

Prerequisites

Outline

Upcoming Trainings