Quest Forum Digital Event 2020

Have you moved beyond just sending alerts and monitoring performance in OEM?  If not, learn the top 5 things that you should be doing to take your game to the next level.  Topics will include high availability, standby management, configuration management, and more!

Quest Forum Digital Event 2020

In this session join Oracle Database Product Management to learn more about using JSON in the Oracle Database. Learn about some of the new innovative ways that the Oracle Database can be used to load, store, and manage JSON and take advantage of the enterprise class features that Oracle provides so well.

We will also take a look into the unique Oracle Database features to leverage memory-persistent technologies for fast ingestion and retrieval of attribute-value pair data.  Other topics that are covered include the SQL language enhancements for complete flexibility and ease of use when working with JSON.

The session will also be discussing some of the enhancements being released in Oracle Database 20c for addressing the use of JSON.

Quest Forum Digital Event 2020

With Oracle's release of Autonomous DataWarehouse, Autonomous Database, and Autonomous Transaction Processing, we are entering a new era in database administration.  How is an old-school DBA supposed to survive in this brave new world of automation?  Are my existing skills obsolete? Am I out of a job? Never fear.  In this session, we'll discuss what exactly all this autonomous fuss is all about and what it will mean to the daily life of a DBA.  We'll draw comparisons to (soon to be legacy) tasks that all DBA's are comfortable with and how these tasks will be handled in an autonomous world.  We'll show you how to leverage your old school skills to be your biggest advantage in an autonomous world and position you to take your career to the next level in an Autonomous World.

Quest Forum Digital Event 2020

New DBA's hear stories from their experienced peers about databases being recovered from certain failure and the heroics involved, but what's the reason for those successes? One of the main tools, used by the savior DBA, is the Recovery Manager: RMAN. We're entrusted with our customer's data and the novice DBA has to know how to respond to database failures and recover from them. During this talk, the essentials of RMAN will be covered: concepts, setup, and usage scenarios. Afterward, with these resources in hand, attendees will have the preparation needed to start using RMAN.

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

MySQL has made many security improvements and brought many security features that have taken MySQL Database Security to a new level. In this presentation, we will explore MySQL database security and the features that can be used to make your MySQL databases secure and house your most sensitive data with confidence.

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

An exciting new feature of Oracle Database 18c and 19c is "Centrally Managed Users" (CMU). This, for the first time, allows for simple and complete database singe sign-on (SSO) and user management integration with Microsoft Active Directory (AD). No additional licenses required!

Previously, Oracle Enterprise User Security (EUS) and Oracle Unified Directory (OUD) were needed as an intermediate component bridging the Oracle Database to Active Directory. And while EUS/OUD is still present and does offer some additional features and benefits, it's no longer required for database-AD user integration and management.

This presentation details the advantages of using CMU over the previous technologies, covers the installation/set-up process, and gives practical examples and use cases for organizations to leverage and benefit from the simplified integration of database user management (authentication and authorization) with AD.

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.