POUG 2025
Poznań, 5-6 września

 

 

DLACZEGO WARTO WYBRAĆ SIĘ NA POUGa

Czyli co otrzymujesz w cenie biletu


  • 2 dni
    prelekcji

    Sama merytoryka, zero marketingowych sesji bez wartości. Tak, to nie jest typowa konferencja IT;)

  • FOOD & DRINK
    zapewnione

    Lunche i przerwy kawowe z przekąskami

  • AFTER PARTY
    z open barem;)

    Wieczorna integracja z grami i networkingiem

  • PIWO
    no limits

    Zgadza się - na POUGu serwujemy piwo bez limitów, ale umiemy się zachować!

  • 40+ nagrań
    z prelekcji

    Dostęp do nagrań i prezentacji z wszystkich sesji przez rok!

  • DOŻYWOTNI
    bilet na POUGa

    W tym roku do wygrania jest dożywotni bilet na nasza konferencję!

  • SPOŁECZNOŚĆ
    jak żadna inna

    Pogadaj z autorami książek, z których uczyłeś się Oracle'a i zderz z nimi wątpliwości!

Agenda



 
Track 1
Track 2
Track 3

08:00 - 09:00
Track 1 Rejestracja

09:00 - 09:55
Track 1 Keynote session rozwiń opis
TBC

10:00 - 10:45
Track 1 SELECT AI: How to query your data using natural language rozwiń opis
This presentation will explore the SELECT AI feature of Oracle 23ai, focusing on how natural language querying capabilities might enhance data accessibility, analysis, and insights.

This talk will be mostly live demos of Select AI feature, which allows you to query your data without using SQL language. Showing both successes and failures, exploring limitations and AI hallucinations.
Prowadzący
Andrzej Nowicki
Track 2 Performance Grand Prix – Who Will Win the Race? rozwiń opis
Every day, we race for better performance – optimizing SQL queries, searching for tricks and methods to retrieve and modify data in the most efficient way possible.
But have you ever wondered why some techniques are faster? Are they always better? And – most importantly – how much can you really gain from using them? Join us for the exceptional Performance Grand Prix, where various SQL techniques will compete for the title of efficiency champion!
At the starting line, you'll find a mix of classic and refined approaches. Your task? Guess which one will cross the finish line first. Participate in interactive quizzes, place your bets on the winner, and discover whether your chosen technique earned the trophy. Will an index scan outpace a full table scan? Or will an underdog surprise everyone?
Don’t miss this chance – hop into the driver’s seat and join the race for knowledge and performance!
Prowadzący
Monika Lewandowska
Track 3 Remember remember the 5th of September - fucking memory problems rozwiń opis
I’m old. Memory doesn’t work as it used to. Like in Oracle. Let’s troubleshoot PGA and SGA internals together. Whiskey helps. So is beer. Let’s eat a dear.

I’m old. Memory doesn’t work as it used to. Like in Oracle. Let’s troubleshoot PGA and SGA internals together. Whiskey helps. So is beer. Let’s eat a dear.
Prowadzący
Neil Chandler

11:00 - 11:45
Track 1 OpenTelemetry and Databases: The New Era of Monitoring rozwiń opis
Modern database monitoring is undergoing a paradigm shift with OpenTelemetry (OTel), which provides vendor-neutral, standardized telemetry for both Oracle and PostgreSQL. Unlike traditional siloed tools, OpenTelemetry unifies metrics, traces, and logs into a single observability pipeline, enabling more profound insights into performance bottlenecks, query latency, and resource contention.
Opentelemetries Database Receivers gain from:
Distributed tracing to correlate slow queries with application code
Custom dashboards for real-time visibility into connection pools, cache efficiency, and lock contention
Chaos-ready monitoring by combining OpenTelemetry’s metrics with failure injection testing
The fusion of OpenTelemetry Collectors (receivers/processors/exporters) with databases eliminates proprietary agents, offering scalable, cloud-native observability.
This talk dives into how the OpenTelemetry Receiver works and collects data and current problems. It also explains why your existing monitoring is considered legacy.
We will see why the future lies in declarative database observability—where OpenTelemetry’s extensible schema and open standards replace fragmented monitoring stacks, making Oracle and PostgreSQL as observable as stateless microservices.
Prowadzący
Jasmin Fluri
Track 2 Finding a Needle in a Haystack with Oracle Analytics and Vector Search rozwiń opis
oin us for a detailed session on the capabilities of vector similarity in Oracle Analytics. Through a live demo, you'll see practical examples of how vector search can be used in Oracle Analytics and Database 23ai. This session is ideal for anyone interested in leveraging advanced techniques to gain deeper insights from their data. Don't miss this opportunity to learn about the latest in Oracle Analytics!
Prowadzący
Sylwester Dać
Track 3 The Love and No Love with Oracle Performance Tools rozwiń opis
Oracle Database provides a solid set of performance tools that are essential for troubleshooting and optimization. While they are powerful and useful, some aspects are less than ideal. In this talk, I’ll go over the features that work well for me, the ones that don’t, and the changes that, in my view, would make these tools significantly better.
Prowadzący
Timur Akhmadeev

