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.

Quest Forum Digital Event 2020

How does database security change when you move to the Cloud?  Security does change and how to handle database security needs to change when running databases in the Cloud.  However, you still own your data and are still responsible for making sure that data is secure.  This session will first discuss the security differences for Oracle Databases between IaaS, PaaS, DBaaS, and on-premise. Advantages like enhanced database security features and disadvantages such limited infrastructure visibility are reviewed as they are present in all Cloud deployments.  Seven key components of an effective Cloud database security program are presented including how to effectively manage privileged, protect sensitive data, and monitor database activity.

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

Cloud is transforming the enterprise and the career path of the DBA. See how. As cloud gains momentum and migrations of applications and databases become more common, the question is often asked: "Does Cloud mean the end of the DBA?" Cloud is likely not the end of the DBA, but instead an agent in unprecedented change. This webcast will cover how Cloud is bringing about that evolution and what today's DBAs must know to be successful in a Cloud-enabled future.

The future is here, let's take advantage of it today!

Quest Forum Digital Event 2020

Amazon Relational Database Service (Amazon RDS) for Oracle continues to be a popular choice for “lifting and shifting” mission-critical Oracle database workloads to the cloud. In this session, you learn how you can scale compute, storage, and databases to address changing database workload patterns and increasing business demands for cost optimization. We also cover best practices for new high availability, security, and disaster recovery features.

Quest Forum Digital Event 2020

MySQL is the largest open-source database in the world. It's a product that resides under the wings of Oracle Corporation and still it survives with it's big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We'll discuss features and we'll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we'll go through the basic concepts of the database and we will set up a replica.