Quest Forum Digital Event 2020

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information, and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self-service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

This session covers:
-Connecting Oracle databases in the Cloud or on-premises to chat services via REST
-Considerations for building database APIs to handle ChatOps interactions
-Methods for securing communications between the database and application
-Practical examples of ChatOps integrations

Quest Forum Digital Event 2020

Oracle is revolutionizing how data is managed with the introduction of the world’s first self-driving database. Oracle Enterprise Manager offers a unified, cost-effective, and easy way to automate the migration of your on-premises database workloads to the next generation of industry-leading database, Oracle Autonomous Database, eliminating human labor and error. For Database Cloud Services, Enterprise Manager helps DBA’s consolidate Databases or Infrastructure on OCI Cloud and also assess success of migration. Reap benefits from seamlessly transferred configurations, periodic synchronization of data with production, and “time travel” capabilities such as rewind/refresh. Join this session to learn more.

Quest Forum Digital Event 2020

Encrypting data at rest is a foundational strategy for any information security program. The security of your data depends not just on how complete the encryption is within database environment but also on how much security and control you have over the encryption keys. In this session, join Oracle Database security product managers to learn about innovations in Oracle Transparent Data Encryption including online migration from clear text to encrypted data. Hear about the latest innovations in key management including the new multimaster high-availability architecture for Oracle Key Vault. The session also features real-world customer deployment cases.

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

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.