12:00 - 12:45
Track 1 How to completely botch your Database Migrations to OCI (and maybe how to avoid it) rozwiń opis
Are you ready to mess up your database migration to OCI, big time? Then this session is for you! I’ll walk you through some of the best ways to ensure delays, confusion, and frustration at every step of your project. From misguided technical decisions to expert-level miscommunication, learn how to make your migration as painful as possible.
But if, for some reason, you are not ready to go through hell, I suppose I can also share practical technical solutions and crucial soft skills to keep your OCI migration project (and mental health) on track.
Prowadzący
Flora Barriele
Track 2 Network Latency - important factor when considering migration to OCI/ADB rozwiń opis
I. Introduction - Response Time and Network Time
II.Connection Architecture
-App to on-prem DB (same DC)
-App to DBCS
-App to ADB (LB + CMAN)
III. Debugging Network Latency - Tools + Demo
-Summary showing differences in network latency between the above configurations
-CONNPING and OCIPING utility
-DBRWPLT utility
-Demo showing how to use these tools
IV. Ways to reduce the network latency
V. Q & A
Prowadzący
Dawid Welder
Martin Berger
Track 3 Online Schema Changes: Real-world Experience with Edition-Based Redefinition rozwiń opis
Rolling deployments have become standard for application updates, but database schema changes remain a major challenge. Developers often resort to workarounds that compromise data quality or require intricate coding solutions.

What if there was a better way? Oracle Edition-Based Redefinition (EBR)—combined with Online Table Reorganization—can seamlessly evolve database schemas without downtime.

In this session, we'll start with the fundamentals of EBR before diving into a real-world case study with ČSOB, a major financial institution from the Czech Republic. You'll hear firsthand how they leveraged EBR to implement zero-downtime schema changes, ensuring business continuity while lowering deployment risks. We'll also demonstrate a live deployment to showcase EBR in action.
Prowadzący
Ludovico Caldara
David Budáč

13:00 - 13:45
Track 1 Lunch break

13:45 - 14:30
Track 1 Path of suffering and hit pattern - CIS Benchmark and hardening for beginners rozwiń opis
This is our project report on the subject of hardening project systems on a Linux basis and with the Oracle database on top. Since it has come to us completely out of the blue, even as "Oracle users" and "Linux users" with many years of experience, we first looked around and wondered what is to be learned in the security environment! It is the story of criminal energies, self-restrictions, risks to be taken, unknown threats, dear habits, external determination, reality, practice, performance, overhead, overview, tools and the question of who is supposed to maintain all this?

Join us on the road which should lead to greater security - but at what cost?
Prowadzący
Axel vom Stein
Track 2 Performance Optimization: How do start rozwiń opis
I face this situation again and again in practice. The beginning is always a hurdle. For me, the point at which I can relax is only reached when I have runtime statistics available for execution plans. Until then, however, it is a journey with several alternative paths.
After 30 years of performance analysis, I do indeed have something of a script in my head that I follow. I would like to show you my first steps and the decision points at which you need to question your approach. Among other things, the following questions will be answered: What tools do I have, what do I use when and where are the pitfalls?
Prowadzący
Lothar Flatz
Track 3 A Brewery Use Case for Data Use Case Domains in Oracle 23ai rozwiń opis
Finally, Domains are available in Oracle! – "Data Use Case Domains” are one of the major SQL enhancements in Oracle 23ai. But what are typical use cases for this new feature? In an extensive live demo, the speaker (and hobby brewer) will show how we can create a data model for a craft beer brewery with different types of domains.
Prowadzący
Dani Schnider

