UTOUG Training Days 2024

10:30 - 11:15 am PDT

Room 226 / Infrastructure

The Data Lakehouse for the Oracle Data Engineer

We have become a digital data society. We collect data at an astronomically high volume and analyze increasing amounts of data to make better decisions as quickly as changes occur. The world as we knew has already changed; cloud adoption is at its all-time high. Traditional on-premises solutions for data storage, data management, and analytics can no longer keep up with the rate of business data consumption.
The modern data architecture gives us the best-of-breed data lakes and purpose-built data stores. We can store ungodly amounts of data at a low, fractional cost. We are not restricted by siloed data and can empower power users to run analytics using their preferred visualization tool.

Come hear the buzz about the modern data platform with an emphasis on the Data Lakehouse. You will learn patterns that define a lakehouse by leveraging pipelines to build modern data-engineered platforms. Gain insights on:
• Comparison between a data warehouse, data lake, and a data lakehouse
• Comparison between a DBA, a data engineer, and a data scientist
• The future role of the data engineer
• Various types of data in a data lakehouse
• Advantages of a data lakehouse
• How and where does Oracle Cloud play in this world of data lake and data lakehouse?

Topics from OCI will be covered such as:
• Data Catalog
• Metadata harvesting
• Autonomous Data Warehouse

Charles Kim

10:30 - 11:15 am PDT

Room 105 / Development

Application Performance Tuning Forum

Have you ever wished it would be possible to get four or five experts from various disciplines together in one room so you could hear their top tips and ask them questions about application performance tuning? Of course, since application performance depends on the work of a number of roles like DBA, Developer, Designer, and Architect, you'd want to hear from representatives of each role. You would also want to hear about techniques that are applicable to all technologies as well as techniques applicable to a specific technology.
Well, you've read the right session description—this is the one you are looking for to fulfill those wishes. The session is a series of lightning-talk presentations from known experts with a Q&A session where you can ask questions as well as share a tip that you have found useful in the past. Check out the biographies for the panelists so you can get a sense of their knowledge domain.
See you there!

Gary Gordhamer

Sean Scott

11:30 am - 12:15 pm PDT

Room 229 / Professional Development

Exceptional Leadership; Be the Uncommon Leader!

This presentation will change your life. It is a non-technical, refreshing break to relax your mind after the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self-Control and Humility. The result will be the Fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine attributes of character and become an Uncommon Leader.

Rich Niemiec

11:30 am - 12:15 pm PDT

Room 226 / Infrastructure

Tools for Identifying and Diagnosing Database (And Not-The-Database) Issues

"Every problem is a database problem until the DBA proves otherwise." Plato, probably.
Whether conducting a proactive review of a database or firefighting an outage or performance issue, most of my work as a consultant revolves around a handful of open-source and Oracle-provided utilities. In this session, I'll share these tools and show how I use them to find and solve database (and non-database) problems.

The first part of the session focuses on reactive tools that will help you quickly isolate, contain, and extinguish fires. In the second, we'll dive into proactive and diagnostic solutions, demonstrating how to use them to catch and repair problematic configurations before they cause problems!

Sean Scott

2:15 - 3:00 pm PDT

Room 226 / Infrastructure

Oracle ML, ChatGPT, Cohere, & Foundation Models

Every app or product will start to leverage AI & ML (Machine Learning)! Knowing the basics of when and where to leverage these advancements may be the difference between success and failure in the future with the Vector Database. We'll look at the latest technologies and algorithms that are part of many products, but also the products used to leverage AI/ML & Chatbots (including Large Language Models - LLMs). We will explore how to leverage and integrate AI into your company’s tech plan for an advantage or just security. We'll see the state of AI & ML and how you can test and use this technology to create the future (using SQL, R, or Python). We’ll also look at the current Acceleration of Clouds with the Big Data Revolution and Internet of Things (IOT) which is driving the Cloud even faster. You'll see how to innovate better understanding of leading-edge products.

