Training Days 2025 blends three traditional conference tracks Database/DBaaS Administration, Applications & Analytics, and Developer with an Unconference Forum.
Learn how you can set up Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c new features. In addition to demonstrating how simple it is to set up Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should set up, configure, and monitor mission-critical Data Guard environments (including Active Data Guard).
Charles Kim
1:30 pm
Oracle Developer Tuning Tips
New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area. Example code will be provided, with some demonstrations.
Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering)
Gary Gordhamer
2:35 pm
Oracle Recovery Manager Best Practices
Backups are the foundation of a complete disaster recovery strategy, yet many database administrators aren't fully aware of RMAN's features and capabilities. I'll share the key skills you need to ensure you're getting the most from RMAN, optimize and tune backups, identify common mistakes DBAs make when setting up backups, and show how to verify that RMAN fully protects a database.
Sean Scott
4:00 pm
23ai New Features (& a few 19c/21c features)
This presentation looks at which 23ai new features such as SQL Domains (including Built-In Domains), Lock-free Column Reservations for speed, Sagas, New Developer Role, Explain Plan Tuning Tips from Oracle, Faster Flashback Time Travel, Property Graphs, True Cache, & JSON Relational Duality. 21c features to leverage include AutoML, Standby Result Cache, and InMemory enhancements including Base Level. 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. Many features are related to the DBA, but many focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features.
Rich Niemiec
10:40 am
What's Missing From Your RMAN Backup?
In this session, you'll delve into the practical aspects of RMAN, learning what is and isn't included in an RMAN backup, techniques for identifying and protecting all of the components critical for full database recovery, and lesser-known and understood RMAN configurations and settings that improve backup reliability and usability.
Sean Scott
2:35 pm
Oracle 23ai – new SQL Performance features
Will your upgrade to 23ai provide faster SQL? Here we will cover the features that are new to 23ai and how they will improve or maintain the SQL performance as you upgrade to the new version. We will cover the following items:
Automatic SQL Tuning Sets (ASTS)
Automatic PL/SQL to SQL Transpiler
Automatic SQL Plan Management (ASPM)
SPM add verified SQL Plan Baseline
Staging Tables
Real-Time SQL Monitoring Enhancements
Gary Gordhamer
4:00 pm
Oracle Generative AI & Vector Database with Retrieval Augmented Generation (RAG)
How to leverage AI and Machine Learning (ML) by understanding what you can do with them. Every app & product will leverage AI/ML! We'll look at algorithms & what they can do for you using the Oracle Vector Database & Vector Search. We'll look at LLMs (Large Language Models) that can be used with Oracle (like Cohere, Llama, & ChatGPT) to build a Foundation Model that drives your company to success. We'll look at algorithms in Oracle products used to leverage AI/ML. We will explore how to leverage and integrate AI into your companies tech plan for an advantage or just security. You'll see how to innovate & better understand Oracle's leading edge products leveraging the best database for AI. Not for the experts.
9:35 am