14:45-15:30
Track 1 Upgrade Internals rozwiń opis
Oracle AutoUpgrade has made upgrades so easy that there really is no need to know the inner workings of an Oracle Database upgrade. But we’re techies – and techies are curious and want to tear that black box apart and know about bits and pieces inside.

This session covers how an Oracle Database upgrade works and how the upgrade engine changes the data dictionary. It also explains the newer method called Replay Upgrade (which you might be using already without knowing). Further, the session describes the “lightweight” AWR that is active during an upgrade, where the normal AWR is inactive. This will help us shed some more light on what happens during an upgrade. Finally, the session shows you some advanced features in AutoUpgrade and how you can use them to tweak an upgrade.

If you’ve never upgraded an Oracle Database before you can gain valuable insights from this session. Plus, experienced “upgraders” can learn a few more tricks to put in their toolbox for the next upgrade.
Prowadzący
Daniel Overby Hansen
Track 2 Fighting Bad PL/SQL & SQL with VS Code rozwiń opis
Improving code is like losing weight. First, you need to know what is good and what is bad. You need metrics and appropriate measurement tools to express your goals and achievements. Then you get results as a series of small steps in the right direction.

In PL/SQL and SQL, code complexity can be expressed in lines of code, number of statements, as McCabe's cyclomatic complexity, Halstead's volume, or the maintainability index. Reducing complexity is one way of improving code quality.

However, in this talk I will focus on coding guidelines for PL/SQL and SQL and discuss my favourite guidelines. These guidelines are actually rules and must be followed. Therefore, there is (almost) no room for different interpretations. So, if we violate any of these rules, it means our code is broken. I will show you how you can use the dbLinter extension for Visual Studio Code to find these bugs in your code and fix them manually or even automatically.

By the end of this session, you'll know how to check your code in Visual Studio Code and efficiently eliminate bad code.
Prowadzący
Philipp Salvisberg
Track 3 Agentic Systems: empowering AI to achieve goals rozwiń opis
Everybody already played with an LLM, asking the most random questions and seeing what kind of answer they got. That is precisely what ChatGPT was like at first: an LLM receiving an input and generating an output. All other AI services started like this, just a different LLM model behind the screen.
But, if you look at ChatGPT today, you already see how much it did evolve. You ask a question, and instead of having a generated answer right away, there are extra steps to find the best answer first. For example, it will search online for content to help produce a better answer. That is an example of agentic behavior.

An agentic system is the next big step in AI-powered automation. It combines the reasoning power of LLMs with the ability to take action with several tools. The more tools you provide an agentic system, the more actions it can handle autonomously, without the need for constant human guidance.

You could believe it's incredibly complex to develop an agentic system. Wrong, it's surprisingly simple!
Join me in this session to show you how simple it is to create an agentic system. We start by looking at some examples, then developing one "live" in 45 minutes using Python and an LLM (or a few).
Prowadzący
Gianni Ceresa

15:45-16:30
Track 1 Clustering Factor - almost legendary rozwiń opis
Aka CLUF in the 10053 CBO trace.
...and, let’s be honest, still a bit of a mystery.

I take on the challenge of unraveling the enigma that is the Clustering Factor.
This deep-dive presentation goes beyond the surface, breaking down the internals of CLUF.

"Clustering Factor (CLUF) – The Anatomy and Its Impact on Performance"

Buckle up.
Prowadzący
Piotr Sajda
Track 2 TTT - Total Tuning Theory rozwiń opis
45-minute presentation on the history and practice of Oracle DB tuning – from Oracle parameters and metrics, through AWR, ASH, waits, session analysis, and the full history of SQL queries.
FlameGraph will be presented as an optional visualization tool that helps to more quickly understand complex execution plans.
The goal of the presentation is also to spark a discussion on how to present data in a way that becomes a fishing rod for developers and product definition managers – not just a fish caught in murky waters.
The session will showcase what’s happening inside the database and how it impacts the client’s business.
Prowadzący
Dariusz Polański
Track 3 SQL*Net Encryption & Authentication rozwiń opis
We’ll explore Oracle Native Network Encryption and Transport Layer Security (TLS) settings in Oracle Database, starting with encryption basics and configuration examples for both servers and clients.

Next, we’ll dive into TLS setup, discussing client and server authentication using certificates. We’ll also cover the setup and management of Oracle Wallets required for secure communication.

