Viscosity Presentations

With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported.

Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

Autonomous Database Services have expanded well beyond their original scoe of heavy analytical workloads (ADW) and hybrid transaction processing/reporting workloads (ATP) to include dedicated Cloud-based instances to eliminate contention between “noisy neighbors” in the same region and domain. 

This session demonstrates how Oracle DBAs at any skill level can immediately levarage Autonomous resources as force mulitpliers to free them from most mudane administration tasks so they can concentrate on mastering the new skills required to become an Enterprise Data Architect- the emerging post-DBA role and shift their focus towards building better enterprise systems in concert with their organization’s application developers, business analysts, and business units. 

Red Hat Enterprise Linux and Oracle Linux continues to gain market share as a reliable 7/24 mission-critical enterprise server platform. As a DBA in today’s economy, you must possess both the system and database expertise.

Learn all the best practices for Red Hat/Oracle Linux 6 and 7 required to implement Oracle Databases in bare metal servers and in virtualized infrastructures. Leveraging real-life experiences and techniques, learn from the author of the Linux

Recipes for DBAs book by APress on how-to:

1. Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments
2. Setup and leverage a local Yum Repository
3. Setup kernel and network parameters, shell limits, and file limits
4. Setup Huge Pages / Disable Transparent Huge Pages
5. Setup Jumbo Frames
6. Configuring device mapper
7. Oracle ASM Filter Driver, ASMLIB, ACFS configuration
8. Setup correct partition alignment

The database administration role as we knew it is dead. DBAs who have been around for decades have become irrelevant in this data driven economy. Developers want autonomous management and executive leaders want to cut costs anyway they can. Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever changing dynamic technology driven world. Learn what future skills you need to possess and how you can stay on top of the demand.

Discussions will include how technical enhancements to autonomous databases, cloud innovations and what you must learn to survive, how AI and machine learning can impact the database scene and understanding which technologies you need to learn to adapt.

Learn how you can setup Data Guard with all the best practices.  Attendees will get a brief history of Data Guard and how it became Data Guard.  Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c new features.  In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem.  The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).
Come see Data Guard best practices in action. The session concentrates on:
o Building the Physical Standby
o Monitoring and Maintaining the Physical Standby
o Configuring Data Guard Broker
o Performing Backup and Recovery with RMAN
o Setting Archive Retention

o Switchover with Refreshable PDBs
o Subset Standbys with PDBs

Attendees will get access to all the scripts to automate the Data Guard configuration.

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

Learning Objective 1: This session will prepare you for the upgrade path to Oracle Database 23ai as we discuss: why should you consider making this upgrade strategy a part of your data strategy.

Learning Objective 2: Why should you consider adopting the new features of Oracle Database 23ai.

Learning Objective 3: The multi-tenant option is critical to upgrading to Oracle Database 23ai. If you have not embraced it yet, what are the things that you need to factor in as part of the upgrade.

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

Whether you belong to a large enterprise or a one-man startup, cloud based databases are now a reality or part your short term technology roadmap. Like every major initiative, having a plan and executing to perfection is key to realizing the benefits offered by the cloud adoption, the absence of which could result in unplanned and unexpected downtime for your business critical applications.

Performance incidents that are rare, random, intense, and short-lived can be challenging for Oracle Database Administrators to resolve. In such cases, an AWR report may not be helpful. Instead, using raw Active Session History (ASH) data can be an effective approach. ASH provides detailed information about database session activity, including SQL statements, resource consumption, and wait events. In this presentation, I will explain why ASH is so useful, how it works, and how we can use ASH to solve complex performance issues. With the help of four free scripts, I will guide you through a step-by-step process for analyzing performance incidents using ASH and demonstrate how to visualize the incident using an interactive network graph.

Facing the challenge of hiking in the Pacific Northwest without getting wet, I developed a high-precision, hyper-local rain forecast tool using Oracle Cloud Infrastructure and Oracle MySQL HeatWave AutoML. Based on data from any personal weather station, this AI-powered application provides accurate rain predictions directly on smartphones, enhancing outdoor experiences by eliminating the need for unnecessary rain gear. Join me for this personal webinar that details my journey from the lab to the mountains.

Databases are traditionally roadblocks to application development. Data refreshes are time-consuming and require downtime and coordination across teams. Legacy environments must balance the risk of stale data against the time, effort, and inconvenience of reverting databases to baselines. Even modern agile shops struggle with this task, engineering complex processes or investing in third-party data management solutions. The primary obstacle? The way traditional databases merge software, configuration, and data, creating a bottleneck around niche skills unique to database administrators.

