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 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