Quest Forum Digital Event 2020

Most did not expect a new version after 11.2, but then the surprise - Oracle 18c XE was released - for FREE.  In this session, we will dive into what is Oracle Database Express Edition - the latest updates, including diving into the excellent features it brings to the table.  Areas that will be covered include installation, usage, new features, and how you can quickly get started with Oracle XE and Docker - a perfect match.

Quest Forum Digital Event 2020

We have used Pure Flash storage and Oracle Multitenant to fully utilize our servers with minimal license costs. We have over 300 database instances. 150 unique databases and only utilize 26 licenses.

Quest Forum Digital Event 2020

Demystify the world's 5th most popular Database engine!  If you don't support MongoDB now, chances are that you will in the future. This session will explain the basic concepts of MongoDB in terms that an Oracle DBA will readily understand. It will also review how to install and administer MongoDB, and give some simple DML and DDL examples, and show you where to find more information about MongoDB.

Quest Forum Digital Event 2020

One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality misestimates.

Quest Forum Digital Event 2020

Trace File Analyzer includes features and tools to help Oracle customers achieve improved outcomes when creating service requests and interacting with Oracle Support. Learn how to leverage these components to speed and automate creation of service requests, target collection for specific issues, and use the SQL Test Case Builder to assist Oracle Support investigations of database and performance issues.

Participants will learn:
-How to use the advanced diagnostic features in TFA to create targeted collections based on specific conditions and events.
-Ways to connect TFA to MOS and upload files directly to Service Requests.
-How to use the SQL Test Case Builder to create and share performance incidents and reproduce problematic SQL on other databases.
-How to automate collections, create notifications, and view, package and manage RDA incidents from within TFA and Autonomous Health Framework.

Quest Forum Digital Event 2020

Oracle Data Guard and Oracle Active Data Guard have long been the answer for the real-time protection, availability, and usability of Oracle data. Attend this session to get an in-depth look at several key new features that will make your life easier and protect your data in new and more flexible ways. Learn how Oracle Active Data Guard 19c has been integrated with Oracle Database In-Memory and offers a faster application response after a role transition. See how DML can now be redirected from an Oracle Active Data Guard standby to its primary for more flexible data protection in today’s data centers or your data clouds. Leave this technical deep-dive session with a glimpse of upcoming new features brought to you by Oracle Development.

Quest Forum Digital Event 2020

AWS continuously rolls out new tools and capabilities around analytics at a pace that can be hard to keep up with, much less take advantage of.  In this session, we will provide an overview of the AWS suite of analytics tools, discuss current concepts such as data lakes, unstructured data, ML and AI, and review some ways that customers can begin experimenting on their own to see what areas would be beneficial to their business.

Quest Forum Digital Event 2020

The adoption of Kafka in enterprise is becoming more prevalent with the Oracle Database as being a common source/target. With the Kafka community talking about being an Event Streaming Database, Oracle DBAs are confused about exactly what Kafka is and what it can do that an Oracle Database can't do. In this session, Kafka will be compared to the Oracle Database through the lens of an Oracle DBA.

Quest Forum Digital Event 2020

SQLcl offers many ways to simplify your DevOps life. Imagine writing automation scripts for your database in languages like JavaScript, Python, or Perl - to name just a few - without the hassle of driver libraries. Although SQLcl is almost 100% compatible with SQL*Plus, it adds a lot of new commands and features to the old lady: Native support for Liquibase and Hashicorps Vault, for example. The most potent new keyword is "script." Script embeds the execution of SQL-statements or SQL*Plus-commands  from your favorite scripting language. Extend SQLcl by writing functions, use your favorite language’s objects and control structures and parallelize multiple tasks. Within this entertaining session, the presenting expert waters your mouth and generates countless wants.

Quest Forum Digital Event 2020

Application Express (APEX) continues to grow in popularity for application development, both for new business use cases as well as migration from older development technologies (e.g. PowerBuilder). But many developers and DBAs alike aren’t necessarily aware that APEX is now available within Oracle Autonomous Transaction Processing, a powerful self-contained set of Cloud-based database services.

This session demonstrates a real-life business scenario – the creation of a financial services/retirement planning application – that combines best practices for APEX development efforts with ATP’s simplicity to provide a stable deployment for hybrid OLTP and reporting workloads.