Come together for insights, innovation & community.
BLUEPRINT 4D is where Oracle customers come together with the Oracle product teams and partner community to learn, share, and network. This year Viscosity will have 17 sessions presented by four of our Oracle ACES! Get the latest updates, learn about new features, see live product demos, and extend your Oracle network by connecting with other Oracle customers.
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.
ASH Incident Analysis With Interactive Network Graph
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.
Come to this open house style session where you’ll gain access to a selection of LiveLabs Workshops to solve your complex developer requirements using the Oracle Database. Topics include Autonomous Database, APEX, Machine Learning, Database 19c, and Database 21c. Each workshop environment takes between five and 15 minutes to set-up. Once set up, you’ll be able to complete this workshop outside of the session time, once the conference is over. There are five different LiveLabs session times. Pick whichever timeslot is most convenient for you!
Data as Code: Exploring Data and Database Portability
Databases are traditionally roadblocks to application development. Data refreshes are time consuming and require down time 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 complex solutions for data management. 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!
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
Oracle SQL Plan Management (SPM) Your Imperative Performance Tool
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 goto 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 an invaluable tool in your continuous goal to maintain database performance.
Inferring SQL Run Times And Analysis Using Raw ASH Data
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.
Oracle continues to add new and innovative features to every release of the database. Even though Oracle 23c is right around the corner, maybe you are curious about something that came out in 12c or even 11g. This panel will be full of experts that can provide real world experiences and results on your questions around all the database features. Topics including security, performance, reliability, scalability, data replication, and even new SQL language features. Come with your questions, get real world results.
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.
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!
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.
To the Release Update and Beyond: Everything You Didn'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 are not comprehensive and that 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.
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).
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!
Come to this open house style session where you’ll gain access to a selection of LiveLabs Workshops to solve your complex developer requirements using the Oracle Database. Topics include Autonomous Database, APEX, Machine Learning, Database 19c, and Database 21c. Each workshop environment takes between five and 15 minutes to set-up. Once set up, you’ll be able to complete this workshop outside of the session time, once the conference is over. There are five different LiveLabs session times. Pick whichever timeslot is most convenient for you!
Hybrid cloud means connecting users, on-premise systems, and other clouds to each other. In this session we will cover all the items you need to design, migrate, connect, and finally securing your cloud network. We will start with some networking basics and map them to the cloud terminology in OCI. To secure your network requires multiple levels of configuration around subnet layout, routing, and security lists. Connecting between two systems can seem as hard as connecting across countries, so troubleshooting tools are critical. Finishing up with a few examples of configurations that can be used.
2:15 pm - 3:15 pm
