Quest Forum Digital Event 2020

In this era where data privacy and security are a major concern, we managed to be compliant and safeguard ourselves by implementing various Oracle Security products and features. To address the needs, we have implemented Database Encryption, Backup Encryption, Database Vault, Audit Vault, GoldenGate Encryption, Data Masking, and several other security best practices. In this session, the attendees will have a clear idea about important database security products, their use cases, and applications and what we do to protect our database where compliance and data security is at the center.

Quest Forum Digital Event 2020

In this session learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c histograms and Oracle Database 19c histograms.

Quest Forum Digital Event 2020

Linux is a popular platform for database servers like Oracle. With knowledge of a moderate set of command-line commands and tools, inveterate Windows DBAs can come up to speed quickly.

Quest Forum Digital Event 2020

For some, the word DevOps means a Lot, there have been many books written about it.  Yet, so many do not know what it is, what it stands for.  Let's take a look at the following key areas: What is DevOps?  Why is it so Important? How to get started!

Quest Forum Digital Event 2020

Amazon RDS Oracle Database service and Oracle Autonomous Database are DBaaS. They have similarities and differences. Come to this session to understand the features and contrasts of both services – not an attempt to show one is better than the other. Both have their use cases and advantages. Having a deep understanding of the capabilities and limitations will help you to understand the best and suitable service for your application.

Quest Forum Digital Event 2020

Powerful Machine Learning (ML) is now available to Oracle DBAs. Over the past few years, a number of changes have occurred making this possible. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible.

But there is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, are there real machine learning use cases for the Oracle DBA?

In this presentation, I'm going to introduce you to the world of ML from a DBA perspective! This includes understanding what ML is, why use it, and why now. The ah-ha moment will occur when you realize many of our monitoring, alerting, diagnosis, and analysis skills are significantly enhanced with ML.

I will demonstrate a simple yet complete ML project using Python and the "Always Free" Oracle Autonomous Database with Oracle ML SQL Notebooks. All presentation slides, scripts, and a recording of the demonstration are available!

Quest Forum Digital Event 2020

Containers have been embraced by the developer community, but acceptance and adoption by DBAs is more... tepid. That's understandable--why would anyone want a database that's stateless and immutable?! I started using Docker under duress and had no idea what I was doing. Since then, I've learned that Docker elegantly addresses many situations faced by DBAs, including:
- Rapidly provisioning test and development environments
- Interacting with Oracle Cloud Infrastructure databases (including ATP and ADW)
- Preparing environments for performance testing
- Building Gold images
- Exploring new technologies and features
- Discovering and confirming bugs
- Preparing for certification exams

This session is a crash course in Docker covering the terminology, concepts, skills, and practical examples needed to begin using containers to support databases.

Quest Forum Digital Event 2020

Oracle Database and Oracle Enterprise Manager continuously introduce new and interesting features that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new capabilities in Oracle Database and Oracle Enterprise Manager, such as Performance Hub, Automatic Workload Repository, multitenant enhancements, and many others. This session provides practical recommendations and real-world best practices on when and how to best use which feature, helping DBAs with day-to-day tasks.

Quest Forum Digital Event 2020

Join Oracle development for the latest updates on high availability (HA) best practices in this well-established technical deep-dive session. Learn how to optimize all aspects of Oracle Active Data Guard 19c. See how to use session draining, transparent application continuity, Oracle RAC, and Oracle GoldenGate to mask outages and planned maintenance from users and to accelerate time to repair for single database or your fleet of databases. Hear about the latest HA best practices with Oracle Multitenant and understand how the new sharded architecture can achieve even higher levels of HA and fault isolation for OLTP applications. Find out how everything you know about Oracle Maximum Availability Architecture (MAA) on-premises can be deployed in the cloud.

Quest Forum Digital Event 2020

Learn how POWER9 with the Oracle 19c DB In Memory features can help you accelerates performance and reduce CPU use when performing simple and complex analytics queries. After an overview of the newest capabilities of Oracle Database In-Memory feature, we'll share our experiences testing DBIM with simple and complex queries on POWER9. We will share the speed ups achieved for a set of reporting queries run In-Memory compared to disk row format, as well as hints and tips for getting the best results with In-Memory.