UTOUG Training Days 2025: Full Schedule

9:30am MDT

Hard Road to Hardening: CIS Benchmarks and Linux Security for Beginners

Monday March 24, 2025 9:30am - 10:15am MDT

This project report covers our experience hardening systems running Linux as the backend for Oracle Database. As long-time Linux and Oracle professionals, we unexpectedly found ourselves tasked with a nontechnical yet highly complex issue. Despite our experience, we were overwhelmed by the vast amount of knowledge we needed to acquire in the security domain.

This is a story of criminal threats, self-imposed limitations, calculated risks, hidden dangers, familiar habits, external pressures, real-world challenges, practical applications, performance, overhead, tools, and the key question: Who will maintain this?

Join us as we share our journey toward enhanced security—and the trade-offs that came with it.

Speakers

Martin Klier

Senior DB Expert, Performing Databases GmbH

Martin Klier has nearly 20 years of experience in Oracle database administration, focusing on high-availability solutions with RAC and Data Guard. In recent years, he has specialized in performance analysis and tuning of complex systems.Klier is an Oracle ACE Director and frequently... Read More →

Monday March 24, 2025 9:30am - 10:15am MDT
Room 220

Infrastructure (including database)

10:30am MDT

AD Integration Both OnPrem and in OCI

Monday March 24, 2025 10:30am - 11:15am MDT

Room 220

At Idaho National Laboratory (INL), we have successfully integrated Active Directory (AD) with both our on-premises Oracle databases and Oracle Cloud Infrastructure (OCI) Autonomous Databases. This presentation will outline the steps and processes involved in this integration. We will explain how we architected our AD groups, users, and service accounts for seamless integration with on-premises Oracle database servers. Additionally, we will discuss the procedures for connecting AD with OCI Autonomous Databases, highlighting the architectural similarities and differences between on-premises and OCI environments.

Speakers

Brandon Hawkes

Sr. DevSecOps Engineer, Idaho National Laboratory

Brandon Hawkes has more than 10 years of experience in business intelligence, database administration, and DevOps automation for multiple multinational companies and the Idaho National Laboratory. He holds a master's degree in data science and a bachelor's degree in financial economics... Read More →

Monday March 24, 2025 10:30am - 11:15am MDT
Room 220

Infrastructure (including database)

11:30am MDT

ZDM -- Zero Downtime Migration of Large 100TB+ Databases

Monday March 24, 2025 11:30am - 12:15pm MDT

Room 220

What are some methods that can guarantee a no downtime migration of 100T database? With the increase in demand for 24x7 availability, upgrades and migrations are becoming a challenge. We need fool proof migrations /upgrades while ensuring no downtime. This is challenging enough without adding the size of the database in question to be several terabytes. We will explore some options to successfully migrate large databases with zero downtime. Detailing the methods and illustration of the requirements to help audience understand options available to reproduce the migrations in their client space.
Presentation Objective 1: •Illustrate client requirements that are hard to accomplish and ways to use technology to successfully accomplish a zero downtime 100T DB migration.
Presentation Objective 2: •Detail technical solution that can be used by DBAs in the conference. Valid solutions illustrated for audience benefit.
Presentation Objective 3: •Technically strong solution explained. These can be easily implemented by all in their client space to accomplish successful 100T + DB migrations.
Presentation Objective 4: •As DBAs we are constantly challenged to improve our techniques for upgrades and migration and achieve zero downtime feats. This presentation will be beneficial to all who technical folks and can be taken back to their client space,. Customer case study included

Speakers

Valli Ramanathan

Sr Manager Engineering, Freddie Mac

Valli Ramanathan is an Oracle ACE Associate and Oracle Certified Cloud Architect Professional with over 20 years of experience in managing teams and designing complex database solutions. She has led large DBA teams (local and offshore) to implement innovative, cost-effective solutions... Read More →

Monday March 24, 2025 11:30am - 12:15pm MDT
Room 220

Infrastructure (including database), Development

1:15pm MDT

Discover 23ai Features for Database and Application Adminstrators

Monday March 24, 2025 1:15pm - 2:00pm MDT

Room 220

Oracle Database 23ai introduces over 300 new features compared to 21c, which was an interim release and received less attention. This session will focus on the new features in 23ai that are relevant to DBAs and not available in 19c. We will cover each feature and its benefits for your application, business, or database management. The best way to explore the range of features in 23ai is through hands-on experience, and Oracle has simplified access to its powerful converged database. Discover the various options available to developers and database administrators for exploring Oracle Database 23ai.

Speakers

Biju Thomas

SVP of Digital Transformation, Data Intensity

Biju Thomas is an OCI technical solution expert and leads the Digital Transformation practice at Data Intensity. He has been recognized as an Oracle ACE Director since 2015 for his expertise and contributions to the Oracle community. Biju started as a developer, has extensive experience... Read More →

Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 220

Infrastructure (including database), Development

2:15pm MDT

Building a Card Viewer App with Oracle APEX and API Integration

Monday March 24, 2025 2:15pm - 3:00pm MDT

Room 220

In this presentation, we will explore how to leverage Oracle APEX to build a powerful, user-friendly application that dynamically pulls and displays images using external API data. Oracle APEX’s low-code environment streamlines application development, while API integration provides access to a vast library of data and images. Learn how to set up an API connection, manage and display dynamic images, and build intuitive filters for sorting and viewing cards. By the end of the session, you’ll be equipped with the knowledge to create interactive, data-driven applications that access and display external data, enriching the user experience and expanding the capabilities of Oracle APEX.

Speakers

Alan Quigley

Senior Software Architect, Viscosity North America

