Loading…
or to register for this event.
Monday, March 24
 

9:30am MDT

Learn Generative AI and LLMs with OCI Generative AI Services
Monday March 24, 2025 9:30am - 10:15am MDT
Room 224
This session introduces Generative AI and Large Language Models (LLMs) to Oracle technology professionals. It covers the technical aspects of LLMs, including LLM basics, architecture, fine-tuning techniques, prompt engineering, and the fundamentals of code models. Using examples, we'll also explore OCI's Generative AI services, such as pretrained generative models, model inference, and dedicated AI clusters.

Key topics like Retrieval-Augmented Generation (RAG), vector databases, semantic search, and the LangChain framework (including prompts, models, memory, and chains) will also be discussed. Additionally, this session serves as an introduction to the Oracle Cloud Infrastructure OCI 2023 Generative AI Professional certification.

Audience members will learn:

- An introduction to Generative AI and LLMs, including LLM basics, architecture, fine-tuning techniques, prompt engineering, and code model fundamentals
- OCI Generative AI services, such as pretrained generative models, model inference, and dedicated AI clusters
- Key topics like RAG, vector databases, semantic search, and the LangChain framework
- How to prepare for the Oracle Cloud Infrastructure OCI 2023 Generative AI Professional certification exam.
Speakers
avatar for Kai Yu

Kai Yu

Principal Consultant, Independent
Kai Yu is an independent principal consultant with over 30 years of experience in the tech industry, specializing in Oracle Database, Oracle Applications, Cloud, and AI and machine learning. He previously served as a Distinguished Engineer at Dell Technologies, leading Oracle Database... Read More →
Monday March 24, 2025 9:30am - 10:15am MDT
Room 224
  Data (not database), Infrastructure (including database)

9:30am MDT

APEX Collections: What's in Your Collection?
Monday March 24, 2025 9:30am - 10:15am MDT
Room 105
In this presentation, we will cover this powerful APEX component and how it can be implemented in many areas of your applications. APEX Collections can store large amounts of data within session state, including CLOBs and BLOBs. They are a necessity when working with Interactive Grids and reducing application to database server connections.
Speakers
avatar for Marty Booth

Marty Booth

Senior DBA, Sports Medicine Research and Testing Laboratory
Marty enjoys working with data and designing database structures. An Oracle APEX enthusiast, he also has a passion for forecasting and monitoring weather conditions and playing the piano.
Monday March 24, 2025 9:30am - 10:15am MDT
Room 105
  Development

9:30am MDT

What You Missed at CloudWorld 2024 & Leveraging AI
Monday March 24, 2025 9:30am - 10:15am MDT
Room 209
A keynote by Larry Ellison highlighted why four clouds are key to Multi-Cloud Databases, while Safra Catz emphasized Oracle's commitment to customers. Andy Mendelsohn unveiled new 23ai features and AI-enhanced SQL, Juan Loaza introduced the Oracle Vector Database and the new Oracle GenDev environment for AI development, and Steve Miranda discussed over 100 AI features in Oracle Applications. My session will integrate key insights from these discussions, focusing on practical AI applications.
Speakers
avatar for Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America
Rich Niemiec is the current chief innovation officer of Viscosity North America. A world-renowned IT and data expert, he co-founded and served as CEO of TUSC, a Chicago-based systems integrator of business solutions founded in 1988. Rich is inducted into both the Chicago and E&Y National... Read More →
Monday March 24, 2025 9:30am - 10:15am MDT
Room 209
  Development, Data (not database)

9:30am MDT

From Data Silos to Unified Platforms: Leveraging Oracle Autonomous Database for Cross-Cloud and Multiplatform Integration
Monday March 24, 2025 9:30am - 10:15am MDT
Room 213
In today’s multi-cloud, multiplatform environment, a unified data platform is critical for maximizing the potential of an organization’s data assets. Oracle Autonomous Database supports this all-data strategy by seamlessly integrating with OCI, Azure, GCP, AWS, and third-party platforms like Snowflake and Databricks.

This session explores how Oracle’s advanced data platform enables seamless data integration across clouds, unifying structured and unstructured data into a cohesive system. Highlights include the latest enhancements for managing unstructured data, such as full-text indexing and semantic vector search, along with automation tools for efficient metadata integration.

Learn how multiple Autonomous Databases can operate as a single, unified platform, delivering high-performance analytics and insights regardless of data location. Featuring real-world demonstrations, this session provides actionable strategies to leverage Oracle’s data platform for driving value across all data sources and environments.
Speakers
avatar for Alexey Filanovskiy

Alexey Filanovskiy

Senior Prinicipal Product Manager, Oracle
Alexey has more than 16 years of experience in data warehousing and data lakes, including 12 years at Oracle. He began as a data warehouse developer, working with technologies like Oracle Exadata, Teradata, and Apache Hadoop. In 2012, he became a sales consultant at Oracle, promoting... Read More →
Monday March 24, 2025 9:30am - 10:15am MDT
Room 213
  Infrastructure (including database), Data (not database)

9:30am MDT

