UTOUG Training Days 2025: Full Schedule

arrow_back View All Dates

9:15am MDT

Automate and Bulletproof Your Data Guard

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

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