Organizations eliminate that dependency by shifting to a container model and delivering Data as Code. Containers separate database software from its data. Decoupling data eliminates the need for specialized skills, making it another artifact in the development lifecycle. Individuals and teams can create and refresh data on-demand, version it alongside application code, and distribute it as code or objects. Data as Code reduces uncertainty introduced by data drift and allows organizations to experience greater development velocity, consistent and reliable testing, and improved application quality!

Have you ever wanted to know the runtime of your SQL queries without having to instrument your application? If so, this presentation is for you. By analyzing raw ASH data, you can learn how to infer the runtime of your SQL queries and gain valuable insights into their performance. For example, let's say you receive a support ticket stating that a particular query takes 45 seconds to run. How can you confirm this? Is 45 seconds an unusual runtime for this query? Has this happened before? Is there a bad execution plan being used? What would be a good execution plan for this query? And where in your application does this SQL reside? All of these questions can be answered by creatively analyzing ASH data. In this presentation, I will demonstrate how to manually infer SQL run times using ASH data, as well as how to use a simple yet flexible SQL script to analyze ASH data and report the results at the execution plan level. I will also show you how to use Python to analyze runtime samples. Join me as we explore the untapped potential of ASH data analysis and learn how to get the most out of our SQL queries.

Get ready for a fun and lighthearted session as we explore the dos and don'ts of analyzing AWR reports. As someone who has pored over hundreds of reports and evaluated countless performance scenarios in Oracle, I know a thing or two about getting it right—and wrong. Sure, there are some obvious ways to mess up the analysis, but there are also some sneaky pitfalls that can trip you up and lead to misleading results. We'll take a lighthearted approach as together we explore these common mistakes and learn how to avoid them in the future. So join me for a session that's sure to be informative and entertaining!

Join us for an engaging webinar tailored specifically for Oracle DBAs passionate about performance tuning. In this unique session, we will delve into the integration of Operations Research and Oracle performance analysis.

In Part 1, we establish a quantitative relationship between database time and work, providing a solid foundation for our exploration.

Part 2 focuses on representing a production Oracle system using a response time curve, leveraging key elements from AWR reports and utilizing OraPub's online UOWTBA response time curve app.

In Part 3, our attention turns to the reflection of performance improvement strategies in an altered response time curve. By modifying a key response time metric, we will analyze the resulting numerical data changes, observe the potential changes in the response time curve, and evaluate the impact on overall system performance.

Join us as we delve into the intricate fusion of Oracle performance analysis and Operations Research, uncovering profound insights into systems performance.

APEX enables the development and delivery of applications rapidly. Taking advantage of this, we can create amazing tools for executives and data analysts.

With ATP instances, we can take advantage of their APEX built-in installation to have an autonomous and scalable environment. But there's a challenge here, and it's the built-in application server for APEX.

This session will cover the basics of creating our own application server and configuring it to connect to our ATP instance. We can have a reverse proxy to improve access/security and manage our friendly URLs.

Tuning SQL statements in Oracle is more of an art than a science.  In this session we will cover more than just the basic steps to tuning a SQL statement.  Starting with finding the SQL statement and collecting the right information.  Covering questions like “How the Optimizer works to transform SQL into an execution plan?”  “What information is an execution plan is trying to show?”  “What do data access paths mean?” Learn about the detailed steps in SQL execution plans, SQL tracing and how it compares to the information in an explain plan.  If you are new to tuning SQL in Oracle or trying to freshen up your skills, this session should have enough information for everyone.

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.

What’s the next role for the DBA as the autonomous database and Oracle enhancements free up time? This session will cover the DBA role (managing more databases with autonomous database) & the integration of AI and Machine Learning.

Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

Patching Oracle Databases has become a very routine procedure, but are you doing it the correct way?  As of Oracle 19c Oracle is recommending out of place patching for reduced downtime, simplicity, and efficiency.  But what is out of place patching?  In this presentation we will cover the overall steps and benefits of out of place patching including the commands and tools needed.  Bring your patching to the next level for Oracle Database, ASM stand alone (Oracle Restart), and Oracle Real Application Cluster (RAC).  Don’t patch like it’s 1999, patch the right way.

Join us for this popular performance-driven webinar presented at conferences around the country by Viscosity Oracle ACE Pro and Managing Principal Consultant, Gary Gordhamer.