Hard Road to Hardening: CIS Benchmarks and Linux Security for Beginners
Monday March 24, 2025 9:30am - 10:15am MDT
Room 220
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
avatar for Martin Klier

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

The Path to Multicloud for Oracle DBAs
Monday March 24, 2025 10:30am - 11:15am MDT
Room 224
This session explores how Oracle DBAs can transition to a multicloud environment by extending core DBA tasks such as server setup, database creation and configuration, user management, access control, backups, and performance tuning to cloud platforms. We’ll focus on how these tasks adapt and expand in multicloud settings.
The session will also examine Oracle-Azure multicloud, along with AWS and Google Cloud offerings, exploring how these platforms support seamless database operations across providers. Practical use cases for Oracle-Azure multicloud integration will be discussed, highlighting the flexibility and performance advantages of a multicloud strategy. Attendees will gain a roadmap for building multicloud expertise, leveraging Oracle, Azure, AWS, and Google Cloud for scalable, cross-platform database management.
Speakers
avatar for Anuj Mohan

Anuj Mohan

Principal Enterprise Architect, Big River Steel
Anuj is an Oracle ACE and a frequent speaker at major Oracle conferences, including Oracle OpenWorld, Collaborate, Great Lakes, East Coast, and local user groups. He is also a regular speaker at Northern Kentucky University (NKU). Anuj is the founder of Oracle19cSIG (Quest) and has... Read More →
Monday March 24, 2025 10:30am - 11:15am MDT
Room 224
  Beyond Oracle, Infrastructure (including database)

10:30am MDT

Security Forum for DBAs and Developer
Monday March 24, 2025 10:30am - 11:15am MDT
Room 105
Speakers
avatar for Karen Cannell

Karen Cannell

CTHO, TH Technology
Karen Cannell is the CTHO of TH Technology, a U.S.-based consulting firm specializing in Oracle technology solutions, particularly APEX. With more than 30 years of IT experience, she has served the government, engineering, healthcare, and fisheries industries. Karen is an Oracle ACE... Read More →
Monday March 24, 2025 10:30am - 11:15am MDT
Room 105
  Development, Development

10:30am MDT

The Ultimate Beginner's Guide to Database Changes Using Oracle SQLcl & Liquibase
Monday March 24, 2025 10:30am - 11:15am MDT
Room 209
Almost all developers and DBAs are familiar with Oracle's SQL Developer and SQL Command Line (SQLcl) tools—but did you know SQLcl includes an Oracle-customized version of Liquibase?
What is Liquibase, and why should you use it for schema changes? How should it fit into a developer's or DBA's daily work? Is it only required as part of a CI/CD pipeline? And how do you get started with this Oracle-specific version of Liquibase?
This session serves as the ultimate beginner's guide to managing database schema changes with SQLcl and Liquibase. It features conceptual explanations in simple, easy-to-understand terms, along with live demos.

Speakers
avatar for Simon Pane

Simon Pane

Principal Consultant, Pythian
Simon is an Oracle ACE Pro and Oracle Certified Professional with extensive experience presenting at major Oracle and PostgreSQL conferences, including Oracle CloudWorld. He has won multiple speaking and writing awards, including the UKOUG Best New Overseas Speaker in 2016. A former... Read More →
Monday March 24, 2025 10:30am - 11:15am MDT
Room 209
  Development, 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
avatar for Brandon Hawkes

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)

10:30am MDT

Case Study: Payment Processing Company Achieves 100% Uptime Migrating and Upgrading Database to Exadata
Monday March 24, 2025 10:30am - 11:15am MDT
Room 213
Learn how one of the largest payment processing companies migrated its mission-critical databases to the latest Exadata platform with zero downtime. During the migration, we upgraded databases from Oracle 12c (12.1) to Oracle Database 19c. This session will cover technical architecture details, how ultra-high availability was achieved, lessons learned, and, most importantly, how we mitigated risks related to performance.

Numerous challenges were overcome as the databases served a global financial client base. The production database migration to the Exadata environment was completed with zero downtime architecture, using a "live cutover" while continuing to process application data. The Exadata clusters consisted of two sets of ten-node RAC compute nodes across two data centers.

Technologies leveraged include:
- Datapump
- GoldenGate
- Real Application Testing
- 10-Node RAC Cluster
- Global Data Services
- 10-Node RAC Cluster Exadata replicating data to another 10-Node RAC Cluster Exadata
Speakers
avatar for Charles Kim

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 →
Monday March 24, 2025 10:30am - 11:15am MDT
Room 213
  Infrastructure (including database)

11:30am MDT

Leveraging the Vector Database & AI Panel
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 224
The Oracle AI Panel will answer your questions and discuss how AI will shape our future. We’ll cover practical uses of vector search and the vector database, along with their business impacts. Hosted by Rich, Oracle experts will share their insights on AI's possibilities, benefits, and challenges.
Speakers
avatar for Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America
Rich Niemiec is the current chief innovation officer of Viscosity North America. A world-renowned IT and data expert, he co-founded and served as CEO of TUSC, a Chicago-based systems integrator of business solutions founded in 1988. Rich is inducted into both the Chicago and E&Y National... Read More →
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 224
  Data (not database), Development