At this point we’ll already know how to authenticate database clients with certificates, so now we’ll also provide a brief example on how we can authenticate them with Kerberos.

Finally, I’ll present best practices on when and how to use such configurations and what other Oracle Database features, such as proxy users, can be used in conjunction with everything described so far.

This session is relevant for any edition of Oracle Database, including Standard Edition.
Prowadzący
Urh Srečnik

16:45-17:30
Track 1 Search and you shall find. A walk through the Oracle 23ai search landscape rozwiń opis
This presentation will discuss AI Vector Search and the new AI Vector Hybrid Search, along with a few other more classic search techniques.

With recent 23ai additions — AI Vector Search, Hybrid Vector/Text Search and Ubiquitous Search — alongside the classic Text Search and Simple Search, understanding these search options is essential for choosing the right approach when building PL/SQL, APEX, and other Oracle applications.

This session explores the characteristics of each search technique, highlighting their advantages and disadvantages through real-world examples, live demonstrations, and discussions. Attendees will gain insights into the factors to consider when selecting and implementing the search approach that best meets their needs.
Prowadzący
Niall Mc Phillips
Track 2 Diving into TLS/SSL for database professionals rozwiń opis
This presentation addresses the critical use of Transport Layer Security (TLS) for securing network connections in database environments, targeting database developers and DBAs. It will cover essential concepts such as certificates, trust chains, and revocation lists, along with practical guidance on configuring databases for TLS-secured connections. Attendees will learn how to implement secure consumption of TLS-enabled services, obtain certificates, and navigate key concepts like SNI, STARTTLS, mTLS and others.
Prowadzący
Ilmar Kerm
Track 3 Predictions, Plans and Problems rozwiń opis
Interpreting a query block, the basic unit of an execution plan, is simple (for a serial plan, parallel can be a little harder).

Deciding why each query block exists and how Oracle will connect them when a plan has multiple query blocks is harder, but it's a task that becomes much easier if you can predict all (or most) of the ways that the optimizer might choose to transform your query.

Even if you can "join the dots" correctly, though, you may still find that the work done at various points through the plan exceeds your expectation, so you need to be aware of odd edge effects of the optimizer and the fundamental infrastructure of Oracle and know how to diagnose any anomalies.

This presentation will be a traditional "show and tell" (slides and talk) that starts with a fairly short query and pushes the optimizer (and the audience) to the limits of the possible.
Prowadzący
Jonathan Lewis

17:45-18:30
Track 1 Around the World in 80 Dogs: A Rough Guide to the Database Character Set rozwiń opis
Yes, nowadays you can get by just sticking with the default. But this session is for those who want to know a little more.

The default, AL32UTF8—what exactly is it, and why should we use it? Did you know it’s self-synchronizing? Find out what that means and why it’s important. And what about that other character set called UTF8—what’s that, and why shouldn’t we use it? And what’s the deal with the National Character Set?

With the help of furry friends from all over the world—including “dog,” “pies,” “cão,” 狗, “köpek,” “كلب,” 🐶, and 𓃡—we’ll contrast various character sets to compare coverage and efficiency
Prowadzący
Patrick Jolliffe
Track 2 Assertions Creed rozwiń opis
We all use constraints to secure our data integrity, right? Right?
Primary and unique keys to make sure a row is unique in a table. Foreign keys to make sure a row has a matching parent row. Check constraints to make sure data within a row meets certain standards.

The common denominator here is "a row". What about a constraint that extends beyond the borders of a row, to other rows in the table or even in another table or multiple tables?
For example a constraint that will enforce "if a car is leased for an employee (cars table) no options (lease_options table) are allowed that cost more than 5% of the value of the car"

For things like that that you'd have to resort to triggers. And please don't be offended, but there's a high probability you would do it wrong because most people do.

Fear no more. Oracle is the first database vendor who succeeded in implementing a feature from the ANSI standard called Assertions.
Which allows you to enforce such business rules declaratively, like other constraints, and let the database worry about how and when to check it.

This talk will introduce Assertions to you and discuss its benefits and its limitations, some of which are planned to be temporarily.
Prowadzący
Erik van Roon

Koniec

 
Track 1

Koniec

Jak dojechać


Aby skorzystać z map, niezbędne jest wyrażenie zgody na przechowywanie plików cookies powiązanych z usługą Google Maps. Szczegóły: polityka prywatności.

Tak, zgadzam się.

After party


Szczegóły wkrótce

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