OD-AI-NFA: Oracle AI Database New Features for Administrators

Module 1: Oracle AI Vector Search

• AI Vector Search
• Oracle AI Vector Search Benefits
• VECTOR Data Type
• Vector Embeddings
• Vector Embeddings Models
• Basic Queries and Similarity Search

Module 2: True Cache

• True Cache Overview
• Configuring and Deploying True Cache
• Configuring and Deploying True Cache: With DBCA
• Configuring and Deploying True Cache: Manually
• Configuring and Deploying True Cache: Application Services
• Configuring and Deploying True Cache: RAC Primary Database
• Configuring and Deploying True Cache: Verify Configuration
• Configuring and Deploying True Cache: Enable DML Redirection
• Managing True Cache: Monitor True Cache
• True Cache in Your Application
• Additional Information

Module 3: Database Sharding New Features

• Database Sharding – Part 1
• Database Sharding – Part 2
• Database Sharding – Part 3
• Database Sharding – Part 4
• Sharding Native Replication (RAFT-Based)
• Directory-Based Sharding
• Coordinated Backup and Restore for Sharded Database
• Automatic Bulk Data Move on Sharding Key Update
• Split/Move of a Partitionset with Bulk Data Movement

Module 4: Automatic SQL Plan Management

• Automatic SQL Plan Management

Module 5: Automatic Transaction Rollback

• Automatic Transaction Rollback – Part 1
• Automatic Transaction Rollback – Part 2

Practices

• Practice 2-2: Automatic Transaction Rollback Overview
• Practice 2-2: Automatic Transaction Rollback

Module 6: Automatic Transaction Quarantine

• Automatic Transaction Quarantine – Part 1
• Automatic Transaction Quarantine – Part 2

Module 7: Flashback Log Placement

• Flashback Log Placement

Practices

• Practice 2-4: Flashback Log Placement Overview
• Practice 2-4: Flashback Log Placement

Module 8: Simplified Database Migration Across Platforms Using RMAN

• Methods of Transporting Tablespaces and PDBs
• Recovery Catalog Methods for PDBs
• Transport a PDB Using a Pre-existing Backup
• Recovery Catalog Methods for Tablespaces
• Transport a Tablespace and PDB Using Multiple Incremental Backups
• Methods of Transporting in NOCATALOG Mode
• Transport a PDB Using Multiple Incremental Backups NOCATALOG
• NOCATALOG Mode for Tablespaces
• Transport a Tablespace Using Multiple Incremental Backups NOCATALOG
• Methods of Transporting Over Network Link and Quickly Transport a PDB
• Transporting PDBs by Restoring Backups Incrementally Over the Network
• Methods of Transporting Over Network Link and Quickly Transport a Tablespace
• Transporting Tablespaces by Restoring Backups Incrementally Over the Network

Module 9: Lock Free Reservations

• Lock Free Reservations – Part 1
• Lock Free Reservations – Part 2

Practices

• Practice 3-2: Lock Free Reservation Overview
• Practice 3-2: Lock Free Reservation

Module 10: Wide Tables

• Wide Tables

Practices

• Practice 3-4: Wide Columns Overview
• Practice 3-4: Wide Columns

Module 11: Improved Performance HCC

• Improved Performance HCC

Module 12: Unrestricted Parallel DMLs

• Unrestricted Parallel DMLs

Practices

• Practice 3-3: Unrestricted Parallel DMLs Overview
• Practice 3-3: Unrestricted Parallel DMLs

Module 13: Unrestricted DML After Direct Load

• Unrestricted DML After Direct Load

Module 14: Accelerate SecureFiles LOB Write Performance

• Accelerate SecureFiles LOB Write Performance

Module 15: Fast Ingest

• Fast Ingest – Part 1
• Fast Ingest – Part 2

Module 16: Blockchain Tables New Features

• Blockchain Table Overview
• Blockchain Table Row Versions and User Chains
• Blockchain Table Delegate Signer and Countersignature

Practices

• Practice 1-1: Blockchain Table Overview
• Practice 1-1: Blockchain Table

Module 17: Database Security New Features

• Database Security – Part 1
• Database Security – Part 2
• Database Security – Part 3
• Pluggable Database Hybrid Read-Only Mode
• Read-Only User and Session
• New Developer Role
• Simplified Schema Privileges
• Audit Object Actions at the Column Level
• Controlling Authorizations for Unified Auditing
• Integration with Microsoft Azure Active Directory with Additional Oracle Database Environments

Practices

• Practice 7-1: Using PDB Hybrid Read-Only Mode
• Practice 7-2: Using Read-Only Users and Sessions
• Practice 7-3: Using db_developer_role to Manage Application Schemas
• Practice 7-4: Using Schema-Level Privileges to Perform and Manage Application Operations
• Practice 7-5: Creating and Using Unified Audit Policies at Column Level

Module 18: Data Storage Improvements

• Automatic SecureFiles Shrink and Storage Compression

Module 19: Time and Date Handling Changes

• Time and Date Handling Changes