11:30am MDT

Oracle Developer Tuning Tips
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 105
Whether you're new to SQL tuning or celebrating your 10th year, this session offers valuable insights for all skill levels. We’ll begin with a quick introduction to SQL and the Oracle Optimizer, followed by specific examples and tips on various SQL tuning options and methods. The goal is to provide practical takeaways without delving too deeply into any one area. Example code and demonstrations will be included.

Learning objectives include:
- What is SQL tuning?
- Which tools should I use?
- Why Explain Plan may be misleading
- The importance of statistics and histograms
- How to use Tuning Advisor and AWR Top N SQL
- Why SQL Profiles fail
- How to create a SQL Baseline from the cursor cache
- How to create a SQL Patch
- Optimizer tuning techniques
- Why isn’t my index being used? (Index clustering)
Speakers
avatar for Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America
Gary Gordhamer has spent much of his career focusing on enterprise application landscapes and business process digitization. His technical experience spans more than 30 years with Oracle E-Business Suite, middleware, databases, and related technologies. His professional background... Read More →
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 105
  Development, Infrastructure (including database)

11:30am MDT

Streamlined Analytics: Maximizing the Oracle Database for In-Place Processing
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 213
Learn how to leverage Oracle Database's powerful features to eliminate the need for transferring data between OLTP and OLAP/DW environments for analytics and reporting. This session will explore strategic use cases of Oracle's Materialized Views, In-Memory Column Store, Result Cache, Partitioning, and more, showing how these tools can significantly reduce data movement. The focus will be on the key benefits of in-place data processing, including minimized network traffic, reduced processing demands, and lower data redundancy. We will discuss how using these Oracle Database features not only streamlines analytics but also boosts efficiency and data integrity, enabling more agile business practices. Discover how to transform your data ecosystem into a more efficient, integrated environment that cuts costs, reduces complexity, and enhances analytical performance.
Speakers
avatar for Franky Weber Faust

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 →
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 213
  Infrastructure (including database), Development

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
avatar for Valli Ramanathan

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

Can Oracle DBAs/Developers Tune Queries in PostgreSQL?
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 224
Query tuning is essential for peak performance in any database. However, if you're Oracle-focused and suddenly tasked with tuning PostgreSQL queries, the challenge can seem daunting. Many developers and DBAs struggle to pinpoint the root cause of performance issues and often spend too much time trying to resolve them.

In this presentation, I’ll share my proven best practices for tuning PostgreSQL queries and addressing other performance issues. By using Wait Time analysis, reviewing explain plans, and offering tips on key operations to watch out for, you'll learn how to quickly tune queries impacting performance. We’ll also cover SQL diagramming techniques to identify the best execution plan, supported by case studies demonstrating these practices.

Regardless of your database’s complexity or your skill level, this systematic approach will guide you to the right tuning path, eliminating guesswork and saving countless hours in optimizing PostgreSQL performance.
Speakers
avatar for Janis Griffin

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 →
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 224
  Beyond Oracle, Development

1:15pm MDT

Developing Your First AI Chatbot with GenAI
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 209
With the rapid growth of generative AI tools over the past two years, creating an AI chatbot has become easier than ever. This presentation explores how AI chatbots differ from rule-based and intent-based models, highlighting their benefits, effectiveness, and emerging risks. It also includes a live, step-by-step demo on developing an AI chatbot and comparing backend services such as OpenAI, Azure OpenAI, and OCI Generative AI.
Speakers
avatar for Ahmed Aboulnaga

Ahmed Aboulnaga

Director, REI Systems
Ahmed Aboulnaga specializes in technical management, architecture, and consulting, with a focus on Oracle, Java, and cloud technologies. Over the course of his 20-year career, he has delivered enterprise solutions for commercial, government, and global clients. An Oracle ACE and published... Read More →
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 209
  Development, Beyond Oracle

1:15pm MDT

Getting Started with Oracle Visual Builder - Part 1
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 105
Discover how to develop with the platform powering the next generation of Oracle Redwood Fusion Cloud Apps. Oracle Visual Builder is a visual development platform designed to simplify the creation of responsive applications using a JavaScript/HTML/REST tech stack.

This demo-focused session will explain the architecture and components of an application and guide you through the basic building blocks needed to create your own applications.
Speakers
avatar for Blaine Carter

Blaine Carter

Product Manager, Oracle
Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 105
  Development

1:15pm MDT

"Rogue One" (2024) Best Security Practices for Oracle Databases and How to Use DBSAT
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 213
This conference covers general best practices for Oracle security and explores new features in database security from versions 12c, 18c, 19c, 20c, 21c, and 23c.

I will explain the importance of protecting data, particularly sensitive information, in compliance with regulations like GDPR and others. The session will also provide a detailed overview of DBSAT, including its functionality, how to use it, and how it helps identify sensitive data within your database.

