Quest Forum Digital Event 2020

The most on-premises installations of Oracle databases are not using all available Oracle database packs and features. The reasons behind that could be different but one factor is always there and it is the cost. In Oracle cloud depending on service and edition, you may have a different set of features already included in the subscription. In such a case it is worth verifying and consider the new options since you are already paying for them.  And, who knows, maybe the availability of all those features will make migration to the cloud way more attractive and be one of the main drivers for your decision to move to the Oracle cloud.

Quest Forum Digital Event 2020

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:
-Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments
-Setup and leverage a local Yum Repository
-Setup kernel and network parameters, shell limits, and file limits
-Setup Huge Pages / Disable Transparent Huge Pages
-Setup Jumbo Frames
-Configuring device mapper
-Oracle ASM Filter Driver, ASMLIB, ACFS configuration
-Setup correct partition alignment
-Create databases and ASM diskgroups in silent mode
-Automate installation of patchsets and patches
-Automate ORACLE_HOME cloning
-Create ASM instances in silent mode
-Setup rsync to synchronize file system from source and target servers
-Direct NFS
-Much more

Quest Forum Digital Event 2020

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer.  This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Quest Forum Digital Event 2020

Every database developer knows that PL/SQL functions can be used in SQL queries. However, not many are aware of the measurable cost of SQL-to-PL/SQL context switches. Even fewer can definitively answer how many times their functions will be called (depending upon the complexity of queries or portion of the query where the function is located). This presentation sheds some light on this gray area. The answer is actually very simple: the number of calls is driven by the cardinality of involved tables plus the final execution plan of your query (after all query-transformation steps). Unfortunately, GUESSING what exactly the Cost-Based Optimizer will do to your query is very difficult. This presentation will show you how to KNOW rather than guess and how to use this knowledge to optimize the performance of your database.

Quest Forum Digital Event 2020

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.

Quest Forum Digital Event 2020

Join a team of database and systems management experts from Oracle as they discuss the last new features and roadmap for Oracle Enterprise Manager, including options to deploy EM on Oracle Cloud and to manage the new Autonomous Database.  You’ll learn about the latest technology, best practices, and the future of Oracle’s flagship management offering.

Quest Forum Digital Event 2020

Database In-Memory is targeted at speeding up analytic queries by orders of magnitude over traditional row-based queries. Join Oracle Product Management in a journey that will take you through the architecture and features of Database In-Memory. Learn how to get started with Database In-Memory, how to identify which objects to populate in memory, how to identify which indexes to drop, and details on how to integrate it with other performance-enhancing features of Oracle Database. This session will also show you how Database In-Memory speeds up your analytic workload and will provide tips on how to configure Oracle Database to get the biggest performance benefits. This session will not cover what Database In-Memory is, but will instead tell you how it works and what to do to implement it.

Quest Forum Digital Event 2020

In this session learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c histograms and Oracle Database 19c histograms.

Quest Forum Digital Event 2020

Powerful Machine Learning (ML) is now available to Oracle DBAs. Over the past few years, a number of changes have occurred making this possible. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible.

But there is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, are there real machine learning use cases for the Oracle DBA?

In this presentation, I'm going to introduce you to the world of ML from a DBA perspective! This includes understanding what ML is, why use it, and why now. The ah-ha moment will occur when you realize many of our monitoring, alerting, diagnosis, and analysis skills are significantly enhanced with ML.

I will demonstrate a simple yet complete ML project using Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!

Quest Forum Digital Event 2020

Oracle Database and Oracle Enterprise Manager continuously introduce new and interesting features that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new capabilities in Oracle Database and Oracle Enterprise Manager, such as Performance Hub, Automatic Workload Repository, multitenant enhancements, and many others. This session provides practical recommendations and real-world best practices on when and how to best use which feature, helping DBAs with day-to-day tasks.