Oracle SQL Plan Management (SPM) is often overlooked and underused. This feature started in version 11.1 and has been enhanced with each new release. As of 19c, this should be your go-to method to help maintain well-performing SQL statements.

In this session, we will cover what SPM is, how to use SPM from end to end, and how to monitor it. Once you start using SPM Baselines, you will find them to be an invaluable tool in your continuous goal to maintain database performance.

New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area. Example code will be provided, with some demonstrations. Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering).

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

Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. It ensures high availability, data protection, and disaster recovery for enterprise data.

Oracle Database Security Assessment Tool analyzes database configurations, users, security policies, and identifies where sensitive data resides to uncover security risks and improve the security posture of on-premises and cloud Oracle Databases within your organization. Learn how to implement Oracle DBSAT, a command-line tool that can help you fix immediate short-term risks and support your regulatory compliance program.

Oracle Data Safe is a tool that enables you to achieve data privacy and compliance for Oracle Databases. Use Oracle DBSAT and Data Safe together to promote security best practices on your cloud databases.

This presentation will focus on preparing for the Oracle 20c database and new features such as AutoML. This presentation will also look at a few 19c/18c new features that should be in use now. We’ll look at how Machine Learning and Autonomous Database will change the role of the future DBA.

This presentation will look at which 19c new features that should be investigated for use. This presentation will also have a few 20c new features such as AutoML. This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation – & others).

Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show example, but only explain. We will also look at the autonomous database and Oracle’s focus on the future of security.

What’s the next role for the DBA as the autonomous database and Oracle enhancements free up time? This session will cover the DBA role (managing more databases with autonomous database) & the integration of AI and Machine Learning.

Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

This session explores the pluses and minuses of the new self-driving Oracle Autonomous Database Cloud. Learn what you need to know to migrate, manage, and assess this new database and see where it fits and where it doesn’t fit. The session also explores the things you must consider and do before you move this database and gives a peek into the future and how to merge into the fast lane.

This session explores the pluses and minuses of the new self-driving Oracle Autonomous Database Cloud. Learn what you need to know to migrate, manage, and assess this new database and see where it fits and where it doesn’t fit. The session also explores the things you must consider and do before you move this database and gives a peek into the future and how to merge into the fast lane.

This presentation looks at which 23ai new features such as SQL Domains (including Built-In Domains), Lock-free Column Reservations for speed, Sagas, New Developer Role, Explain Plan Tuning Tips from Oracle, Faster Flashback Time Travel, Property Graphs, True Cache, & JSON Relational Duality. 21c features to leverage include AutoML, Standby Result Cache, and InMemory enhancements, including Base Level. 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. Many features are related to the DBA, but many focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features.

Emerging information technology trends for the cloud have the power to transform organizations. In the data management and analytics space, a key cloud service offering has arrived. Oracle Autonomous Data Warehouse (ADW) Cloud & Oracle Autonomous Transaction Processing (ATP) simplifies the provisioning, maintenance, and optimization for data warehouse workloads in the cloud, and promotes low touch for database administrators and load and pull approaches to data analytics. In this session learn about ADW/ATP provisioning and data loading, see a series of performance benchmarks, and discover the process flow of start the service, define tables, load data, and then run queries.  You'll also see the world of Player Piano materialize as the DBA's in their ghost shirts ride into the headwinds of the future.  

This presentation will look at which 23c features including True Cache, Locking Enhancements, Schema Level Privileges, Machine Learning Enhancements & more to prepare for in 23c. Many features covered will be related to the DBA, but there are also some that focus on the developer. Also, some 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. This presentation will also have a few 21c new features such as AutoML, Standby Result Cache, and InMemory enhancements including Base Level. There will be simple examples, where possible, to show the basic functionality of the new features. in. We will also look at the autonomous database and Oracle’s focus on the future of security.

What's the next role for the DBA as the autonomous database and Oracle enhancements free up time? This session will cover the DBA role (managing more databases with autonomous database) & the integration of AI and Machine Learning. Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle’s Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty.

In this presentation, learn how Oracle’s sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

We've heard about DBA 2.0 for years, yet nothing has changed how DBAs work with Oracle databases. Why? Because platforms haven't changed—until now! Cloud Native is the revolution that ushers in the age of DBA 2.0, and DBAs must prepare for an inevitable Cloud Native future!

