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

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

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.

Quest Forum Digital Event 2020

Since 2016, Nationwide Insurance has leveraged Oracle Enterprise Manager's Fleet Maintenance capability to effectively and proactively patch our Oracle database environment to address critical vulnerabilities and maintain version currency.  Over three years, using EM capabilities, Nationwide has patched more than 7000 databases with a success rate exceeding 99%.  This session will talk about EM's Fleet Maintenance capabilities and impart some of the lessons we learned to achieve success.

With 19c we get the tiny little command line tool that will allow us to update our databases "hands free."  We can do all the prechecks, fix 99% of pre-update issues, and then do the update, and finally, the post-update, all without our manual little fingers on the keyboard, well almost no little fingers on the keyboard.  Wait there is more, it is not all for just Database 19c we can use this on prior versions like 18.5 and new as well as 12c Release 2 (12.2 + DBJAN2019RU and newer).

Quest Forum Digital Event 2020

Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead.