POUG2022, September 9th-10th

Hybrid conference (on-site sessions+ streaming)

Agenda



 
Track 1
Track 2

8:00-9:00
Registrationrozwiń opis

9:00-9:15
Opening the conference with our main partner - Advatechrozwiń opis

9:15-10:00
Zero Downtime Migration - A simple way of migrating Oracle databases to OCIrozwiń opis
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.
Lecturer
Jakub Pitera
Low-code platforms for APEX developersrozwiń opis
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?
Lecturer
Przemysław Staniszewski

10:10-10:55
Oracle DbNest Inside Outrozwiń opis
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 !
Lecturer
Hatem Mahmoud
Analytics Semantic Modeler - A new age of metadata modelingrozwiń opis
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.
Lecturer
Gianni Ceresa
Christian Berg

11:05-11:50
Don't lose your wheels on HArozwiń opis
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.
Lecturer
Daniele Bocciolini
Andrea Lauri
Get to know your program by instrumentationrozwiń opis
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.
Lecturer
Patrick Barel

12:00-12:45
"StandBy-Database Shootout - PostgreSQL vs. Oracle"rozwiń opis
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.
Lecturer
Dirk Krautschick
"The One Where they talk about Performance Tuning at the CENTRAL PERK"rozwiń opis
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.
Lecturer
Rishin Mitra

12:45-13:30
Lunchrozwiń opis

13:30-14:15
"Monitor your databases with Percona Monitoring and Management tool"rozwiń opis
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?
Lecturer
Elisa Usai
"Getting started with unit testing PLSQL using utPLSQL"rozwiń opis
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”.
Lecturer
Erik van Roon

14:25-15:10
Oracle (Active) Data Guard in Action. 100% Console, 0% Slides!rozwiń opis
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.
Lecturer
Ludovico Caldara
"Planning my Summer Vacation using Python and Machine Learning"rozwiń opis
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
Lecturer
Brendan Tierney

15:20-16:05
Migrating from Oracle to PostgreSQL: easy-peasyrozwiń opis
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/
Lecturer
Max Hofer
Stop editing code in Production database - a journey from 90's to CICDrozwiń opis
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.
Lecturer
Marcin Przepiorowski

16:15-17:00
The importance of a distributed database.rozwiń opis
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.
Lecturer
Frits Hoogland
Git for Oracle Developers and DBAsrozwiń opis
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.
Lecturer
Martin Bach

17:10-17:55
End of track 1rozwiń opis
"Fundamental Oracle Security – What Many Of You Are Not Doing"rozwiń opis
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!
Lecturer
Neil Chandler

Koniec

 
Track 1
Track 2

10:00-10:45
From Exadata to Exacc, how screwed am I?rozwiń opis
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.
Lecturer
Fernando Simon
Building a hybrid cloud using VMware in Oracle Cloud Infrastructurerozwiń opis
Lecturer
Konrad Slezak

10:55-11:40
19c New Features are cool (also for attackers)rozwiń opis
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.
Lecturer
Rodrigo Jorge
"Why very wide tables are a very bad idea and how to make them less bad"rozwiń opis
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.
Lecturer
Martin Widlake

11:50-12:35
One Goal – Different Approaches: Performance Tuning in Practicerozwiń opis
“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.
Lecturer
Martin Berger
Dani Schnider
Dream the Stream : High Velocity Event Processing with a Converged Databaserozwiń opis
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.
Lecturer
Shasank Chavan
Roger MacNicol

12:45-13:30
My struggles with reference partitioningrozwiń opis
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.
Lecturer
Vidar Eidissen
APEX APIs Reloadedrozwiń opis
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.
Lecturer
Moritz Klein

13:30-14:15
Lunchrozwiń opis

14:25-15:10
The lifecycle of a humble rowrozwiń opis
Lecturer
Roger MacNicol
The Blair Witch (DB) Projectrozwiń opis
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!
Lecturer
Monika Lewandowska

15:20-16:05
Guardians of the Data - Protecting Oracle Backups from Ransomware and Malicious Intentrozwiń opis
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.
Lecturer
Ron Ekins
Falling BETWEEN the Cracks Of Cost-Based OR Expansion rozwiń opis
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.
Lecturer
Patrick Jolliffe

16:15-17:00
"Pour old wine in new bottles or ""Pour antique Oracle DBA skills in Ansible"""rozwiń opis
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 …
Lecturer
Flora Barriele
Partitioning, Cool Tricks and Snags.rozwiń opis
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!
Lecturer
Piet de Visser

17:10-17:55
Migrating a TB Database from 11g Windows to 19c Linux in less than an hourrozwiń opis
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.
Lecturer
Julian Frey
Anatomy of a distributed SQL database (YugabyteDB)rozwiń opis
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.
Lecturer
Franck Pachot

18:05-18:50
End of track 1rozwiń opis
SQL Syntax: Oracle vs. ANSI. Fight!rozwiń opis
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.
Lecturer
Alex Nuijten
Chris Saxon

Koniec

Jak dojechać


Nowe Horyzonty Cinema

Website

After party


After party will take place in the Antidotum Club on 9th September starting from 9PM.

POUG Partnership

POUG is not only the official Oracle community – first of all it is the base of very active members, who are engaged in the group development both during the meetings and the preparations to them. Our message gets to the 400 people connected with databases – from the developers to the administrators and from the begginers to the experts with years of experience.

We would like to invite you to be a part of our event – it is a chance to show your brand during and before the meeting.