Quest Forum Digital Event 2020

APEX Interactive Grids have a myriad of customization options, some declarative, and most via JavaScript APIs.  How to stay sane, organized, and consistent with so many options? Standardize!  Delivering clean, uniform, customized interactive grids within a single application, or across many developers, many applications across an organization is less difficult than you think.

We will demonstrate use of a common configuration file and classes to standardize grid features across your applications. Decide upon your grid options, code them once, then include and use everywhere. Better yet, not everyone needs to be a JavaScript expert to implement your standard grid configurations. Attend to learn how to standardize grid customization, and save on sanity.

Quest Forum Digital Event 2020

MySQL 8 introduced a new tool for DBAs. In this training session, we will explore the tool availability, installation, and usage. This tool is called MySQLShell and contains many features and  APIs that are very effective to manage the servers. MySQL/Oracle DBA can use this tool to explore the database using their Python/Javascript or Xconnector skills. This tool helps to download JSON documents to MySQL instance. We will go into details about many features that are very useful in daily DBA's tasks.

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

Infrastructure as Code (IaC) is the only right approach in the cloud. We will discuss how to use the IaaC on your cloud environment and manage your Oracle cloud with Terraform, Packer, Kubernetes, and Resource Manager OCI services. In the presentation, we also going to touch some other cloud-related subjects like lifecycle, cost management and other sides of managing infrastructure and databases in the cloud.

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.