Oracle Database 23ai: New Features for Administrators

• An understanding of Oracle database architecture and administration
• Experience working with Oracle 19c or 21c
• Familiarity with SQL, PL/SQL, and basic DBA tools

Audience

• Oracle database administrators
• Database architects
• Infrastructure engineers supporting Oracle environments

Oracle Database 23ai is Oracle’s next-generation database platform, offering enhanced AI integration, automation, and administration features for modern data workloads.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Oracle administrators who wish to explore and implement the latest features in Oracle Database 23ai for performance, security, and AI-powered functionality.

By the end of this training, participants will be able to:

• Understand and evaluate the major new features introduced in Oracle 23ai.
• Configure AI Vector Search and integrate AI workloads.
• Leverage enhanced automation, observability, and performance tools.
• Plan version upgrades and implement new 23ai capabilities in production.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Oracle 23ai features in test environments.
• Guided labs focused on implementation and migration planning.

Course Customization Options

• To request a customized training for this course based on your Oracle infrastructure, please contact us to arrange.

Overview of Oracle 23ai

• Oracle 23ai feature summary and vision
• Key differences from 19c and 21c
• AI integration and modern workloads

AI Vector Search and Embeddings

• AI Vector Search: architecture and use cases
• Storing and indexing vectors in Oracle 23ai
• Practical examples for search and AI inference

Automation and Observability

• New observability dashboards and telemetry
• Enhanced automation for DBA tasks
• Proactive alerting and resource monitoring

Performance and SQL Enhancements

• SQL enhancements in Oracle 23ai
• Improvements in indexing, joins, and query optimization
• Real-time statistics and improved diagnostics

Security and Compliance

• New auditing and encryption features
• Policy management enhancements
• Integration with Oracle Cloud Infrastructure (OCI) controls

Upgrade and Migration Planning

• Assessing readiness and compatibility
• Tools and best practices for upgrading
• Hybrid cloud considerations

Backup, Recovery, and Cloud Options

• Backup changes in Oracle 23ai
• Flashback and recovery enhancements
• Multicloud and autonomous database features

Summary and Next Steps