POUG2024

Jumping into a new ecosystem presents many challenges, while we are learning the new functionalities of the platform, certain processes also need to be established for an efficient development pipeline, learn how you can implement DevOps directly in your database without using any external tools!

In this presentation we look at different metrics and data sources that are essential for making sure that databases in Data Guard FSFO configuration are healthy and able to take on the traffic from the client applications in case of problems - with the end goal of automation and alerting in mind.

This presentation aims to clarify how Oracle database patching is managed using Ansible automation. It covers the explanation of Ansible code responsible for coordinating and executing playbooks on database servers, with strong focus on gathering information before and in the middle of runtime. It introduces a description of strategy of how patching automation was split into three phases: pre-patch, patch, post-patch with detailed explanation why such approach was used based on case study of RAC cluster database switchover to newly provisioned golden image home.
The authors discuss how to cover RAC, R1N, single instance databases with Ansible playbooks and what pitfalls can occur. Orchestration of the whole solution was combined into two application entities, scheduler with functionality of gathering approvals and AWX as executor. Main aim of such an approach is to focus on scheduling the patching process and reacting to its failures instead of emphasizing only its execution.

Example of SQL profiling accompanied by primary school level math.
TEMP, Flash, ASH, SQL and battle with time.
How much time can you gain when you change your SQL *without* even running it?

The next trend (hype?) is : Clustered, serverless, distributed, sharded, replicated, databases.
A lot of buzzwords, and I have omitted “multi-cloud”, “raft” and “vector”.
We’ll try to find out how various vendors interpret those (buzz)words and how/when these are useful.

There is many ways to monitor an Oracle database and I would like to present how to add a database monitoring to the existing monitoring stack based on the Prometheus and Grafana.

I would like to present a couple of performance cases and share with the audience my approach how to find the issue and fix it.
The presentation will contain real scenarios.

Over the last few years we have seen an increasing number of Ransomware attacks, impacting all industries, with no targets it seems off-limits.

In this presentation I will discuss the need for a multi-layered approach and share some of the ways we can protect our backups from Ransomware attacks.

Maximize Oracle Database to cut data movement between OLTP and OLAP/DW. Use Materialized Views, In-Memory Store, and more to reduce network traffic, lower processing needs, and decrease data redundancy. Enhance efficiency and cut costs with streamlined, integrated analytics.

Once upon a time, views (and views on views on views) were one of the main reasons for performance problems in Oracle. Let’s take a look at how the Oracle optimizer has improved over the years and how it deals with views today to make them as fast as possible.

Come learn about (or review your knowledge of) this fundamental (and controversial) concept in relational database design.
When (and why) did it come about? What exactly it is? How best to deal with in the Oracle Database as developer or DBA.

Learn how we set up a development and deployment process using SQLcl, Liquibase and GitLab that doesn't slow down your development speed.

In this presentation, we delve into the heart of Oracle Database's Cost-Based Optimizer (CBO), and explore why allowing it to roam freely leads to optimal long-term query performance.

Discover why the key to unlocking the CBO's potential lies not in restraining it with hints or profiles but in empowering it with a wealth of knowledge. We'll explore the art of crafting strategic indexes, harnessing the power of statistics, and other ingenious meta-information techniques to guide the CBO's decision-making process. Learn how to keep the optimizer dynamic and responsive, adapting to evolving data landscapes without sacrificing performance.

Buckle up as we deal with 10 operations having a reputation of being "bad" or "slow" – from Hash Joins to Table Access Full – that might sound like performance pitfalls. But, in truth, they can be powerful allies when orchestrated under the right circumstances.

Join us on a journey where seemingly bad choices transform into performance triumphs, demonstrating that in the realm of Oracle optimization, knowledge is power, and the true mastery lies in understanding and supporting the CBO rather than attempting to control its every move. Rule less, optimize more!

Explaining the details of Oracle transaction internals, with all of the horrors of block dumps.

The Oracle Rest API has been there for some years and gets new releases frequently.
In addition to the possibility to create your own endpoints, you can also use the db-api endpoints.
These are used for DBA Tasks like creating a new CDB or adding a new PDB but it can also be used to get performance information out of the database (e.g. ASH information).
But what is Oracle doing under the hood? What needs to be considered while using these APIs?

Oracle 23c brings in many improvements and new features to SQL language. In this session I'll cover the ones that I find the most useful and the ones that will make your life easier. We'll not cover all the details, but it'll be a good starting point to inspire and present some use-cases.

This presentation will show you how to leverage bpftrace to explore the fascinating inner workings of Oracle.

Demystifying AI Vector Search in the Oracle database. What are vectors?

Prepare, generate and embed. New search operators and functions. Examples.

Vector distances + measurement methods. Similarity searches

Integrate with PL/SQL and APEX applications.