Cloud adoption is driving standardization on cloud-native technologies, and databases—which have (so far) avoided this trend—are under mounting pressure to comply. Make no mistake: databases running on cloud-native platforms enjoy the same performance, scale, cost, and manageability benefits as any other application. Most importantly, cloud-native databases allow businesses greater ability to innovate. Enterprises that hesitate on this front will quickly yield advantages to competitors, while database administrators who overlook these technologies limit future opportunities. This session prepares you for the inevitability of cloud-native, where you'll learn:

• The key differences between legacy and cloud-native infrastructure

• How to leverage cloud-native platforms to simplify database management

• Methods for introducing and scaling adoption in an organization

• How cloud-native technologies generate strategic and business value

Databases are traditionally roadblocks to application development. Data refreshes are time-consuming and require downtime and coordination across teams. Legacy environments must balance the risk of stale data against the time, effort, and inconvenience of reverting databases to baselines. Even modern agile shops struggle with this task, engineering complex processes or investing in third-party data management solutions. The primary obstacle? The way traditional databases merge software, configuration, and data, creating a bottleneck around niche skills unique to database administrators.

Organizations eliminate that dependency by shifting to a container model and delivering Data as Code. Containers separate database software from its data. Decoupling data eliminates the need for specialized skills, making it another artifact in the development lifecycle. Individuals and teams can create and refresh data on-demand, version it alongside application code, and distribute it as code or objects. Data as Code reduces uncertainty introduced by data drift and allows organizations to experience greater development velocity, consistent and reliable testing, and improved application quality!

Linux containers are fast, efficient, and portable solutions well-known for running applications and services. These benefits apply equally to Oracle databases, yet they remain poorly understood in the database community thanks to misconceptions that lead database administrators to overlook them. Even the common explanation, describing containers as "lightweight" virtual machines, suggests they're less capable than legacy technologies. That is hardly the case! In fact, containers are equal or superior to virtual and physical hosts.

Go from "Zero to Hero" and learn how easy it is to run Oracle databases in containers, using nearly any hardware (even laptops) to build environments for performance testing, perfecting disaster recovery procedures, preparing for certifications, evaluating new features, and more. Participants will learn to build and run Oracle databases in containers and gain valuable insight into how containers work and interact with host systems.

Learning objectives for this session:
Understand how containers work and how they differ from virtual machines.
Discover the benefits of containers—including speed, portability, and reliability—unmatched by other platforms.
Learn ways to leverage containers for exam and certification study, test, practice, and validate critical procedures, accelerate development, and host production data!

Do you wish you could create your own personal database when you need to "try something out?" Or a safe environment for exploring new features, studying for certifications, or performing tests without impacting users on a shared system? What's preventing that from becoming a reality? Time, money, and resources! Setting up an Oracle database is time-consuming and requires specialized, expensive servers and storage, and justifying the additional funding for personal sandboxes is often difficult.

But the truth is, you don't need any of that! Everything you need is already at your fingertips, and in this session, I'll show you how to set up an Oracle database—for any version from 11g through 23c—in under 15 minutes! There's nothing to buy—no cloud subscription, special hardware, and no credit card required!

All of this is possible thanks to Docker. Their free software makes it easy for mere mortals to deploy and manage containers. For Oracle DBAs, Docker simplifies the task of installing and running Oracle databases. There's no need to check system prerequisites, set up X11, edit response files, call the installer, or run the Database Creation Assistant. Everything happens automatically, allowing you to focus on using your database! Creating a database takes just a few minutes (or even seconds), and even ordinary laptops can run multiple databases without suffering the performance costs typical of virtualization solutions like VirtualBox.

In this session, I'll show you how to:

• Download and install Docker on Windows and OS X
• Configure Docker on your system
• Download database images from Oracle
• Create and customize your first database
• Access the database host command line
• Connect to the database using SQL Developer and other clients
• View and manage databases via the Docker console

Linux containers are fast, flexible, portable solutions well known for running applications and services. Yet they remain less well-accepted in the database community. In this session, we shine a light on the myths surrounding the suitability of containers for running databases and demonstrate the unique advantages and capabilities containers have over physical and virtual hosts.

Go from "Zero to Hero" and learn how easy it is to run Oracle databases in containers, using nearly any hardware (even laptops) to test, practice, and perfect DR and HA procedures, prepare for certifications, and more. Participants will learn to build and run Oracle databases in containers, gaining valuable insight into how containers work and interact with host systems.

Linux containers are fast, flexible, portable solutions well known for running applications and services. Yet they remain less well-accepted in the database community. In this session, we shine a light on the myths surrounding the suitability of containers for running databases and demonstrate the unique advantages and capabilities containers have over physical and virtual hosts.

