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.

View recording

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.

View recording

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!

View recording

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.

View recording

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.

View recording

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.

View recording

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.

View recording

Abstract:

Since 2016, Nationwide has leveraged Oracle Enterprise Manager’s Fleet Maintenance feature to effectively and proactively patch its Oracle Database environment to address critical vulnerabilities and maintain version currency. In this session learn how Nationwide used Oracle Enterprise Manager’s Fleet Maintenance feature to patch more than 7,000 databases over a three-year period, with a success rate exceeding 99%. Hear about Fleet Maintenance’s capabilities as well as some of the lessons learned to achieve success.

View recording

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.

View recording

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.

View recording

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.

View recording