Additionally, I will cover the basics of database security, highlight key considerations, and briefly introduce DataSafe, an Oracle Cloud OCI tool based on DBSAT. This tool offers a graphical interface with enhanced capabilities.
Speakers
avatar for Roy Salazar

Roy Salazar

Senior Oracle Database Consultant, Pythian
Roy Salazar is a senior IT professional with experience working with Oracle products and technology since 1998. He spent the first six years as a consultant developer and systems analyst, followed by more than 18 years as a DBA and database consultant, working with Oracle versions... Read More →
Monday March 24, 2025 1:15pm - 2:00pm MDT
Room 213
  Infrastructure (including database)

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
avatar for Biju Thomas

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

Beyond Simple RAG: Combining Advanced Techniques for Superior Results
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 224
RAG, or Retrieval-Augmented Generation, is often seen as a way to enhance language models with extra information. But there's far more potential here than simply adding data. This presentation will guide you in transforming a basic RAG setup into something exceptional.

We'll start by exploring the value of RAG, its limitations, and why just attaching information won't cut it. From there, I'll demonstrate advanced techniques that each add value but, when combined, create a truly powerful RAG app. Through live demonstrations in a working application, you'll see these methods in action. Join us to discover the strategies that will take your RAG app from OK to outstanding.
Speakers
avatar for Craig Shallahamer

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 →
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 224
  Data (not 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
avatar for Alan Quigley

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

2:15pm MDT

Getting Started with Oracle Visual Builder - Part 2
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 105
Discover how to develop with the platform powering the next generation of Oracle Redwood Fusion Cloud Apps. Oracle Visual Builder is a visual development platform designed to simplify the creation of responsive applications using a JavaScript/HTML/REST tech stack.

This demo-focused session will explain the architecture and components of an application and guide you through the basic building blocks needed to create your own applications.
Speakers
avatar for Blaine Carter

Blaine Carter

Product Manager, Oracle
Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 105
  Development

2:15pm MDT

PLSQL Hidden Features for Devs & DBAs
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 209
"Every problem is a database problem until the DBA proves otherwise."
Learn how to use PL/SQL's lesser-known or rarely used features to understand, debug, trace, log, document, and speed up your code. Discover how DBAs can guide and assist developers in mastering these techniques.
Speakers
avatar for Matheus Boesing

Matheus Boesing

Database Consultant, Aggrandize
A frequent speaker in the Oracle community across Latin America and Europe, Matheus is a computer scientist from PUCRS with 15 years of experience as an Oracle DBA. He is an Oracle Instructor and serves as a professor for the databases in cloud postgraduate program in Brazil. Matheus... Read More →
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 209
  Development, Infrastructure (including database)

2:15pm MDT

Hands-On With the New Oracle Multi-Cloud Services
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 213
Oracle now supports Oracle Database on Azure, Google Cloud, and AWS. What do these services look like, and how do they interact with other cloud services? What’s the difference between provisioning through a third-party cloud versus using Oracle Cloud Infrastructure (OCI) directly? This demo-heavy session will provide critical details and show live implementation steps in Google Cloud. Learn how to plan and provision Oracle Databases and APEX environments through these new services.
Speakers
avatar for Simon Pane

Simon Pane

Principal Consultant, Pythian
Simon is an Oracle ACE Pro and Oracle Certified Professional with extensive experience presenting at major Oracle and PostgreSQL conferences, including Oracle CloudWorld. He has won multiple speaking and writing awards, including the UKOUG Best New Overseas Speaker in 2016. A former... Read More →
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 213
  Infrastructure (including database), Beyond Oracle

3:15pm MDT

A Fishy Business, Secured: A Real Implementation of RAS in APEX
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 209
"How much time and resources could you save by implementing security rules just once?

Learn about the challenges faced and lessons learned from a real-world implementation of Real Application Security (RAS) in APEX at a large, multi-government fisheries agency. While RAS often gets a bad rap for being too complex or tricky, it effectively addressed the costly problem of enforcing complex security rules across multiple schemas, roles, applications, and connection methods.

In this session, we’ll share our experience with a complex instance involving hundreds of end users, each governed by intricate rules and access rights. You’ll learn how to:
- Deploy RAS security policies to restrict access to sensitive data
- Differentiate users connecting indirectly via APEX or directly via SQLcl or SQL Developer
- Properly enable RAS in APEX

Join us to explore whether RAS is the right solution to secure your business."
Speakers
avatar for Karen Cannell

Karen Cannell

CTHO, TH Technology
Karen Cannell is the CTHO of TH Technology, a U.S.-based consulting firm specializing in Oracle technology solutions, particularly APEX. With more than 30 years of IT experience, she has served the government, engineering, healthcare, and fisheries industries. Karen is an Oracle ACE... Read More →
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 209
  Development, Infrastructure (including database)

3:15pm MDT

Tapping Oracle AI Services Using A Visual Builder Front End
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 105
If you’ve thought that calling Oracle AI services from a custom application is difficult and complicated, come to this session to learn the real story. It turns out that the APIs offered by Oracle AI services make it easy to tap into their rich features. This session will showcase an example of a Visual Builder front end built to access the Oracle OCI AI Document Service and extract data from an image file. The steps demonstrated can be adapted to any front-end tool and used to leverage other Oracle AI services.
Speakers
avatar for Blaine Carter

Blaine Carter

Product Manager, Oracle
Blaine Carter is a product manager for Visual Builder and Visual Builder Studio. He enjoys discovering how things work and sharing that knowledge with others.
avatar for Peter Koletzke

Peter Koletzke

Technical Director and Principal Instructor, Independent
Peter Koletzke is an Oracle ACE Director with over 39 years of experience in the IT industry. He has presented at more than 410 Oracle technology conferences worldwide and received over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Koletzke is an Oracle Certified... Read More →
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 105
  Development

3:15pm MDT

Amazing Free Tools for Oracle DBAs
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 213
Our scripts utility belt doesn't have to cover it all! Know some outstanding free tools to manage your Oracle Database environment.  In this session we'll get in touch with some amazing free tools to check on the database performance, issues, tracing things from your database and server perspectives.
Speakers
avatar for Matheus Boesing

Matheus Boesing

Database Consultant, Aggrandize
A frequent speaker in the Oracle community across Latin America and Europe, Matheus is a computer scientist from PUCRS with 15 years of experience as an Oracle DBA. He is an Oracle Instructor and serves as a professor for the databases in cloud postgraduate program in Brazil. Matheus... Read More →
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 213
  Infrastructure (including database), 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
avatar for Alex Zaballa

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

3:15pm MDT

Take the Edge off Your Soft Skills
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 224
Like it or not, our jobs are really about helping people. This presentation focuses on developing essential "soft skills" that can transform even the most technical experts into influential team players and leaders within their organizations. Participants will learn how skills like effective communication, problem-solving, adaptability, teamwork, and customer service can enhance daily interactions, improve projects, and create lasting value. Practical examples, case studies, and role-playing scenarios will illustrate how soft skills complement technical abilities, foster collaboration, and drive career growth in our industry.
Speakers
avatar for Brandon Mason

Brandon Mason

Manager of Database Administration, America First Credit Union
Like many DBAs, Brandon graduated in human resource management and started his career in an HR office. While that work didn’t enhance his technical skills, it helped him develop the ability to work effectively with the people who manage systems. Brandon has been an Oracle DBA for... Read More →
Monday March 24, 2025 3:15pm - 4:00pm MDT
Room 224
  Professional Development
 
Tuesday, March 25
 

9:15am MDT

Introduction to GraphRAG: Enhance Generative AI Results with Graphs on Oracle Database 23ai
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 224
Knowledge graphs store complex information by capturing relationships between data entities. Data represented in a graph provides additional insights, derived from how it connects to other entities. Instead of viewing data as standalone points, a graph data model sees it as a set of connected entities. This connection enables new, deeper insights. Capturing this data provides richer context for generative AI. Retrieval Augmented Generation (RAG) can be enhanced with graph-RAG. Join us to explore graphs, graph-RAG, and the power of combining graphs and generative AI. We'll demonstrate how easy it is to implement this using Graph and Vector technologies in Oracle Database.
Speakers
avatar for Rahul Tasker

Rahul Tasker

Senior Product Manager, Oracle
Rahul is a senior product manager for Oracle Spatial and Graph. He defines product strategy and vision to drive revenue, growth, and market adoption, while also identifying technology products and features that meet customer needs.
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 224
  Data (not database), Development

9:15am MDT

A Picture is Worth 1000 Words: Master Handling Images in APEX
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 105
A picture is worth a thousand words, but how can developers effectively manage images in APEX? With so many images come just as many questions: How do you load them? Where should they be stored? What are the best practices for displaying, downloading, editing, and updating images within APEX?

This session demystifies image handling in APEX by exploring a variety of recommended approaches—both declarative and code-based—for uploading, resizing, storing, and displaying images across different use cases, including APEX forms, various report types, and other components.

Attendees will gain a comprehensive understanding of common methods for incorporating images into APEX applications, along with practical insights and the confidence to seamlessly integrate images into their own projects.
Speakers
avatar for Karen Cannell

Karen Cannell

CTHO, TH Technology
Karen Cannell is the CTHO of TH Technology, a U.S.-based consulting firm specializing in Oracle technology solutions, particularly APEX. With more than 30 years of IT experience, she has served the government, engineering, healthcare, and fisheries industries. Karen is an Oracle ACE... Read More →
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 105
  Development

9:15am MDT

Application Performance Tuning Forum
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 209
Have you ever wished you could bring together four or five experts from different disciplines in one room to hear their top tips for application performance tuning and ask them questions? Since application performance depends on the collaboration of roles like DBA, developer, designer, and architect, you'd want to hear from representatives of each. You’d also want insights into techniques applicable to various technologies, as well as those specific to one technology.

You’ve found the right session to fulfill that wish. This session combines a series of lightning talks from well-known experts with a Q&A, where you can ask questions or share a tip you’ve found useful. Check out the panelists' biographies to get a sense of their expertise.

See you there!
Speakers
avatar for Peter Koletzke

Peter Koletzke

Technical Director and Principal Instructor, Independent
Peter Koletzke is an Oracle ACE Director with over 39 years of experience in the IT industry. He has presented at more than 410 Oracle technology conferences worldwide and received over a dozen user group awards from ODTUG, NYOUG, UTOUG, and ECO/SEOUC. Koletzke is an Oracle Certified... Read More →
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 209
  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
avatar for Charles Kim

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)

9:15am MDT

Cloud Migration –Migrating Oracle Database to OCI/AWS/Azure
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 213
With the current trend being "Cloud migrations"-- understanding the steps and details of planning and designing a successful migration is highly impertive to our success. Oracle database migration to the cloud can be stressful when we have to consider multiple cloud provider. Trying to assess and evaluate multiple providers like OCI, AWS & Azure takes time and can delay the project timeline. My presentation details all the know how on the different providers and the pros and cons for the different options available when we consider cloud migration of Oracle This will be beneficial to all technical & business folks.
Learning Objectives:
1. Details on requirements to be gathered, technical steps to be planned and analyzed
2. Questions like : "Is Oracle RDS on AWS a good fit or should one go down the path of EC2 and Active database guard to set up resilience and redundancy " will be explored and analyzed.
3. Differences between the cloud providers –nuances to pay attention to help implement Oracle database migration successfully on OCI/AWS & AZURE
4. Common issues, shortcomings that need attention so as to avoid pitfalls.

What are the key steps to follow for successfully migrating oracle from on-prem to the cloud ( OCI/AWS/AZURE) Presentation will illustrate the tasks to follow while planning a migration of an Oracle database to the cloud. Based on each provider there are differences in what can and can not be done.
Questions like : "Is Oracle RDS on AWS a good fit or should one go down the path of EC2 and Active database guard to set up resilience and redundancy " will be explored and analyzed.
What are the Do's and Don’t based on specific cloud provider to ensure the migration is successful?
How do we ensure we have a cloud-based database that is performing at its optimal irrespective of the provider? Once migrated how do we ensure efficient performance.
Presentation will illustrate all the above and give pointers on important tasks to help DBAs plan and implement cloud migration successfully.
Speakers
avatar for Valli Ramanathan

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 →
Tuesday March 25, 2025 9:15am - 10:00am MDT
Room 213
  Infrastructure (including database), Development

