Oracle 26ai – new SQL Performance features

Will your upgrade to 26ai provide faster SQL? Here we will cover the features that are new to 26ai 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

Oracle 26ai has several new features specifically around SQL tuning. We will cover the details behind how the automated one’s work, and for manual items examples of how to use them.

Help understand how to make upgrade to 26ai less painful from SQL performance point, and what new features to look for to make your applications run faster.

Are you ready to PDB?

Oracle AI Database 26ai requires the use of PDB multitenant. Feeling a little intimidated or unsure? In this session we will cover all the basic information you need to know to bring your skills up to speed to convert to and support multitenant architecture in a day-to-day setting. Topics will include:
- Basics: login, connections, services, open modes
- Security: local users, common users, lockdown profiles
- PDB creation
- PDB settings (INIT Params)
- PDB resource Limits (I/O, Memory, CPU)
- AWR Configurations
- PDB movement (Plug / Un-Plug, Clone, Refresh)
- PDB Backup / Recovery
Don’t wait, start using these features in Oracle 19c now!

Oracle DB Centrally Managed Users (CMU), Bringing AD into the DBA’s life

Oracle 18c introduced a new feature called Centrally Managed Users that allows you to directly integrate your database to an on-premises Active Directory server for database user management. In this presentation we will discuss some of the design considerations and options for how to rollout CMU as well as the technical requirements and process to transition from local managed to centrally managed users.

Oracle Database patching the right way (out of place)

Patching Oracle Databases has become a very routine procedure, but are you doing it the correct way? As of Oracle 19c Oracle is recommending out of place patching for reduced downtime, simplicity, and efficiency. But what is out of place patching? In this presentation we will cover the overall steps and benefits of out of place patching including the commands and tools needed. Bring your patching to the next level for Oracle Database, ASM stand alone (Oracle Restart), and Oracle Real Application Cluster (RAC). Don’t patch like it’s 1999, patch the right way.

Oracle Adaptive SQL Optimization - Why do things go so bad?

You start work Monday morning hopeful to mark a few things off your to-do list. Before you can even finish your first cup of caffeinated beverage, you’re getting pinged, and your inbox is filling with alerts. Hoping into your database monitoring tools, it’s clear that the production database is on fire. After a half hour of troubleshooting, you find that at least one query has changed execution plan, for the worse. How did this happen?
There is a good chance that Oracle’s adaptive SQL optimization features caused the query plan to change. In this session we will walk through how these features work, why they exist, and how you might be hindering them. Instead of fighting the Optimizer, we will discuss what is needed to make it successful. Covering Adaptive Query Optimization, Statistics Feedback, Adaptive Dynamic Sampling, and Adaptive Cursor Sharing.

Liquibase with Oracle – automating your schema management

Managing a modern database schema can be complex, frustrating, and possibly even dangerous. Schemas are the core to application data leading to either help or hinder an application design. Oracle integrated opensource Liquibase into SQLcl which has been shipping with Oracle 19c and SQL Developer for a long time now. Learn how to use SQLcl to: keep track of changes; manage drift in schema and database code; making reliable changes; provide consistent rollback; and more. Expand your DevOps methodology by fully automating your schema updates.

This session will cover a demonstration of how to use Liquibase to create, update, and manage the schema of your custom application. This built in opensource tool has been expanded by Oracle to make your life easier. Code examples will be provided through github.

Learn how to manage schema changes through automation. Provide a methodology to sync schemas between environments and enable easier CI / CD pipelines for application development.

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)

Oracle SQL Profiles and SQL Baselines, why do they fail?

Oracle SQL Plan stability tools include SQL Plan Management (Baselines) and SQL Profiles. These are often used to help with performance issues, but most people don’t understand how they work and why they fail. In this session we will cover the details behind how each work, what they do well, and why sometimes they fail. We will also discuss the future of new automatic and realtime SQL Plan management in Oracle 26ai.