Alan Quigley is a senior software architect with Viscosity North America and has been an Oracle PLSQL and APEX developer for over 14 years.

Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 220

Development

3:15pm MDT

Patch and Upgrade Your Database Like a Hero: Internals, Secrets, and More

Monday March 24, 2025 3:15pm - 4:00pm MDT

Room 220

Oracle Database 23ai is a game-changer for patching and upgrading. The new Real Application Cluster (RAC) features enable synchronization of patches between nodes, while the deferred patching feature expands the range of patches that can be applied in a RAC rolling manner. Additionally, new features make data patches more resilient.

Speakers

Alex Zaballa

Distinguished Product Manager, Oracle

Alex Zaballa is an Oracle Database distinguished product manager on the Database Upgrade, Migrations, and Patching team at Oracle. Based in Dallas, he has over 24 years of experience in information technology, focusing on Oracle Database. Alex holds the OCM (Oracle Certified Master... Read More →

Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 220

Infrastructure (including database), Development

9:15am MDT

Automate and Bulletproof Your Data Guard

Tuesday March 25, 2025 9:15am - 10:00am MDT

Room 220

Learn how to set up Data Guard using best practices. This session begins with a brief history of Data Guard and how it evolved into its current form. We will then explore new features in Oracle Data Guard 12c Release 2, 18c, and 19c.

In addition to demonstrating how easy it is to set up Data Guard, this session will cover fundamental best practices and reference architectures that DBAs must know to protect their Oracle ecosystem. The author of the *Oracle Data Guard Handbook* will show how DBAs should set up, configure, and monitor mission-critical Data Guard environments, including Active Data Guard.

Come see Data Guard best practices in action. The session will focus on:
- Building the physical standby
- Monitoring and maintaining the physical standby
- Configuring Data Guard Broker
- Performing backup and recovery with RMAN
- Setting archive retention
- Switchover with refreshable PDBs
- Subset standbys with PDBs

Attendees will receive access to all scripts needed to automate the Data Guard configuration.

Speakers

Charles Kim

CEO, Viscosity North America

Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, and certified in Exadata, Oracle Linux, Oracle Cloud, and RAC. He joined the Oracle ACE Program in 2008 and became an Oracle ACE Director in 2009. Kim also became a VMware vExpert in 2013. He specializes... Read More →

Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 220

Infrastructure (including database)

10:15am MDT

Revolutionizing Query Performance with Oracle 23ai: AI-Driven Performance Optimizations in Action

Tuesday March 25, 2025 10:15am - 11:00am MDT

Room 220

Oracle 23ai revolutionizes query performance with AI-driven optimizations, including automatic indexing, adaptive execution plans, and real-time analytics. By leveraging integrated machine learning algorithms and innovations like vectorized execution, intelligent workload management, and real-time analytics, it enables organizations to process large datasets more efficiently.

This presentation will explore practical strategies for using Oracle 23ai’s intelligent features, illustrated through case studies that highlight its transformative impact on database performance.

Speakers

Janis Griffin

Senior Systems Consultant, Quest Software

Janis Griffin has more than 35 years of Oracle DBA experience, including the design, development, and implementation of critical database applications. Before joining Quest, she held DBA positions primarily in the telecom and network industries, working with real-time network routing... Read More →

Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 220

Intrastructure (including database), Development

11:15am MDT

Backup Your Database and Don't Worry About Its Recoverability, ZDLRA Gets You Covered

Tuesday March 25, 2025 11:15am - 12:00pm MDT

Room 220

Large databases are becoming increasingly common, and backing them up is always a challenge. Now, imagine how difficult it would be to recover them in the event of a disaster or media failure.

What if there was a solution that could back up databases, reduce backup size and time, validate the recoverability of the backup, and, best of all, guarantee no data loss?

In this session, we'll explore some of the benefits of Oracle's Zero Data Loss Recovery Appliance and show how it works. If your company doesn't have the budget or need for such a robust solution, don't worry—we'll also look at a DIY approach to help you manage backups effectively.

Speakers

Franky Weber Faust

Lead Database Consultant, Pythian

Franky Faust is a lead Oracle database consultant at Pythian, specializing in Oracle Exadata and high-availability technologies. He also has extensive expertise in databases such as Snowflake, MySQL, Cassandra, and SQL Server.Franky is dedicated to enhancing his skills, with a focus... Read More →

Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 220

Infrastructure (including database)

2:30pm MDT

How To Estimate SQL Run Times Without Application Code Modifications

Tuesday March 25, 2025 2:30pm - 3:15pm MDT

Room 220

Imagine knowing SQL run times without modifying your application code. That's exactly what I'll demonstrate by diving into ASH data.

Picture this: A ticket reports, "This query takes 45 seconds!" How can you verify that? Is 45 seconds typical? Has it happened before? Could it be using a suboptimal execution plan? By analyzing ASH data, we'll answer these questions and more.

In this session, I'll show you how to manually infer SQL run times from ASH data. I'll then introduce a flexible SQL script that analyzes ASH data, infers run times, and reports results—down to the execution plan level. Finally, we'll use a simple spreadsheet to review and analyze the results. Join me as we explore a hidden gem in ASH data analysis!

Speakers

Craig Shallahamer

Applied AI Scientist, OraPub / Viscosity North America

Having worked with Oracle technology since 1989, Craig Shallahamer is a leader in the fields of machine learning, artificial intelligence and Oracle database performance tuning.Craig has extensive experience in constructing and teaching predictive modeling methods, notably developing... Read More →

Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 220

Infrastructure (including database), Development

UTOUG Training Days 2025

From $50.00