10:15am MDT

Why Medallion Architecture Is the Best for Data Warehouses/Lakehouses
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 224
We chose a medallion architecture with bronze, silver, and gold layers for our data lakehouse design, and it has supported every use case we’ve needed perfectly. In this session, we’ll explain what medallion architecture is, how we implemented it, and how it has solved complex problems across various use cases.
Speakers
avatar for Michelle Hardwick

Michelle Hardwick

Chief Data Officer, University of California, Riverside
Michelle Hardwick is the current UTOUG president. She has presented at many Oracle and other tech events, including Oracle OpenWorld, Collaborate, and the Oracle OTN Latin America Tour.
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 224
  Data (not database), Infrastructure (including database)

10:15am MDT

Expanding Your Javascript Reach Within Interactive Grids
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 105
To fully harness the potential of working with Interactive Grids in APEX, incorporating key JavaScript objects into your development is essential. This presentation will feature coding examples to enhance Interactive Grid functionality and elevate your JavaScript skills. Examples will range from novice to intermediate levels.
Speakers
avatar for Marty Booth

Marty Booth

Senior DBA, Sports Medicine Research and Testing Laboratory
Marty enjoys working with data and designing database structures. An Oracle APEX enthusiast, he also has a passion for forecasting and monitoring weather conditions and playing the piano.
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 105
  Development

10:15am MDT

How to Get Rid of Materialized Views Using Hashing in ELT/ETL
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 209
Materialized views are a robust Oracle Database feature, but they have some drawbacks. When we refresh the data and an incremental refresh (force refresh) doesn’t work, we need to fully reload the materialized view. While it’s refreshing, the data is inaccessible to business users. If it fails, we must rerun it, leaving the data inaccessible. Sometimes, the process simply takes longer than expected.

What if we need to refresh the data several times a day? What if the materialized view sources data from OLTP tables, and we can’t create additional load on the OLTP system?

Two main aspects must be considered: the source of the materialized view and the data refresh method.
We assume a staging area exists where all necessary tables are replicated, providing near real-time data.
We plan to demonstrate how a materialized view can be refactored into a combination of a view, table, and procedure (or mapping). By using a hash function, we can update data incrementally instead of performing a full load. This approach makes the process faster and ensures business users have continuous access to the data. It also enables more frequent refreshes, even approaching real-time updates.

Additionally, if this materialized view serves as a source for third-party systems, it can include attributes for further change data capture (CDC).

This approach reduces data outage time, protects against incidents, and enables close-to-real-time data for end users.


Speakers
avatar for Konstantin Zhernevskiy

Konstantin Zhernevskiy

