POUG2022, 9-10 września

Konferencja hybrydowa (wszystke sesje on-site + streaming)

Agenda



 
Track 1
Track 2

8:00-9:00
Rejestracjarozwiń opis

9:00-9:15
Otwarcie konferencji z partnerem głównym - firmą 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.
Prowadzący
Jakub Pitera
Sesja firmy Pretiusrozwiń opis

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 !
Prowadzący
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.
Prowadzący
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.
Prowadzący
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.
Prowadzący
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.
Prowadzący
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.
Prowadzący
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?
Prowadzący
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”.
Prowadzący
Erik van Roon

14:25-15:05
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.
Prowadzący
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
Prowadzący
Brendan Tierney

15:15-16:00
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/
Prowadzący
Max Hofer
Michał Małecki
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.
Prowadzący
Marcin Przepiorowski

16:10-16:55
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.
Prowadzący
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.
Prowadzący
Martin Bach

17:05-17:50
Koniec ścieżki 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!
Prowadzący
Neil Chandler

Koniec

 
Track 1
Track 2

10:00-10:45
What is new in the relational database worldrozwiń opis
The presentation covers a review of all new features including a comparison of the top RDBMS brands: Oracle, MySQL, DB2, SQL Server, PostgreSQL, MariaDB, MongoDB, Redshift, Snowflake, Aurora, SAP HANA.
New features of different database brands are added every year if not more often. The presentation is about how the leading database brands relate to each other, what is new and what is missing. Moreover, what is needed by developers and DBAs. What are the new innovations in the RDBMS world? Is there a leading database brand?
Prowadzący
Julian Dontcheff
Building a hybrid cloud using VMware in Oracle Cloud Infrastructurerozwiń opis

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.
Prowadzący
Rodrigo Jorge
Autonomous Health Framework - ML Applied to Save DBA's Timerozwiń opis
How use the best of AHF Capabilities to Automate your work? This session covers 101 about Autonomous Healthcheck Framework for a DBA perspective, focusing on understanding how it is a tool to make your Troubleshooting and Diagnose even better based on embedded Machine Learning. This session also contains our Top features list over Autonomous Healthcheck Framework in order to make it practical for the DBAs day-to-day challenges and activities.

The session has examples and codes on quick demos for the audience on how to implement that on your environment.
Prowadzący
Matheus Boesing

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.
Prowadzący
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.
Prowadzący
Shasank Chavan
Roger MacNicol

12:45-13:30
My struggles with reference partitioning rozwiń 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.
Prowadzący
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.
Prowadzący
Moritz Klein

13:30-14:15
Lunchrozwiń opis

14:25-15:05
Advanced Oracle Database Troubleshooting - Finding and Fixing A Bug On Your Ownrozwiń opis
At POUG 2017 Kamil and I did an interview about “Researching Oracle RDBMS internals” and if such low-level deep dives are really necessary or not (disregarding the fun aspect of it of course). In this talk I gonna demonstrate a real life client case where “low-level hacking” was the only option to get the data back. The client was running an Oracle XE database, hit a bug (which was surprisingly already described in My Oracle Support in other circumstances and with no workaround and no interim patch) and as we all know Oracle Support does not provide any support services or patches for Oracle XE. Sounds like a classic catch-22 at first, right? Come in and find out how to identify the broken (C) code part, how to work-around it and get the data back.

My promise as usual: “Just one or two slides but a lot of code and command line” ;-)
Prowadzący
Stefan Koehler
Let's GO!rozwiń opis
Everything you need to know to start programming in Golang! This talk introduces Golang, its features, and how to program a REST endpoint accessing data.
Prowadzący
Jasmin Fluri

15:15-16:00
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.
Prowadzący
Ron Ekins
Is Cost Based OR Expansion Broken?rozwiń opis
As with most interesting questions, the answer is “Sometimes”. I’ll show a simple testcase, modeled on a real-world query, where it results in a terrible plan. and we’ll investigate the mistakes the optimizer has made. Hopefully by the end you’ll know enough to answer the question yourself.
Prowadzący
Patrick Jolliffe

16:10-16:55
"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 …
Prowadzący
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 didnt work.

Spoiler: Design!
Prowadzący
Piet de Visser

17:05-17:50
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.
Prowadzący
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.
Prowadzący
Franck Pachot

18:00-18:45
Koniec ścieżki 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.
Prowadzący
Alex Nuijten
Chris Saxon

Koniec

Jak dojechać


Kino Nowe Horyzonty

Kazimierza Wielkiego 19a/21, 50-077 Wrocław

Kino Nowe Horyzonty to wyjątkowe miejsce na mapie Wrocławia – niezależna instytucja kultury, w której do naszej dyspozycji będą dwie sale kinowe. Co to oznacza? Idealna jakość dźwięku i obrazu oraz wygodne fotele!

Strona www

After party


Zostań sponsorem

POUG to nie tylko oficjalna społeczność Oracle – to przede wszystkim baza bardzo aktywnych użytkowników, angażujących się w rozwój grupy zarówno podczas samych spotkań, jak i w trakcie przygotowań do nich. Nasz przekaz dociera do blisko 400 osób związanych z bazami danych – od administratorów po deweloperów, od początkujących po ekspertów z wieloletnim doświadczeniem.

Dbamy o to, żeby nasi Partnerzy mieli możliwość zaprezentowania swoich marek i produktów w najlepszej możliwej atmosferze. Chętnie odpowiemy na pytania i rozwiejemy wątpliwości!

Zgłoszenie