POUG2022, September 9th-10th

ExaCC Gen 2 is the shiny toy from Oracle, but how shiny is it? In this session, I will show some important technical details about this new ExaCC world. Let’s discuss how to (or if is possible) create databases using ExaCC/OCI tools, JSON, database domains, and several other details that can help you to decide to use (or not) the ExaCC.
But not just that, architecture datils for CPU scaleup and (maybe) down, caveats for binary deployment, and several other things. And forgot about the marketing session, here I will talk and show real life.

This 100% live demo session will take you into the mind of a hacker and show a real-world attack scenario exploring 3 new features introduced on 19c, when poorly implemented by sysadmins.

Disc is cheap, “people” want to see all of their data in one place and they want it to be very easy to query it.

So let’s grab all the data across our systems and put it in one, massive, “simple” data swamp…lake… and query it.

And performance sucks.

One reason for this is those tables of 300+ columns, which most people do not even realise could be a problem.

I’ll explain why they are a problem, why they can actually become a crippling problem, and how you can fix it. Or, at least, live with it.

“Make it faster!” is a simple request we get every day, but it’s often hard to deliver. There are numerous methods, books & reports. But still it’s not simple or straight forward. Dani and Martin will tackle some “problems” - and challenge each other why and how to make their analysis.

Event stream processing is a rapidly growing category of workloads including IoT, Timeseries, Clickstream, Quality Control, Security, Auditing, Metrics, and Monitoring, etc. Analysts estimate the market to grow to $4B USD by 2027! One industry trend has been to use purpose-built stream processing engines for these workloads. This approach, however, sacrifices most of the advantages of an industrial-strength database platform. In this talk, we’ll discuss the key aspects of streaming workloads and the requirements of effective stream processing engines, and then show how the many capabilities of the Oracle Database, such as Native JSON support, RAC, Parallel Query, ILM (Information Lifecycle Management) Policies, In-Memory Columnar processing and Advanced Analytics, come together to provide an ideal streaming architecture on a converged database.

I inherited a star-table structure with reference partitioning. With a few billion rows in the tables, we wanted to do partition splits. This is the story of how it was supposed to be done, what we really ended up doing, and what attribute clustering can do to performance.

Want to do something a bit outside of what APEX offers directly? Not sure how to ensure easier upgrades even with custom code? Then this session is for you. Come with me on a treasure hunt within the APEX APIs and learn how to create enhancement to your applications but still stay close to standard.

Good database design is critical to the performance and quality of systems. Unfortunately, sometimes something goes wrong. During the session, I will show you the scariest design solutions that Liron Amitzi and I have come across in our careers. Lots of hair-raising examples, lots of blood - pure horror!

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.

A simple test case, modeled on a real-world query, will be shown where this transformation resulted in a terrible plan. Assuming some familiarity of the Cost Based Optimizer (but a review of the information necessary will be included), we'll see exactly where it went wrong.

I am an outdated ordinary Oracle DBA. How can I play catch-up but still take advantage of all the hard-earned knowledge over the years? I’ll show you how you can easily use Ansible to automate most of your boring Oracle DBA tasks: DB creation, export/import, migrations, patchings …

The possibilities of partitioning, especially in an Oracle DB, are huge, and the temptation to do something High-Tech is always there. We’ll go over some of the tricks we tried with “Partitioning” and how they helped us. We will also confess the items that didn't work.

Spoiler: Design!

Upgrading a database with plattform migration is always challenging especially if you should hav a very short downtime. There are many ways to do this. In a recent project I used Transportable Tablespace for that. I’ll show how I did this and what could go wrong.

We like to understand how a database works. What is better than an open-source DB that was engineered with modern technology? Let’s deep dive into the technology used by the YugabyteDB distributed storage and transactions engine, and the use of PostgreSQL on top of it.

Debates over whether it is better to use Oracle syntax or ANSI in your SQL rage on the internet. It is time to settle these once and for all! In the blue corner, Alex will champion ANSI style. And in the red corner, Chris will defend Oracle syntax. In a best-of-three battle, covering joins, functions and recursive queries they will each highlight the benefits of their chosen style. This session is for developers looking to expand their SQL skills and understand the pros and cons of the syntax methods.