Go from "Zero to Hero" and learn how easy it is to run Oracle databases in containers, using nearly any hardware (even laptops) to test, practice, and perfect DR and HA procedures, prepare for certifications, and more. Participants will learn to build and run Oracle databases in containers, gaining valuable insight into how containers work and interact with host systems.

Cloud services offer inexpensive, limitless resources where database teams can practice and validate performance tuning, high availability, and patching. But, navigating a cloud interface to create hosts, assign disks, and configure networking is tedious and time-consuming. And you still have to install software and prepare the environment! Enter Terraform, an automation tool that streamlines and simplifies infrastructure builds. In this session, database administrators learn the basics of provisioning a database and supporting infrastructure on Oracle Cloud with Terraform. No prior experience with Terraform or Oracle Cloud is required!

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 a patched database, and discuss steps for preparing and protecting systems for patching.

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

With support ending or expiring for Oracle database versions before 19c, there’s likely an upgrade in your future. Unfortunately, the technical skills and procedures developed for earlier database versions are no longer supported. New requirements and features introduced in Oracle Database versions 19c and 23c completely change your upgrade workflows! There’s so much to consider that it’s easy to feel intimidated, even overwhelmed! AutoUpgrade mitigates the risks and fears database administrators face. It offers unparalleled simplicity and control over all phases of the upgrade process, covering every imaginable upgrade and migration scenario. AutoUpgrade’s built-in error detection, correction, and self-healing capabilities protect the database at every step, offering peace of mind in any environment—including those running RAC, Data Guard, GoldenGate, encryption, and legacy and multi-tenant architectures. In this session, I share practical advice based on my experience upgrading dozens of production databases with AutoUpgrade and working with Oracle’s AutoUpgrade team, including:
- Insights for planning and preparing for upgrades
- Demonstrations of essential features and capabilities
- Recommendations for configuring and running AutoUpgrade
- How to leverage AutoUpgrade for added visibility and trust

APEX is an amazing tool to rapidly develop and deliver applications, and most clients love to analyze their data.

What if we can merge both approaches on a single app, that is easy to use and understand to enable normal users and power users to play with their data?

This session will cover the basics of how to develop an application to serve data extracts as CSV or Excel files, store reports, manage reports, download reports, and manipulate data sets in order to fulfill clients' needs.

APEX is an amazing tool to rapidly develop and deliver applications and most client’s love to analyze their data.

What if we can merge both approaches on a single app, that is easy to use and understand to enable normal users and power users to play with their data?

This session will cover the basics on how to develop an application to serve data extracts as CSV or Excel files, store reports, manage reports, download reports and manipulate data sets in order to fulfill client’s needs.

In case you didn't know, Docker has a built-in REST API that you can use to do pretty much everything you can do from the command line interface. Just enable it and manage images, containers, volumes, network, and plenty more. Start and stop containers, check on the processor and memory usage, you can do it all.

Say you know Oracle APEX already and you're looking to automate certain actions on your Docker containers. Or perhaps you want to give Docker a familiar web interface with the tools you know best.

Turns out APEX has a built-in interface for REST APIs that you can use to interact with Docker and trigger the actions I just mentioned but also present the information it returns in a familiar way, such as Interactive Reports and Forms. You can treat the REST API as yet another data source. In a similar fashion you would interact with a database you can insert, update, delete and query.

Learn how to install Docker, switch the REST API on and connect APEX via the REST Data Sources component in this hands-on lab. You can follow along and get it working on your own computer. Leverage Docker to test new versions of Oracle products such as APEX, ORDS and the database itself.

Did you know that most big software companies authenticate their users in a similar way? It's yet another standard on the web called OAuth 2.0. You can leverage that to let your APEX users authenticate in your application using their existing credentials. Let somebody else take care of Two Factor Authentication and password recovery. No need to give your users yet another set of user and password to keep track of (and potentially forget). APEX has some support for OAuth out of the box but it has its limits. Learn how to overcome them and have a more flexible way to authenticate users.

