Instructor-led Live Online Training
Highly Interactive and Immersive Classes
Clarify doubts Instantly
Course Materials
Course Recordings
Recommended for Best Learning Experience
Oracle AI Database 26ai is the next long-term release (LTS) of Oracle Database.
It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity.
It is the next-generation Artificial Intelligence (AI) native database, with AI architected into the entire data and development stack. It is designed to bring AI directly to the data, facilitating AI-powered application development and advanced analytics. It is also a converged database featuring advanced in-database AI Vector Search, support for multi-model data (relational, graph, JSON), and introduces agentic AI capabilities for creating autonomous agents.
This course covers the latest additions and improvements in Oracle Database 26ai.
It equips Oracle Database Administrators with knowledge about enhanced tools for better management, focusing on AI Vector Search, True Cache, Blockchain Tables, performance, architecture, security, and database sharding, Wide Tables, and Lock-Free Reservations and more...
Enroll today and upgrade your Oracle DBA skills to stay up to date and competitive.
This course covers all the new features for DBAs, introduced in Oracle Database 21c through Oracle Database 26ai.
It includes new features introduced in Oracle Database 21c + Oracle Database 23ai + Oracle Database 26ai
Learn all the new features in one single course and keep yourself up-to-date with Oracle Database features.
Oracle AI Vector Search
Overview of Oracle AI Vector Search
Benefits of Vector Search
VECTOR Data Type
Vector Embeddings
Vector Embedding Models
Basic Queries and Similarity Search
True Cache
Overview of True Cache
Configuring and Deploying True Cache
Monitoring True Cache
Oracle Database Sharding New Features
Overview of Oracle Database Sharding
Oracle Sharded Database Architecture
26ai New Features for Sharding
Sharding Native Replication (RAFT-based)
Directory-based Sharding
Coordinated Backup and Restore for Sharded Databases
Automatic Bulk data move on sharding key update
Split/Move of a Partition set with Bulk Data Movement
Automatic SQL Plan Management
New features in Automatic SQL Plan Management
Priority Transactions
Overview of Priority Transactions
Using Priority Transactions
Monitoring Priority Transactions
Priority Transactions Behavior
Automatic Transaction Quarantine
Overview of Automatic Transaction Quarantine
Monitoring Quarantined Transactions
Dropping Quarantined Transactions
Quarantined Transaction Escalation
Flashback Log Placement
Overview of Flashback Log
Flashback Log Parameters
Flashback Log Management
Lock Free Reservations
Comparing Locking – Optimistic, Lock Free
Lock Free Reservations
Functionality Requirements
Create, Modify, Delete reservable columns
Lock Free Reservations Journal Table
Data Dictionary Views
Wide Tables
Prior Challenges
Benefits of Wide Columns
Increase Column Limit
Performance
Improved Performance HCC
Hybrid Columnar Compression pre 26ai
Hybrid Columnar Compression in 26ai
Database Compatibility
Understand Performance Factors
Unrestricted Parallel DMLs
Overview of Parallel DMLs
Improvements in 26ai
Benefits
Unrestricted Direct Load
Direct Load pre 26ai
Improvements in 26ai
Benefits
Accelerate SecureFiles LOB Write Performance
Overview
Benefits
Fast Ingest Enhancements
Fast Ingest Overview
Using Fast Ingest
Enhancements in 26ai
Benefits
Feature for managing Fast Ingest
Blockchain Tables New Features
Blockchain Tables overview
Blockchain Table Row Versions
Blockchain Table User Chains
Blockchain Table Delegate Signer
Blockchain Table Countersignature
Database Security New Features
Overview of Database Security
PDB Hybrid Read-only mode
Read-only User and Session
New Developer Role
Simplified Schema Privileges
Data Storage Improvements
Automatic SecureFiles Shrink
Automatic Storage Compression
Time and Date Handling Changes
Enhanced Time Zone Data Upgrade
Improved SYSDATE and SYSTIMESTAMP data handling