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

9:30am MDT

APEX Collections: What's in Your Collection?
Monday March 24, 2025 9:30am - 10:15am MDT
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

9:30am MDT

What You Missed at CloudWorld 2024 & Leveraging AI
Monday March 24, 2025 9:30am - 10:15am MDT
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

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

10:30am MDT

The Path to Multicloud for Oracle DBAs
Monday March 24, 2025 10:30am - 11:15am MDT
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

10:30am MDT

Security Forum for DBAs and Developer
Monday March 24, 2025 10:30am - 11:15am MDT
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 →
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 →
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 →
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 →
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 10:30am - 11:15am MDT
Room 105

10:30am MDT

The Ultimate Beginner's Guide to Database Changes Using Oracle SQLcl & Liquibase
Monday March 24, 2025 10:30am - 11:15am MDT
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

10:30am MDT

AD Integration Both OnPrem and in OCI
Monday March 24, 2025 10:30am - 11:15am MDT
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

10:30am MDT

Exadata 11M New Features and Platinum MAA Case Study
Monday March 24, 2025 10:30am - 11:15am MDT
Exadata 11M was announced in January 2025. Learn about its latest features and highlights, as well as how one of the largest payment processing companies migrated its mission-critical databases to Exadata with zero downtime. During the migration, databases were upgraded from Oracle 12c (12.1) to Oracle Database 19c. This discussion will cover the technical architecture, how Platinum MAA was achieved, and, most importantly, how performance risks were mitigated.
The migration posed numerous challenges, as the databases supported a global financial client base. The production database migration to Exadata was completed with a zero-downtime architecture, using a "live cutover" while continuing to process application data. The Exadata clusters consisted of two sets of 10-node RAC compute nodes across two data centers.
Technologies leveraged included:
  • Data Pump
  • 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

11:30am MDT

Everything You Need to Know About the Microsoft Azure and Oracle Cloud Interconnect
Monday March 24, 2025 11:30am - 12:15pm MDT
Back in 2019, Microsoft and Oracle announced a partnership enabling customers to migrate and run mission-critical enterprise workloads across Microsoft Azure and Oracle Cloud.
This extremely low-latency, private connection can distribute workload, and it opens a world of possibilities including deploying applications using the best of Oracle Cloud and Microsoft Azure. Scenarios such as running Oracle E-Business Suite in Azure with its databases operating in Oracle Cloud are now entirely possible.
Highlights on the current offerings, support and licensing models, details on performance, and a list of pitfalls are covered in this presentation. Join this presentation to learn more about what the Oracle and Microsoft Cloud partnership is all about, how it works, and what this means for cloud interoperability.
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 11:30am - 12:15pm MDT
Room 213

11:30am MDT

How Premier League is Embedding Analytics at Large Scale
Monday March 24, 2025 11:30am - 12:15pm MDT
With a live global audience of over one billion viewers and 200 million social media followers, the Premier League is continually looking for ways to engage with their fan base. Transitioning from their traditional model of selling tickets at local events to driving new fans to watch their matches globally, they use data to keep fans engaged. One of their techniques is the Premier League Milestone Insights Dashboards which celebrate player milestones, such as reaching 50, 100, and 200 Premier League career goals. Fans can learn stats like which body part is most used when they score, location of where successful penalties enter the goal mouth, and which opponent they most frequently score against. These websites host embedded Oracle Analytics content that support up to 10,000 fans to access it concurrently. With more than 5 million page views to date, this architecture highlights how Oracle technology powers large scale embedded analytics. Join me to learn about how Oracle Cloud, OCI Load balancer, Autonomous Data Warehouse and Oracle Analytics drive fan engagement.
Speakers
Monday March 24, 2025 11:30am - 12:15pm MDT
Room 209

11:30am MDT

Leveraging the Vector Database & AI Panel
Monday March 24, 2025 11:30am - 12:15pm MDT
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 →
avatar for Michelle Hardwick

