November 12 - November 15, 2019
Quest Experience Week: Database and Technology Day
Wednesday, November 13, 2019
QXW Database and Technology Day is packed full of digital education designed to provide both strategic insight and how-to-education for Oracle users of all levels – for free!
QXW Database and Technology Day is dedicated to a different product and begins with a keynote followed by afternoon breakout sessions. Attendees can register for as many sessions as they like and experience conference-quality education without the travel and financial commitments of a face-to-face event. Conference-quality education, from the comfort of your desk!
Seize the opportunity to learn from peers, catch up on the latest hot topics surrounding Database & Technology and walk away with actionable insight to help you drive your business forward.
Join us to learn about:
- Autonomous Database
- Data Science
- DBA
- Developers
Database and Technology Day Agenda
11:00 am – 12:00 pm
Autonomous Data Management
Presented by Willie Hardie
Oracle
Abstract:
Oracle is proven to be the database of choice for managing enterprise-scale operational and analytical workloads on-premises, and in the cloud with truly unique and innovate autonomous database services. In this keynote session, we’ll examine some of the latest database software, infrastructure and Cloud innovations that can simplify today’s data management challenges.
12:30 pm – 1:30 pm
Innovations in Enterprise and Cloud Manageability: Roadmap for Oracle Enterprise Manager and Oracle Management Cloud
Presented by Dan Koloski
Oracle
Abstract:
Join executives who produce Oracle Enterprise Manager and Oracle Management Cloud to learn what’s coming up in Oracle’s flagship management offerings. Product leaders will discuss how to extend your manageability best practices to Autonomous Database, Exadata Cloud and Oracle Cloud Infrastructure as well as showcase new features for analytics, automation and troubleshooting a hybrid estate.
12:30 pm – 1:30 pm
How to Figure Out Why Your Query Is Taking Foreeeevvvvveerrrrrrr…IN LESS THAN 30 SECONDS!
Presented by Kaley Crum
ABC Financial Services
Abstract:
Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query. But once you’ve got an execution plan, what do you do with it? Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the execution plan is taking the longest?” “Which hardware component (CPU, Memory, Disk) is causing my query’s bottleneck?” “Is my parallel query making good use of its resources, or are they being wasted?” If you have the Oracle Tuning and Diagnostic Pack license for your database and 30 seconds, you can find the answer to these questions–and more!
12:30 pm – 1:30 pm
Upgrading to Oracle Database 19c
Presented by Roy Swonger
Oracle
Abstract:
Oracle Database 19c is the long-term support release for the Oracle Database 12c and Oracle Database 18c family, and many customers are actively planning their upgrades. This session from the Oracle Database Upgrade development team gives you the inside scoop on how upgrade has evolved (especially if your last upgrade was to 11.2.0.4). Learn what to plan for; get tips, tricks, and insights about upgrade performance tweaks; hear customer experiences; and learn about important parameter and behavior changes as you approach Oracle Database 19c.
2:00 pm – 3:00 pm
Unduly Forgotten Performance-Tuning Hero: PL/SQL Hierarchical Profiler
Presented by Michael Rosenblum
Dulcian, Inc.
Abstract:
A number of polls taken during various PL/SQL-related presentations paint a very strange picture: one of the most-critical FREE server-side performance-tuning tools is almost totally unknown! If you ask basic questions such as, “How much time is spent on routine A?” or “How often is function B called?” most developers would start to hand-code their own solutions instead of utilizing the Oracle PL/SQL hierarchical profiler (HProf). This is not because the provided functionality is disliked, but the fact is that most developers are simply not aware of its existence. This session is an attempt to alter this trend and re-introduce HProf to a wider audience.
2:00 pm – 3:00 pm
How To Prove The Problem Is Not The Database Using ASH Data
Presented by Craig Shallahamer
Orapub
Abstract:
Imagine being able to prove a performance problem is not a database issue. There are few ways to infer the problem resides elsewhere, but it’s difficult for people to believe you. However, by creatively using ASH data and the idle wait event “SQL*Net message from client” we can do this.
In this presentation, I will show you exactly how to do this. I’ll start with a quick ASH introduction, then dive into Oracle’s time model, what to look for and how to look for it and finally how to interpret the results.
You will learn how to look into the unseen world Oracle performance ASH analysis.
2:00 pm – 3:00 pm
Best Practices for the most impact-full Oracle Database 19c Features
Presented by Markus Michalewicz
Oracle
Abstract:
This session answers the question, “What’s new in Oracle Database 19c?” in a slightly different way: by providing best practices and a deep dive into the most impactful high availability (HA), scalability, and lifecycle management features in Oracle Database 12c, 18c and 19c, including a short roadmap of features yet to come in the next generation Oracle Database. Learn how to automatically benefit from “smart” features and how to facilitate optional features in the Oracle Database, Oracle Real Application Clusters (Oracle RAC) and (Active) Data Guard. Leave this session with a bag full of tips and tricks on how to prepare for and master the changes that come with some of the most beneficial features of them all on-premises, on Exadata Database Machines or in the cloud.
3:30 pm – 4:30 pm
Powerful: Practical Machine Learning In The Hands Of The DBA
Presented by Craig Shallahamer
Orapub
Abstract:
Powerful Machine Learning (ML) is upon us. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible.
But it’s not that simple.
So, 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. I will lead you through two use cases, each using a different ML algorithm. The first at a high level and the second at a detailed level.
Our future is not AWR or even ASH analysis! Now is the time for Oracle DBAs to step into the world of ML, because it is powerful, practical and enables us to do things we have never been able to do before.
3:30 pm – 4:30 pm
Top 10 Database Security Features you may not be using
Presented by Richard Evans
Oracle
Abstract:
Oracle Database 19c has hundreds of powerful features that help secure your data, and new capabilities are added with every release. In this session join Oracle product managers to discover 10 security features you may not be aware of. These features can help you streamline user administration, reduce your attack surface, deploy more-secure applications, and protect sensitive data. Spoiler alert: nothing covered in this session requires an extra-cost license.
5:00 pm – 6:00 pm
Oracle Cloud’s New Free Tier and Always Free Oracle Autonomous Database
Presented by Todd Bottger
Oracle
Abstract:
In this session get a first look at Oracle Cloud’s new free tier, including new always free services such as Oracle Autonomous Database with Oracle Application Express. Learn what always free services for Oracle Cloud Infrastructure and Autonomous Database are available now. Get details on service shapes, specifications, and regional availability. See live examples of what developers can do. Gain insights into Oracle’s free service roadmap, and ask questions of the Oracle experts. Learn tips and tricks to jump start your next big idea for free. Discover how Oracle is making it completely free and easier than ever before for any kind of developer to build on Oracle’s Gen 2 cloud infrastructure and the world’s #1 SQL database.