POUG 2022

Zero Downtime Migration (ZDM) is Oracle's tool for the simplified and automated migration of your on-premises Oracle Database to Oracle Cloud or Exadata.
ZDM supports a wide range of Oracle Database versions and, as the name implies, allows the database migration with zero to insignificant downtime, depending on the migration scenario.
I will describe different migration methods and technologies, that ZDM uses under the hood and I will show you how to easily configure ZDM and move database to OCI.

Low-code platforms are getting more popular, and according to Gartner, even 25% of all applications will be created using these tools by 2023. It is a big opportunity for Oracle APEX but also a challenge as many other low-code tools in the market can be selected by customers instead.

Outsystems, Mendix, MS PowerApps, PEGA, and many, many more... How can APEX be better than them? In which areas are they better, and how can you get the same advantages in APEX to convince your client?

This session will be a deep dive into Oracle DbNest and beyond. We will look at the underling technologies used as a building block for our DbNest container (Linux namespaces/Seccomp/Cgroups/etc) and as Bonus we will also build an isolated container application from scratch Live !

A cross-platform web-based interface? Native GIT support for DevOps integration? This is everything the Oracle Analytics Administration tool wasn’t like, but… The new Semantic Modeler gives you this and much more, taking modeling to the next level and a new era after 10+ without changes.

Hello POUG! I’m newbie italian speaker, i like beer and i brew for my own. In this talk i want to share my experience on the field about Transparent Application Continuity and the journey from the developer (my co-presenter) and DBA. The session will be mostly a live demo.

This session shows how easy it is to instrument your code using the Open Source Logger Framework, so you can trace the steps in production without having to install a new piece of code.

Using PostgreSQL in high-available environments is always based on replication and standby databases. There isn’t and probably won’t ever be an equivalent alternative to solutions like Oracle Real Application Cluster regarding scaling out the database service on multiple active nodes. Multi-master-replication solutions with PostgreSQL are somehow pointing in this direction but only in special scenarios. As the most hyped target for migrations from Oracle the comparison to Oracle Data Guard is inevitable. In this talk a direct comparison will show similarities, differences and the advantages or disadvantages of both worlds in detail including the relevance of additional PostgreSQL solutions like Patroni or repmgr.

Performance tuning is a topic that every DBA and developer should be familiar with. In this session, I will discuss different performance related cases, best practices and more. I will show how important it is for a DBA and Developer to work together to solve issues and “maybe” even become FRIENDS.

Is your infrastructure composed by a mix of Oracle products and Open Source? Do you want to have a single monitoring tool which supports in the same way several database technologies? Do you need to ensure that your system’s healthy is good and to spot your performance issues at a glance?

utPLSQL allows you to easily develop tests for your PLSQL and rerun those tests after any change. If testing everything again after a small change is a matter of a click of a button, it’s no use anymore to skip testing things because “Nah, the change can’t possibly influence this part of the code”.

Join this live-demo session and learn how to configure Data Guard, create services for Transparent Application Continuity, convert to snapshot standby, switchover. During the session, I will also demonstrate other Active Data Guard features like DML redirection, Real-Time Query, Automatic Block Repair, and, if enough time, Far Sync.

I’m planning the family summer vacation. This year I’m using Python, Machine Learning and Cloud Services to plan the vacation. Combining the outputs of the Python Machine Learning the live demo will show that machine learning is only part of a solution. Also includes Oracle Cloud

Did you ever consider migrating your Oracle database to PostgreSQL? If yes, then this talk may be just the right thing for you.
The talk is divided in two parts: in the first (shorter) part we will see why you should consider migrating from Oracle to PostgreSQL.
In the second part we demo the migration of an Oracle sample database. We show how the CYBERTEC Migrator Standard Edition (a free tool) simplifies such migrations.

Check more: https://www.cybertec-postgresql.com/en/products/cybertec-migrator/

Source control in databases is a difficult problem. There are tools to help but none of those is fully addressing all challenges of applying changes to databases. This presentation is based on a real life example and shows a story of moving from direct code edit on production to CICD pipeline.

This talk is aimed at architects and administrators of traditional databases, who wonder what a distributed database is, what YugabyteDB is and why SQL databases had to be re-invented.

Git is currently the most popular Version Control System, used very successfully by numerous projects around the world. This talk, aimed at Oracle developers and DBAs, shows how to use it to good effect.

There are some easy and straightforward changes which you can make to your Oracle database which will make it more secure, harder to exploit and, in the unfortunate even of a data breach, give you a chance of noticing what happened!

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 didnt 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.