How To Analyze SQL Run Times By Plan Using ASH Data (Connect 2019)

Imagine knowing SQL run times without instrumenting your application. That is exactly what I will teach you how to do by analyzing ASH data.

Suppose the ticket shows, “This query takes 45 seconds!” How can you confirm that? Is 45 seconds unusual? Has it happened before? Perhaps there is a bad plan being used? What is a good plan for the SQL? This is valuable information that creatively analyzing ASH data will reveal.

In this presentation, using ASH data, I will show you how to manually infer SQL run times. Then I’ll show you how to use a simple yet flexible SQL script to analyze ASH data, infer SQL run times and report the results… even at the execution plan level. Next I’ll show you how to analyze the run time samples using the free statistical package R.

Join me as we explore the untapped analysis opportunities ASH data provides.

Powerful: Practical Machine Learning In The Hands Of The DBA/Developer (Connect 2019)

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

But it’s not that simple. There is a lot to learn. Everything from methodology to math to tools. And then the nagging question of, as a DBA/Developer is there a real application in my work?

The good news is, I have been able to leverage aspects of ML for many years. But now is the time to push all that ML has to offer into our work. And in our work, we can do things never before possible. It’s taking the DBA/Developer to a whole new level.

So, in this presentation I’m going to introduce you to the world of ML from a DBA/Developer perspective. This includes understanding what ML is, why use it and why now. The ah-ha moment will occur when you learn that there are many algorithms within the ML umbrella to choose from. I’ll pick two of algorithms, demonstrating how I used them to answer difficult DBA/Developer type questions. One will be at a high level and the other I’ll walk you step-by-step through the process.

Now is the time for Oracle DBAs/Developers 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.

How To Build A Performance Indicator Using Machine Learning (Connect 2019)

Both a time based (think AWR) and a sample based (think ASH) performance analysis provide the Oracle performance specialist with an incredibly rich data set and structured analysis possibilities. A DBA/Developer proficient in both AWR and ASH analysis is highly valuable in today’s market.

However, complex performance situations are not always quickly diagnosable using an AWR data time based analysis or by an ASH incident analysis. It’s because situations are sometimes a complex mix of highly fragmented time classifications and a changing workload mix. This makes diagnosis more time consuming and complex. And certainly, the diagnosis will not be completed the second the SLA breach occurs!

A solution is to use an unsupervised classification machine learning (UML) model to immediately tag, for example, a snapshot duration as bad, ok, or wonderful.

A UML predictive model has the ability to combine a virtually unlimited number of performance related characterists into a small set of classes, such as green, yellow, or red.

In summary, this is done by tagging a few of the known problem time samples as “bad”, training the UML model, then noting the assigned classification for the “bad” samples. Then we integrate a new sample into the model and observe how the model classifies it. If the new sample class is “bad” then we have identified a potential performance situation.

Now, any number of actions can occur, such as an email, text, flashing red lights, sirens, etc.

This “new sample integration and alert” process can occur in less than a second, when automated. It happens well before the phone rings or a ticket is submitted, enhancing IT business operational efficiency.

Join me as I demonstrate how a performance focused Oracle DBA/Developer can use machine learning to their advantage!

Backup to the Cloud and Beyond – Real Solutions (Connect 2019)

Let me challenge your thoughts about backing up files to Oracle Cloud. Every customer should be considering RMAN backups of their databases to Oracle Cloud (if not already). Oracle provides the most secure and optimal methods to backup the database to the cloud. Backing up the Oracle database to the cloud is just the tip of the iceberg. With ERP systems, you need to consider backups beyond just the database. You have to think outside the box and consider the entire solution and include non-database files such as EBS binaries, middleware backups, documents, reports, logs, etc.
I will present a deep-dive content of backing up the database and EBS applications to Oracle Cloud. I will provide in-depth insight and real-life examples of backing up the database to the cloud and restoring the database from the cloud.
I will also demonstrate how to leverage Oracle’s Storage Cloud Storage Appliance to backup other non-database files. I will demonstrate various methods to uploading and downloading various types files to the Cloud and how to drive performance. Demonstration of the Oracle Storage Cloud Storage Appliance will be provided. Command-line interface to upload/download files directly to Oracle Cloud will be shared.

Bullet Proof Your Data Guard 12.2c/18c/19c On-Premise and to the Cloud (Connect 2019)

Learn how you can setup Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 1 and 2/18c/19c. In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

Come see Data Guard best practices in action. The session concentrates on:
o Building the Physical Standby
o Monitoring and Maintaining the Physical Standby
o Configuring Data Guard Broker
o Performing Backup and Recovery with RMAN
o Setting Archive Retention
o Performing Switchovers and Failovers

Attendees will get access to all the scripts to automate the Data Guard configuration.

Get Ready For Brain OverLoad with Oracle Database 12.2/18c/19c Features (Connect 2019) – Charles Kim

Oracle Database 12 Release 2 is packed with enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas:
1. Oracle 18c
2. Upgrade to Oracle 12.2/18c/19c
3. Online Improvements
4. Partitioning Option
5. Multi-Tenancy (PDB) Option
6. Data Guard
8. General Database
9. RAC
11. In-Memory
12. Database Upgrade Options
Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience.

We will share all of the code from our presentation so that you can add them to your arsenal.

Nowadays, all the Oracle new features in the database and infrastructure are born in Oracle Cloud. All the database new features are first provided in Oracle Cloud and Engineered Systems then made available to the general public. Learn all the latest innovations for Oracle databases to become successful in Oracle Cloud, Engineered Systems and on-premise.