Unless you've been living under a rock you must have heard about the wonders of Artificial Intelligence. Perhaps you've heard about it with different names: DALL-E, for image generation; ChatGPT, for… well, chatting with the closest thing to a human mind we have at the moment. They are both powered by Open AI, the company spearheading research in the Machine Learning and Artificial Intelligence fields. If you're a coder you have all that power at your disposal. Let us show you how to harness it using Python, the default language for these type of applications. Learn how to quickly set up a Python app that can talk to Open AI and how to ask things from it in a structured, code-like way using LangChain. You don't need previous knowledge on AI and it would be useful, but not necessary to know the Python language. ChatGPT doesn't know everything yet but it's getting close, and soon you'll find everyone and everything will be connected to some kind of AI. Get a jump-start here.

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.

Join us for a presentation and demo on making your interactive grids dynamic by hiding and showing necessary columns and setting adaptive titles—essential for data loaders. Discover how to customize interactive grids using JavaScript, insert your own HTML, and review available template directives for customization. Learn about substitution strings for items and columns, the escape filters available for customization, and how to search over your customized columns.

This session is ideal for developers and data managers who work with interactive grids and need to enhance their usability and customization. Whether you're looking to streamline data-loading processes or personalize grid interactions, this presentation will provide valuable insights and practical techniques.

Explore the integration of biometric security features, leveraging React Native and Oracle APEX, to fortify mobile applications. Discover the development of custom React Native components seamlessly integrating with Oracle APEX plugins, guiding users through biometric enrollment and authentication processes. Learn how this integration empowers users to leverage their device's biometrics hardware (face and fingerprint recognition) for enhanced security within Oracle APEX mobile applications.

Join us in this session where we will do a deep dive into some of the new features of this new release and look into exciting ways to use them with live examples. Some of the topics we will look into are:

Application Search
There is a new search utility, which will provide richer search capabilities.

Approvals Component
We will review this new component, added in version 22.1, where you can set up the approvals process within APEX.

Dynamic Content Region
This new region will take the place of the deprecated Dynamic content. We will review how to use it and the key improvements.

APEX is an amazing tool to rapidly develop and deliver applications, and most clients love to analyze their data.

What if we can merge both approaches on a single app, that is easy to use and understand to enable normal users and power users to play with their data?

This session will cover the basics of how to develop an application to serve data extracts as CSV or Excel files, store reports, manage reports, download reports, and manipulate data sets in order to fulfill clients' needs.

In this session, we will review and implement an authentication scheme and authorization scheme. We will work with all the different types of authentication schemas and try some of them focusing on a custom authorization scheme for the demo.

We'll delve into authorization schemas, exploring their introduction, usage for application protection, and various implementation methods. During this training, we'll examine APEX's role-based authentication and demonstrate the implementation of custom roles-based authorization.

Discover how integrating Oracle APEX with EBS and Fusion can revolutionize accounts payable in the fabric and furniture industry. In this session, we'll explore the implementation of AI and machine learning to enrich data and automate analytics, significantly improving process efficiency and data accuracy. We'll discuss the creation of a data warehouse that seamlessly integrates with EBS, and how these integrations provide a modern, effective front end for enterprise systems. This case study is crucial for anyone interested in leveraging advanced technology to optimize their business processes.

Dive into the transformative world of UI/UX design in Oracle APEX with a live demonstration of a page makeover! This session will showcase the power of template directives in dramatically enhancing the user interface and experience. Witness a real-time transformation of an APEX page, revealing the 'before' and 'after' effects of expert UI/UX techniques. Additionally, we'll unveil how AI can automate the creation of documentation and help pages through prompt engineering and AI analysis of screenshots. This session is perfect for developers and designers aiming to elevate their APEX applications with visually stunning and functionally superior UI/UX designs.

Join our session to explore how AI and OCR technologies, integrated with Oracle Apex, can transform recruitment processes. Discover innovative strategies for automating and optimizing hiring, leveraging AI for candidate profiling and matching, and utilizing OCR for efficient resume processing. Learn how these technologies reduce hiring biases and streamline recruitment, ensuring a more effective and equitable selection process. This session is a must for HR professionals, recruiters, and anyone interested in the intersection of AI, OCR, and Oracle Apex in human resource management.

APEX is an amazing tool to rapidly develop and deliver applications and most client’s love to analyze their data.

What if we can merge both approaches on a single app, that is easy to use and understand to enable normal users and power users to play with their data?

This session will cover the basics on how to develop an application to serve data extracts as CSV or Excel files, store reports, manage reports, download reports and manipulate data sets in order to fulfill client’s needs.