Senior DWH Architect, Data Intensity
Konstantin is a senior DWH architect at Data Intensity with over 20 years of experience in the Oracle technology stack. For the past 10 years, he has focused on delivering data marts, data warehouses, and analytical reporting applications. His expertise includes AI, machine learning... Read More →
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 209
  Development, Infrastructure (including database)

10:15am MDT

High Availability and Disaster Recovery Options in Oracle Cloud to Meet RPO and RTO Requirements
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 213
Oracle Gen 2 Cloud is more powerful, secure, and advanced than its Gen 1 counterpart. Available since 2019, it has seen numerous service and feature enhancements. One key area of progress is business continuity. Explore Oracle Cloud's High Availability and Disaster Recovery solutions to ensure your business meets its Recovery Point Objective (RPO) and Recovery Time Objective (RTO) requirements. We'll also discuss the benefits of the Full Stack Disaster Recovery service on OCI.
Speakers
avatar for Biju Thomas

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 →
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 213
  Infrastructure (including database), 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
avatar for Janis Griffin

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

The Best Data Modeling Tools
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 224
I recently evaluated sixteen of the leading data modeling tools and will share my findings, including the top scorers, their costs and licensing models, pros and cons, and any deal-breakers. I’ll also walk you through the 65 criteria and scoring methodology I used. We’ll take a closer look at the tool that claimed first place. I first came across this tool in 2019 when it ranked second in a similar evaluation I conducted of twelve modeling tools. Since then, it has only gotten better, saving my employers substantial amounts of money.
Speakers
avatar for Bill Coulam

Bill Coulam

Founder, dbSherpa.com & dataSherpa.blog
Bill has been designing and building large volume, custom Oracle systems since 1995 and writing and speaking at Oracle user groups since 2001. Bill serves on the board of UTOUG.
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 224
  Data (not database), Development

11:15am MDT

Oracle Generative AI & Vector Database with Retrieval Augmented Generation (RAG)
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 209
Learn how to leverage AI and machine learning (ML) by understanding their potential in your applications and products. This session will cover algorithms and their uses with Oracle’s Vector Database and Vector Search, along with Large Language Models (LLMs) like Cohere, Llama, and ChatGPT. We’ll explore how these models can help drive success through Oracle’s products and teach you how to integrate AI/ML into your company’s tech plan for innovation or security. This session is accessible for non-experts.
Speakers
avatar for Rich Niemiec

Rich Niemiec

Chief Innovation Officer, Viscosity North America
Rich Niemiec is the current chief innovation officer of Viscosity North America. A world-renowned IT and data expert, he co-founded and served as CEO of TUSC, a Chicago-based systems integrator of business solutions founded in 1988. Rich is inducted into both the Chicago and E&Y National... Read More →
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 209
  Development, Data (not database)

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
avatar for Franky Weber Faust

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)

11:15am MDT

Multitenant 12.1 to Multitenant 23ai: Technical Deep Dive
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 213
Oracle Database 23ai introduces new features for pluggable databases (PDBs), enhancing options for both cloud and on-premises environments. This session provides a deep dive into multitenant architecture, covering key concepts of container databases (CDB) and PDBs, their unique value, and how to manage shared and exclusive components. We’ll also explore methods for accessing and managing CDBs/PDBs and outline migration paths from earlier versions to 12c and 23ai.
Advanced features from Oracle 12c R2 and 23ai will be covered, including PDB relocation, lockdown profiles, memory and I/O prioritization, and snapshot carousel. New 23ai capabilities—Control PDB Open Order, Hybrid Read-Only Mode for PDBs, and Refreshable PDBs in DBCA—will be highlighted, demonstrating how Oracle Database 23ai provides greater flexibility, control, and efficiency in multitenant environments.
Speakers
avatar for Anuj Mohan

Anuj Mohan

Principal Enterprise Architect, Big River Steel
Anuj is an Oracle ACE and a frequent speaker at major Oracle conferences, including Oracle OpenWorld, Collaborate, Great Lakes, East Coast, and local user groups. He is also a regular speaker at Northern Kentucky University (NKU). Anuj is the founder of Oracle19cSIG (Quest) and has... Read More →
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 213
  Infrastructure (including database), Data (not database)

1:30pm MDT

Building a Generative AI RAG Application with Vector Search in Oracle Database 23ai
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 224
A key AI feature introduced in Oracle Database 23ai is vector search. A vector is an array of numbers representing the semantic content of data, rather than words or image pixels. Vectors enable similarity searches based on semantic content.

In this session, we'll explore the AI vector search features in Oracle 23ai, including generating, storing, indexing, and searching vectors, as well as integrating vector search with mission-critical enterprise capabilities.

Through sample code, we'll cover vector embedding generation methods for unstructured data, including using external embedding services and Oracle's native PL/SQL procedure, VECTOR_EMBEDDING(), to import ONNX embedding models.

We'll also discuss how to perform vector similarity searches and address challenges associated with managing high-dimensional data efficiently, ensuring query performance and accuracy, and creating new vector indexes for faster, more accurate similarity searches.

