Gary Gordhamer
Oracle ACE Director, Managing Principal Consultant, Viscosity
Actions
Gary Gordhamer has dedicated his professional career to exploring the enterprise application landscape and the digitization of business processes. Over the past three decades, he has gained extensive technical expertise in Oracle database, e-Business suite, middleware, and related technologies. His professional background encompasses a diverse range of industries, including healthcare, manufacturing, utilities, and government. Gary is an Oracle ACE Director and is a frequent presenter at Oracle Conferences. Additionally, he is the author of “Oracle Database Performance Tuning: Pocket Solution Guide Series For Upgrading Oracle Databases.”
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.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top