Discover how integrating Oracle APEX with EBS and Fusion can revolutionize accounts payable in the fabric and furniture industry. In this session, we'll explore the implementation of AI and machine learning to enrich data and automate analytics, significantly improving process efficiency and data accuracy. We'll discuss the creation of a data warehouse that seamlessly integrates with EBS, and how these integrations provide a modern, effective front end for enterprise systems. This case study is crucial for anyone interested in leveraging advanced technology to optimize their business processes.

Embark on an immersive journey into Oracle APEX REST services. Explore their core functionalities and out-of-the-box capabilities. Discover real-life use cases demonstrating their pivotal role in solving practical challenges and facilitatingseamless data integration. Dive into REST-enabled SQL and witness its transformative impact on database interactions. Uncover hidden potentials and additional capabilities within Oracle APEX REST services. Gain invaluable insights from captivating use cases, guiding developers and decision-makers toward a deeper understanding of APEX's capabilities. Whether you're a seasoned developer or newcomer, join us to explore how Oracle APEX REST services can elevate your projects. 

Oracle Database 23ai in Oracle Cloud introduces a rich array of innovative features aimed at enhancing the developer experience, simplifying application development, and empowering data professionals to work more efficiently with cutting-edge AI and ML capabilities. During our session, we will explore the top 5 AI/ML features, examining their potential applications and benefits. Additionally, we will discuss strategies and best practices for migrating your database and applications to Oracle Cloud Infrastructure (OCI), ensuring a seamless transition to leverage these advanced features and capabilities.

Learning Objective 1: Generative AI Integration: Enhances experiences by seamlessly incorporating generative AI, including vector support and large language models (LLMs).

Learning Objective 2: AI Vector Search & Low-Code Integration: Oracle Database 23ai simplifies generative AI in apps, extends to low-code platforms for ease of development.

Learning Objective 3: Natural Language to SQL Generation: Introduces the capability to query data using natural language in the Autonomous Database, combining generative Al with SQL.

Are you struggling with declining service levels and a strained IT workforce? Do you need to align your IT operations with key business goals? Join us to discover how we tackled these challenges head-on by leveraging the power of Oracle products, machine learning, and artificial intelligence.

Through near real-time AI anomaly detection analysis of Active Workload Repository data, we were able to identify and address problem trends and unusual activity across our Oracle systems, while reducing costs and increasing capacity. But that's not all - we also eliminated pesky false alerts, saving valuable employee time and resources.

Don't miss this exciting and technical deep dive into how we successfully navigated a business problem and emerged stronger than ever.

Join us on an exciting and technical journey as we use Oracle AI technology and personal weather station data to build a machine learning model that can accurately predict rain six hours into the future! Our process will involve collecting and processing time series data, including various weather variables, and using neural network algorithms to model the relationship between these variables and the likelihood of precipitation. To ensure the accuracy of our model and provide a fascinating demonstration, we will use a time-series stepping evaluation process combined with a confusion matrix. With the help of Oracle's Autonomous Database and OML4SQL, we will be able to efficiently manage and process our datasets and deploy our model in a production environment. Come join us as we harness the power of data and machine learning to bring a new level of convenience and accuracy to weather forecasting!

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.

Have you ever wanted to know the runtime of your SQL queries without having to instrument your application? If so, this presentation is for you. By analyzing raw ASH data, you can learn how to infer the runtime of your SQL queries and gain valuable insights into their performance. For example, let's say you receive a support ticket stating that a particular query takes 45 seconds to run. How can you confirm this? Is 45 seconds an unusual runtime for this query? Has this happened before? Is there a bad execution plan being used? What would be a good execution plan for this query? And where in your application does this SQL reside? All of these questions can be answered by creatively analyzing ASH data. In this presentation, I will demonstrate how to manually infer SQL run times using ASH data, as well as how to use a simple yet flexible SQL script to analyze ASH data and report the results at the execution plan level. I will also show you how to use Python to analyze runtime samples. Join me as we explore the untapped potential of ASH data analysis and learn how to get the most out of our SQL queries.

Embark on an adventure as we leverage Oracle AI technology and airport weather station data to develop and deploy a machine learning model capable of forecasting rainfall six hours into the future! Our approach encompasses the gathering and processing of time-series weather data, building and evaluating a Multi-layer Perceptron (MLP) model, and using a REST API for on-demand rain forecasts. Discover how Oracle's Cloud, Oracle MySQL HeatWave, live METAR airport weather data, and a REST API can enable you to access a localized rain prediction via your smartphone!

Learning Objective 1: Understand how to leverage Oracle AI technology and airport weather station data to develop a machine learning model for forecasting rainfall.