Finally, we'll explore how vector search enhances Generative AI and Large Language Models (LLMs), addressing the hallucination issue by augmenting prompts with private database content. Using examples, we will demonstrate building a Retrieval-Augmented Generation (RAG) application, incorporating tracking, embedding with the LangChain framework, and LLMs.
Speakers
avatar for Kai Yu

Kai Yu

Principal Consultant, Independent
Kai Yu is an independent principal consultant with over 30 years of experience in the tech industry, specializing in Oracle Database, Oracle Applications, Cloud, and AI and machine learning. He previously served as a Distinguished Engineer at Dell Technologies, leading Oracle Database... Read More →
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 224
  Data (not database), Development

1:30pm MDT

SQL Puzzles
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 209
Join me on a journey to explore the SQL challenges I’ve faced over the years. We’ll walk through real-world technical problems and write SQL together to solve them. Takeaways will include:
- A deeper understanding of core SQL concepts
- Improved query optimization skills
- Creative problem-solving (training your brain to approach data problems from different angles)
Speakers
avatar for Brandon Mason

Brandon Mason

Manager of Database Administration, America First Credit Union
Like many DBAs, Brandon graduated in human resource management and started his career in an HR office. While that work didn’t enhance his technical skills, it helped him develop the ability to work effectively with the people who manage systems. Brandon has been an Oracle DBA for... Read More →
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 209
  Development, Intrastructure (including database)

1:30pm MDT

Gateway to Hell - Network Basics for DBAs, DEVs and DevOps
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 213
New environments are increasingly built on a software-defined data center, both on-premises and in the cloud. However, more traditional approaches still require database administrators or DevOps teams to understand and manage the network stack. Knowledge of this foundational technology is more important than ever, even though, at its core, it originated in the 1980s and ’90s.

With a lighthearted approach, we’ll answer questions like:
- What’s so great about the Classless Society?
- What does a salami pizza have to do with network technology?
- If Superman likes supernetting, who handles subnetting?
- How do nuclear weapons impact network design?
- If my routes come from GPS, what do I need a router for?
- Who has DNS in their DNA?

We invite DBAs, developers, and DevOps professionals to rediscover the basics of network technology through the practical lens of experienced, hands-on database experts. This session is designed for IT professionals with limited exposure to networking who want to expand their understanding.
Speakers
avatar for Martin Klier

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 →
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 213
  Infrastructure (including database), Beyond Oracle

2:30pm MDT

Generating OAC Semantic Model Using LLMs
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 224
Large language models (LLMs) are powerful tools for gathering data across various fields, ushering in a new era of AI-driven code generation. LLMs can generate structured data formats such as XML and SQL. By training on extensive datasets of XML documents, these models learn to understand both the syntax and semantics of XML, enabling them to produce well-formed XML documents, complete existing structures, and transform XML data into other formats.

We aim to test the hypothesis that LLMs can generate an OAC Semantic Model. The creation of a Semantic Model is time-consuming and stands to benefit significantly from improvement. We are currently investigating this approach and are eager to determine its efficacy.

Our idea is to train the LLM using XML generation techniques for the OAC Semantic Model, based on ADW Schema metadata, including table definitions, foreign keys, view definitions, table statistics, table documentation, and data catalogs. We plan to begin training with simple examples of the Semantic Model and gradually increase the complexity.

To test our hypothesis, we will use several LLMs, including GPT, Gemini, LLaMA, and Perplexity. We will evaluate multiple test cases for each model, comparing the results to see if they can effectively generate the models and whether these models can be successfully uploaded into OAC.
Speakers
avatar for Konstantin Zhernevskiy

Konstantin Zhernevskiy

Senior DWH Architect, Data Intensity
Konstantin is a senior DWH architect at Data Intensity with over 20 years of experience in the Oracle technology stack. For the past 10 years, he has focused on delivering data marts, data warehouses, and analytical reporting applications. His expertise includes AI, machine learning... Read More →
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 224
  Data (not 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
avatar for Craig Shallahamer

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

2:30pm MDT

Liquibase With Oracle – Automating Your Schema Management
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 213
Managing a modern database schema can be complex, frustrating, and even risky. Schemas are at the core of application data and can either support or hinder application design. Oracle has integrated the open-source Liquibase into SQLcl, which has been included with Oracle 19c and SQL Developer for some time.

This session will teach you how to use SQLcl to track changes, manage schema and database code drift, make reliable changes, ensure consistent rollbacks, and more. Expand your DevOps methodology by fully automating schema updates.
Speakers
avatar for Gary Gordhamer

Gary Gordhamer

Managing Principal Consultant, Viscosity North America
Gary Gordhamer has spent much of his career focusing on enterprise application landscapes and business process digitization. His technical experience spans more than 30 years with Oracle E-Business Suite, middleware, databases, and related technologies. His professional background... Read More →
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Room 213
  Infrastructure (including database), Development
 
UTOUG Training Days 2025
From $50.00
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Monday, March 24
Tuesday, March 25
Room 105
Room 209
Room 213
Room 220
Room 224
  • Beyond Oracle
  • Data (not database)
  • Development
  • Infrastructure (including database)
  • Intrastructure (including database)
  • Professional Development