Michelle Hardwick

Chief Data Officer, University of California, Riverside
Michelle Hardwick is a past UTOUG president. She has presented at many Oracle and other tech events, including Oracle OpenWorld, Collaborate, and the Oracle OTN Latin America Tour.
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 →
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 →
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 →
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 11:30am - 12:15pm MDT
Room 224

11:30am MDT

Oracle Developer Tuning Tips
Monday March 24, 2025 11:30am - 12:15pm MDT
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

11:30am MDT

ZDM -- Zero Downtime Migration of Large 100TB+ Databases
Monday March 24, 2025 11:30am - 12:15pm MDT
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

1:15pm MDT

Can Oracle DBAs/Developers Tune Queries in PostgreSQL?
Monday March 24, 2025 1:15pm - 2:00pm MDT
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

1:15pm MDT

Developing Your First AI Chatbot with GenAI
Monday March 24, 2025 1:15pm - 2:00pm MDT
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

1:15pm MDT

Getting Started with Oracle Visual Builder - Part 1
Monday March 24, 2025 1:15pm - 2:00pm MDT
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

1:15pm MDT

Discover 23ai Features for Database and Application Adminstrators
Monday March 24, 2025 1:15pm - 2:00pm MDT
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

1:15pm MDT

Hard Road to Hardening: CIS Benchmarks and Linux Security for Beginners
Monday March 24, 2025 1:15pm - 2:00pm 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
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 1:15pm - 2:00pm MDT
Room 213

2:15pm MDT

Beyond Simple RAG: Combining Advanced Techniques for Superior Results
Monday March 24, 2025 2:15pm - 3:00pm MDT
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

2:15pm MDT

Building a Card Viewer App with Oracle APEX and API Integration
Monday March 24, 2025 2:15pm - 3:00pm MDT
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

2:15pm MDT

Getting Started with Oracle Visual Builder - Part 2
Monday March 24, 2025 2:15pm - 3:00pm MDT
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

2:15pm MDT

How to Get Rid of Materialized Views Using Hashing in ELT/ETL
Monday March 24, 2025 2:15pm - 3:00pm MDT
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 →
Monday March 24, 2025 2:15pm - 3:00pm MDT
Room 209

2:15pm MDT

Hands-On With the New Oracle Multi-Cloud Services
Monday March 24, 2025 2:15pm - 3:00pm MDT
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

3:15pm MDT

A Fishy Business, Secured: A Real Implementation of RAS in APEX
Monday March 24, 2025 3:15pm - 4:00pm MDT
"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

3:15pm MDT

Tapping Oracle AI Services Using A Visual Builder Front End
Monday March 24, 2025 3:15pm - 4:00pm MDT
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

3:15pm MDT

Amazing Free Tools for Oracle DBAs
Monday March 24, 2025 3:15pm - 4:00pm MDT
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

3:15pm MDT

Patch and Upgrade Your Database Like a Hero: Internals, Secrets, and More
Monday March 24, 2025 3:15pm - 4:00pm MDT
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

3:15pm MDT

Take the Edge off Your Soft Skills
Monday March 24, 2025 3:15pm - 4:00pm MDT
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
 
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
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

9:15am MDT

Application Performance Tuning Forum
Tuesday March 25, 2025 9:15am - 10:00am MDT
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 →
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 →
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 →
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 →
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 9:15am - 10:00am MDT
Room 209

9:15am MDT

The Magic of AI in APEX: How Hard Can It Be?
Tuesday March 25, 2025 9:15am - 10:00am MDT
Just how hard is it – really - to bring the magic of AI to your APEX applications? You might be surprised. The APEX team’s latest demos make AI look waaaay cool and super easy to implement. Is it really that simple? How hard can it be?