Learning Objective 2: Gain knowledge in gathering and processing time-series weather data, and in building and evaluating a Multi-layer Perceptron (MLP) model.

Learning Objective 3:Learn how to use a REST API to access on-demand rain forecasts and how Oracle's Cloud, Oracle MySQL HeatWave, and live METAR airport weather data contribute to providing localized rain predictions.

Discover how AI enhances human intuition, emotion, and creativity in this insightful session. We'll explore real-world examples of AI refining human judgment in complex decision-making, integrating emotional intelligence to improve user interactions, and acting as a catalyst for creativity in coding, art, music, and problem-solving. Furthermore, we'll showcase advancements in AI technologies that recognize and respond to human emotions, improving user interactions and enabling personalized services. Witness demonstrations of AI in action and learn how leveraging AI can lead to extraordinary achievements and betterment of humanity. 

Using Oracle Machine Learning, I'll show how to produce results quickly.  The first step is Algorithmic Business Thinking to see where the biggest impact will be for the business.  Next, applying the correct algorithm and understanding different settings will be important.  Then, training the model with either data that you have or data via Big Data opportunities will be key to teach a model.  After all of that, you can then test your model against data that you understand well already to see if this is the best model or if a different algorithm might be better.  Lastly, testing the model on NEW data that starts to prescribe what to do in the future.  Understanding which customers or potential customers are likely to buy.  Finding anomalies quicker to address as needed.  Knowing which product is the NEXT product a customer will buy.  Finding the attributes of great customers that you have within new customers that are opportunities & you'll know what they want to buy first or second.  This is an intermediate look at the practical application of Machine Learning. 

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI. We will explore how to leverage and integrate robotics & machine learning into your companies tech plan. We’ll show the state of robotics and how you can test and use this technology to create the future.

What is it & why IT will be the most pressing topic as it’s where the future is created. It’s what Einstein was working on when he died. More on the latest with Bohr, Susskind (lately), Schroedinger…etc. It’s where many future discoveries will come from. Is it what links us all together?

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.

Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man’s Mind to further replace man’s most basic tasks. This session will focus on ML 101 and building the future ahead.

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.

Oracle’s ability to leverage AI and Machine Learning (ML) from within Oracle Machine Learning (OML), OAC, SaaS or using their recent acquisition GUI is flexible. Oracle products will all start to leverage AI/ML! Knowing when/where to leverage these advancements may be the difference between success & failure in the future. We'll look at the latest technology and algorithms that Oracle provides as part of the product, but also the Cx products that are used to leverage AI/ML & Chatbots. We will explore how to leverage and integrate AI into your companies tech plan. We'll see the state of AI & ML and how you can test and use this technology to create the future. We’ll also look at the current Acceleration of the Cloud with the Big Data Revolution & Internet of Things (IOT) which will drive the Cloud even Faster. You'll see how to innovate better using leading edge Oracle products.

Technology continues to advance at a blistering exponential pace. This quick tip session will show you what this means to your company and your job of the future. We'll look at how close we are to the Twilight Zone and things that Rod Serling predicted for the 2000-2010 timeframe. See some of the major advances that are being driven with Machine Learning, Robotics, and increased data with Big Data & IOT.

This presentation will touch on specific algorithms inside Oracle that can help advance your company through innovation to solve Business Problems.

We will briefly examine algorithms, including: Classification, Regression, Clustering, Anomaly Detection, Time Series, Attribute Importance, Association, Feature Extraction, and Text Mining. We'll also see those that will be driven by the hardware acceleration that Oracle is causing. Oracle products are all starting to leverage AI/ML! Knowing when/where to leverage these advancements may be the difference between success & failure in the future. We'll see the state of advances in AI & ML and how you can test and use this technology to create the future. You just entered the Twilight Zone!

How to leverage AI and Machine Learning (ML) by understanding what you can do with them. Every app & product will start to leverage AI/ML! We'll look at algorithms (in English) & what they can do for you. We'll also briefly look at ChatGPT & Foundation Model basics. Not for the experts.

This presentation will cover Oracle’s ability to leverage AI and ML from within Oracle Advanced Analytics. We’ll look at the latest technology and algorithms that Oracle provides as part of the product.

Explore advanced Oracle predictive analysis in this unique class, which delves into challenging Oracle datasets, mastering difficult performance and activity data.

Gain hands-on experience with specialized supervised learning algorithms, boosting, and advanced preprocessing techniques. Secure your spot now and elevate your Machine Learning skills!