QUEST ORACLE COMMUNITY'S BLUEPRINT 4D CONFERENCE

Have you ever been asked a “top anything” question? Questions like, “Hey Craig, what is the top [insert stat here]…?” For instance, the DB Time SQL by hour, top hour with the most active session, top CPU consuming execution plan, top module for this SQL_ID, top SQL_ID when waiting on db file sequential reads, top IO activity day of the week, top hard parse hour, top hard parse day last June, top hard parse force matching signature, and the top row lock hour regardless of the date or the day. This list goes on and on. The SQL I’ll use to demonstrate how to answer all these questions is simple and only eight short lines. It aggressively uses ASH’s sample nature, SQL*Plus defines and your understanding of how Oracle works. The result is we can do deep analysis we normally would not think is possible…even with ASH. Truly, it’s the most important SQL statement I have ever written. Join me as we explore how to creatively and aggressively use raw ASH data to answer traditionally difficult but incredibly important Oracle and application performance questions.

This presentation will focus on the Oracle Database's ability to manage different types of data efficiently. We also show how Converged DB plays a part in the Modern Data Platform (Lakehouse, Data Mesh, etc.). As we move into the future, the efficiency of Oracle in using InMemory, MachineLearning, Exadata, Documents, JSON, XML...etc. will be their main strength. Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career’s future path. Fortunately, Oracle’s Converged Database strategy makes it simple to satisfy these demands.

• Learning Objective 1: Learn why converged database is the future
• Learning Objective 2: Learn advantages of converged database
• Learning Objective 3: Learn why in a machine learning world, converged database is paramount.

You may have heard about Autoupgrade—how it can upgrade dozens or hundreds of databases, run unattended or scheduled upgrades, identify and automatically fix problems, and automate pre- and post-upgrade steps. You may have also heard: “Autoupgrade is only for large environments” “Configuring Autoupgrade is time-consuming and challenging.” “Only a limited set of upgrade paths are supported.” “It’s hard to use and slow.” “It can’t migrate non-container databases and forces you to migrate to pluggable databases.” “It’s still experimental.” In reality, Autoupgrade simplifies and streamlines upgrades for one or dozens of databases. It’s easy to use and configure, fast and flexible. If Autoupgrade encounters a problem it can’t fix automatically, the process of identifying, fixing, and resuming an upgrade is straightforward. This session draws from dozens of real-world upgrades to introduce Autoupgrade and offers practical, tested tips and advice to accelerate and improve your next upgrade. – Why Autoupgrade is the method of choice for upgrading to 12cR2, 18c, 19c, and beyond – Planning and preparing for an Autoupgrade – Preparing a configuration for a single database in under a minute – Autoupgrade capabilities demonstrated, from simple to complex – Dealing with the unexpected, fixing issues, resuming jobs, and recovering from a failed upgrade.