Rich Niemiec

2:15 - 3:00 pm PDT

Room 220 / Development

Deep Dive Into SQL Tuning

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking? In this session, we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer. You may not find the solution to that one nagging SQL, but we will cover how the optimizer frustrated you. Using these tools along with Oracle’s SQL Plan Management or Profiles, you may be able to achieve your goals.

Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

Gary Gordhamer

3:15 - 4:00 pm PDT

Room 229 / Data

Collaborative Problem Solving With Ai-Powered Virtual Teams

In an era defined by rapid technological advancement, the integration of artificial intelligence (AI) into our daily lives is profound and ever-growing. Envision a world where you have access to a team of expert advisors, not human colleagues in the traditional sense, but AI-powered entities capable of document analysis, risk assessment, and collaborative problem-solving. This presentation introduces the concept of creating virtual teams of AI entities that interact with a human user to address a wide array of challenges collaboratively.
The potential applications of AI-powered virtual teams are sweeping and transformative. One scenario involves financial analysis, where these virtual teams can assist in identifying high-risk areas that could potentially impact a company's stock price negatively. These teams not only identify these risk areas but also collaborate with us to develop tailored mitigating solutions. Alternatively, we enter the fantastical realm of Oz, where we collaborate with AI versions of Dorothy, the Tin Man, the Lion, and the Scarecrow to thwart the threat posed by flying monkeys. The boundaries of possibility are only constrained by our imagination.
In this presentation, we will delve into the mechanics of creating and harnessing AI-powered virtual teams. The interaction between humans and AI, as well as the AI-to-AI interactions, lies at the heart of this approach. By structuring these interactions effectively, individuals can collaborate with AI entities, embarking on exciting journeys to address a wide spectrum of problems across diverse domains.
During the session, practical demonstrations will showcase how this approach can be effectively implemented. Attendees will witness real-time interactions with AI entities, gaining valuable insights into the potential of this technology. Furthermore, attendees will gain access to a Python-based Web App, enabling them to replicate these interactions and explore the possibilities within their domains.
As we progress into an AI-driven future, the concept of collaborative problem-solving with AI-powered virtual teams is poised to reshape industries, foster innovation, and empower individuals to confront complex challenges as never before. Join us for this unique session, where we bridge the divide between imagination and reality, offering a glimpse into a future where human-AI collaboration knows no bounds. Together, we embark on a journey to unlock the full potential of AI, one interaction at a time.

Craig Shallahamer

9:15 - 10:00 am PDT

Room 226 / Infrastructure

Prepare for Oracle Database 23c

Oracle Database 23c Free Version with “App Simple” features is now available in production mode for the developer community. Developers and data engineers have access to innovative features that simplify development of modern and cloud data-driven applications. Oracle Database 23c Long-Term Support Release will soon be available in Oracle Cloud, to Engineered Systems and to on-premises customers.

This session will prepare you for the upgrade path to Oracle Database 23c as we discuss:
• Why should you consider making this upgrade strategy a part of your data strategy
• Why should you consider adopting the new features of Oracle Database 23c.

The multi-tenant option is critical to upgrading to Oracle Database 23c. We will discuss the upgrade path to Oracle Database 23c and what you can do to prepare for this journey. You’ll learn how to have an important conversation with your management on why this upgrade is critical to the organization, and most importantly, the options to reduce or eliminate your downtime.

Charles Kim

10:15 - 11:00 am PDT

Room 228 / Infrastructure

What Is Awr Trying to Tell Me?

Automatic Workload Repository or AWR is a key performance tuning tool for Oracle databases. Frequently an AWR report is seen as a one-stop shop for all database performance tuning, when really it is just one tool in the arsenal. In this session, we will cover the basic information on what an AWR report is and then dig into the details an AWR is trying to convey. Whether you are new to Oracle database performance tuning or a seasoned veteran, we will have relevant information for you.

Objectives:
• When is an AWR report useful, and when is it not
• What to look for in an AWR report
• What is the difference between database tuning and SQL tuning

