Training Days 2025 blends three traditional conference tracks Database/DBaaS Administration, Applications & Analytics, and Developer with an Unconference Forum.
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
4:00 pm
23c New Features (& a few 19c/21 features)
Rich Niemiec
2:30 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)
10:00 am