This session will answer those questions, providing essential details, prerequisites, and how-to guidance for incorporating AI into your APEX apps. We'll explore various AI options, including Generative AI, Select AI, and any additional AI options available at presentation time. Using a simple database schema as an example, we'll address such challenges as:
  • How to get started?
  • How to teach AI to understand my schema?
  • Do large language models (LLMs) recognize my domain-specific language right away?
  • What exactly is a prompt, and how to create an effective one?
  • How simple, or elaborate, does my system prompt need to be?
  • Do I need to train my own LLM to get useful results based on my data?

Join us to discover just how hard—or easy—it can be to bring the magic of AI to your APEX applications!

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

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

9:15am MDT

Cloud Migration –Migrating Oracle Database to OCI/AWS/Azure
Tuesday March 25, 2025 9:15am - 10:00am MDT
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

10:15am MDT

Why Medallion Architecture Is the Best for Data Warehouses/Lakehouses
Tuesday March 25, 2025 10:15am - 11:00am MDT
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 a past 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

10:15am MDT

Expanding Your Javascript Reach Within Interactive Grids
Tuesday March 25, 2025 10:15am - 11:00am MDT
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

10:15am MDT

PL/SQL Hidden Features for Devs & DBAs
Tuesday March 25, 2025 10:15am - 11:00am MDT
"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 →
Tuesday March 25, 2025 10:15am - 11:00am MDT
Room 209

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

10:15am MDT

Revolutionizing Query Performance with Oracle 23ai: AI-Driven Performance Optimizations in Action
Tuesday March 25, 2025 10:15am - 11:00am MDT
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

11:15am MDT

The Best Data Modeling Tools
Tuesday March 25, 2025 11:15am - 12:00pm MDT
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

11:15am MDT

Make Better Predictions With Spatial ML Algorithms on Oracle Autonomous Database Serverless Pt. 1
Tuesday March 25, 2025 11:15am - 12:00pm MDT
In this session, we will work with Oracle Machine Learning for Python (OML4Py) Spatial AI on Autonomous Database Serverless (ADB-S) to improve predictions about electric vehicle adoption. We will load and prepare data on electric vehicle registrations in California, then build models using spatial machine learning algorithms. These algorithms incorporate location-based effects, enhancing traditional machine learning with more reliable predictions.

OML4Py Spatial AI provides specialized machine learning algorithms that account for location-based influences. Using spatial algorithms can improve model quality and prediction accuracy. For example, spatial regression algorithms can enhance home value predictions by considering the influence of nearby properties. Spatial algorithms can also identify location-based patterns, such as clusters of traffic accidents. As part of OML4Py on Autonomous Database Serverless, Spatial AI enables seamless spatial ML workflows, reducing data movement to external ML engines, simplifying architecture, and accelerating time to value.

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 11:15am - 12:00pm MDT
Room 105

11:15am MDT

Oracle Generative AI & Vector Database with Retrieval Augmented Generation (RAG)
Tuesday March 25, 2025 11:15am - 12:00pm MDT
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

11:15am MDT

"Rogue One" (2024) Best Security Practices for Oracle Databases and How to Use DBSAT
Tuesday March 25, 2025 11:15am - 12:00pm MDT
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 →
Tuesday March 25, 2025 11:15am - 12:00pm MDT
Room 220

11:15am MDT

Multitenant 12.1 to Multitenant 23ai: Technical Deep Dive
Tuesday March 25, 2025 11:15am - 12:00pm MDT
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

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

1:30pm MDT

Make Better Predictions With Spatial ML Algorithms on Oracle Autonomous Database Serverless Pt. 2
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
In this session, we will work with Oracle Machine Learning for Python (OML4Py) Spatial AI on Autonomous Database Serverless (ADB-S) to improve predictions about electric vehicle adoption. We will load and prepare data on electric vehicle registrations in California, then build models using spatial machine learning algorithms. These algorithms incorporate location-based effects, enhancing traditional machine learning with more reliable predictions.

