Quest Forum Digital Event 2020

The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality.  The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.

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

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.