What You Missed at CloudWorld 2024 & Leveraging AI
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.
Exadata 11M New Features and Platinum MAA Case Study
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
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.
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)
Building a Card Viewer App with Oracle APEX and API Integration
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.
Beyond Simple RAG: Combining Advanced Techniques for Superior Results
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.
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
Oracle Generative AI & Vector Database with Retrieval Augmented Generation (RAG)
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.
How To Estimate SQL Run Times Without Application Code Modifications
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!
Liquibase With Oracle – Automating Your Schema Management
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.
9:30 am MDT