OML4Py Spatial AI provides specialized machine learning algorithms that account for location-based influences. Using spatial algorithms can improve model quality and prediction accuracy. For example, spatial regression algorithms can enhance home value predictions by considering the influence of nearby properties. Spatial algorithms can also identify location-based patterns, such as clusters of traffic accidents. As part of OML4Py on Autonomous Database Serverless, Spatial AI enables seamless spatial ML workflows, reducing data movement to external ML engines, simplifying architecture, and accelerating time to value.
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 1:30pm - 2:15pm MDT
Room 105

1:30pm MDT

SQL Puzzles
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
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

1:30pm MDT

Gateway to Hell - Network Basics for DBAs, DEVs and DevOps
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
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

1:30pm MDT

Training, Digital Adoption, and Automated Process Testing in One Solution
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Are you preparing to upgrade your Oracle platform and facing challenges with updating user instructions, ensuring smooth adoption, or equipping your workforce for success in the new environment? Or perhaps you're looking to enhance your current training materials and onboarding process for better efficiency?
Another key consideration: Who will test and validate the newly implemented processes before going live?
In this session, we will explore strategies to:
  1. Enhance User Productivity: Deliver dynamic, role-based training in multiple formats and languages to support Oracle end users effectively.
  2. Integrate In-System Guidance: Utilize an embedded virtual assistant to provide real-time, on-screen navigation and task execution support.
Optimize Documentation Workflows: Generate accurate, up-to-date process documentation efficiently to ensure consistency and compliance.
  1. Maintain Continuous Training Updates: Keep instructional materials automatically aligned with system changes to ensure users always have access to the latest guidance.
  2. Upgrade with Confidence: Implement automated process testing for reliable, repeatable, and high-quality validation, accelerating deployment timelines.
Join us to discover how intelligent automation and guided learning can streamline Oracle upgrades, empower users, and drive operational excellence.
Speakers
avatar for Christine Eltz

Christine Eltz

ClickLearn
Christine Eltz is a ClickLearn customer solutions architect. She combines her extensive knowledge of ClickLearn with expertise in demonstrating its use across all platforms, helping customers discover how it fits into their tech stack.Whether through a private demo, an online webinar... Read More →
avatar for Mark Olesen

Mark Olesen

ClickLearn
Mark is the head of sales & partner management in ClickLearn. He has been a sales executive with 10+ years of experience in the software industry. He is driven by the passion for enabling and building close relationship with customers and partners.
Tuesday March 25, 2025 1:30pm - 2:15pm MDT
Room 220

2:30pm MDT

Generating OAC Semantic Model Using LLMs
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
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

2:30pm MDT

Fraud Detection in Financial Industry With Oracle Graph
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
Data can be analyzed to understand patterns, uncover fraud, gain product insights, and make buying and selling recommendations. A variety of activities can be accomplished simply by discerning the true story behind the data in front of us. All we need are the right tools. By plotting data as graphs and examining patterns, we can uncover valuable insights more easily. Oracle Graph Server helps achieve this by visualizing relationships between data in graph form.
Use case: Fraud prevention in financial services
In financial organizations such as banks and credit card companies, identifying fraud is one of the most critical functions. Detecting suspicious patterns in financial transactions is key. It is essential to identify indirect connections to suspicious or fraudulent accounts and recognize circular money flows, which may indicate money laundering. Additionally, managing large networks of interconnected entities is crucial for uncovering layering—hiding money flows through numerous small, indirect transactions.
Many fraud detection activities can be enhanced through graphical data visualization, which can be achieved using Oracle Graph. This presentation will explore how to leverage Oracle Graph for fraud detection and other use cases in your organization.


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 2:30pm - 3:15pm MDT
Room 105

2:30pm MDT

How To Estimate SQL Run Times Without Application Code Modifications
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
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

2:30pm MDT

Liquibase With Oracle – Automating Your Schema Management
Tuesday March 25, 2025 2:30pm - 3:15pm MDT
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
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.