DOAG 2023 Conference + Exhibition

In this presentation, I will showcase the simplicity and accessibility of artificial intelligence (AI) technology, specifically for individuals without a background in data science. Attendees will learn how to construct and launch a question-and-answer web app through straightforward APIs, requiring only a few lines of code. This browser-based app offers a contextually relevant response within seconds. You can train the bot using historical texts, Wikipedia pages, and even Oracle alert logs. The implications of this technology are astounding, providing a glimpse into the future of AI and expanding its accessibility to a wider audience. This presentation offers a unique opportunity to explore and learn about cutting-edge technology, with the potential to revolutionize daily interactions with AI.

Envision the ability to establish that a performance problem is not stemming from the database. Although there are methods to deduce that the issue lies elsewhere, it can be challenging to gain others' trust in this assertion. Nevertheless, by utilizing ASH data in a creative manner, we can provide evidence that the problem does not originate within the database.

For instance, let's consider a scenario where a batch process is taking an excessive amount of time, but no evidence of the process can be found in an AWR report, even after analyzing AWR and standard ASH data.

By employing a combination of techniques, such as configuring ASH to capture "non active" sessions temporarily and meticulously observing an Oracle session while focusing on the "SQL*Net message from client" event, we can conclusively demonstrate that the performance issue resides outside of the database.

During this presentation, I will guide you through a step-by-step demonstration of precisely how to accomplish this. We will begin with a brief introduction to ASH, delve into Oracle's time model, discuss what to look for and how to conduct the analysis, and ultimately, learn how to interpret the obtained results.

Smooth database operations can be disrupted by unforeseen performance incidents. But what if we could anticipate the occurrence of such incidents within the next few minutes? By utilizing Oracle Sysmetric data and deep learning neural networks, this possibility becomes achievable.

This presentation will begin by exploring the recognition of patterns and how neural networks strive to accomplish the same. Then, we will delve into Sysmetric data, comprehending its time-series nature and leveraging it effectively. At this point, we will grasp the reasons why neural networks and deep learning are highly sought after for performance prediction.

To replicate the mind-blowing graphical demonstration of real-time performance predictions, all you need is a Gmail account and access to your Google Drive.

Once you catch a glimpse of the immense possibilities, an entirely new realm of performance monitoring and alerting will unfold before you. Join me for a captivating presentation on applied Machine Learning, offering a glimpse into the future of Oracle professionals.

Immerse yourself in this full-day workshop where AWR report analysis takes on a whole new dimension. Gain the confidence to swiftly identify and resolve real performance problems, ensuring optimal system performance and propelling your career to new heights.

In this immersive workshop, you'll learn the art of setting up and navigating AWR analysis in a flash—30 minutes or less! I'll take you on a deep dive into when and how to use AWR analysis, coupled with operating system analysis, for a panoramic view of performance bottlenecks. It's time to see the bigger picture!

Unlock the secrets of Oracle's time model CPU consumption and wait time collection strategies and extract critical insights. With OraPub's 3-Circle analysis technique, you'll effortlessly spot those elusive PL/SQL culprits and avoid the pitfalls that may trip you up during analysis. It's time to outsmart the challenges!

But this workshop isn't just about theory; we'll dive into hands-on exercises and real-world scenarios to unleash your full potential. You'll become a master of rapid-fire AWR analysis, simplifying complex problems with ease. By harnessing the power of wait time data analysis, you'll enhance your understanding of performance issues and confidently communicate your findings.

No matter your Oracle version, architecture, configuration, or deployment (whether it's in the cloud or on-premise), this workshop offers a versatile toolkit to fuel your troubleshooting prowess. Get ready to maximize efficiency and become the performance hero you were destined to be.