Gary Gordhamer

11:30 am - 12:15 pm PDT

Room 220 / Infrastructure

To the Release Update and Beyond: Everything You Don't Know About Patching

Patching Oracle databases means more than just applying the quarterly bundled Release Updates (RU) or Monthly Recommended Patches (MRP). Many DBAs aren't aware that RU and MRP aren't comprehensive. Databases remain exposed to critical vulnerabilities and regressions without supplemental patching.
In this session, you'll learn to identify the types of patches that are never included in Oracle's patch bundles, how to search My Oracle Support for additional critical fixes, and cover Oracle's recommended best practices for patching database and Grid Infrastructure software installations. We'll also describe the patching process, how to revert to a patched database, and discuss steps for preparing and protecting systems for patching.
Oracle database administrators attending this session will gain important insights into the patching process, including:
· What's missing from Oracle's quarterly patch updates (and why it's not there)
· Where to find patches for "everything else" they need to keep the database secure and running at peak performance
· The differences between in-place and out-of-place patching, and which is best
· Changes to patches and patching introduced in Oracle Database 23c

Sean Scott

2:45 - 3:30 pm PDT

Room 229 / Professional Development

The Irreplaceable Human: Leveraging Humanity's Uniqueness

In an era where artificial intelligence (AI) is reshaping everything, understanding our humanity, the differences between AI and humanity, and then leveraging our uniqueness becomes critical.
This presentation is a journey of exploration that aims to explore human intuition, emotion, and creativity, and how AI can be integrated to improve humanity, enhance productivity, facilitate decision-making, and spur innovation.
We begin with how to enhance human intuition with AI. We will delve into how AI, with its vast data-processing capabilities, can augment human intuition, especially in complex decision-making scenarios. This section will explore real-world examples of AI's analytical prowess supporting and refining human judgment.
Next, we turn our attention to the integration of emotional intelligence in AI systems. This segment will showcase advancements in AI technologies that can recognize and respond to human emotions, despite AI itself not possessing human emotions. We will examine how this emotional acumen not only improves user interactions but also opens new vistas in personalized services and empathetic machine responses.
Lastly, we will explore AI as a catalyst for human creativity. This part will highlight how AI tools and algorithms serve not as replacements but as enhancers and partners in the creative process. From AI-assisted coding, art, and music to innovative problem-solving approaches, we will demonstrate how AI can inspire and facilitate new forms of human creativity, leading to unprecedented collaborative creations.
Demonstrations will be used throughout the presentation.
It has been coarsely stated that, AI will not replace you, but those leveraging AI will. This presentation highlights how humanity and each of us personally can leverage AI for the betterment of humanity, helping us to do something amazing each and every day.

Craig Shallahamer

Charles Kim

CEO and Co-Founder
Oracle ACE Director

Rich Niemiec

CIO
Oracle ACE Director

Sean Scott

Principal Consultant VNA
Oracle ACE Director

Gary Gordhamer

Principal Consultant
Oracle ACE Pro

Craig Shallahamer

Applied AI Scientist
Oracle ACE Director

UTOUG Training Days 2024

About The Event

Training Days 2024

Training Days 2024

The Data Lakehouse for the Oracle Data Engineer

Application Performance Tuning Forum

Exceptional Leadership; Be the Uncommon Leader!

Tools for Identifying and Diagnosing Database (And Not-The-Database) Issues

Oracle ML, ChatGPT, Cohere, & Foundation Models

Deep Dive Into SQL Tuning

Collaborative Problem Solving With Ai-Powered Virtual Teams

Prepare for Oracle Database 23c

What Is Awr Trying to Tell Me?

To the Release Update and Beyond: Everything You Don't Know About Patching

The Irreplaceable Human: Leveraging Humanity's Uniqueness

Meet the Speakers

Charles Kim

Rich Niemiec

Sean Scott

Gary Gordhamer

Craig Shallahamer

Contact