POUG 2025
Poznań, September 5th-6th

 

 

WHY POUG?

Ticket price includes


  • 2 days
    of sessions

    No marketing or sales, just tech knowlegde. Yep, we're one of a kind;)

  • FOOD & DRINK
    covered

    Lunches and coffee breaks

  • AFTER PARTY
    with an open bar;)

    Integration with games & networking

  • BEER
    no limits

    Yes, we serve beer at the POUG conferences, but we can behave properly at the same time!

  • 40+ recordings
    from sessions

    One year access to presentations and recordings from our talks

  • LIFETIME
    POUG ticket

    This year you can win a lifetime free POUG ticket!

  • COMMUNITY
    like no other

    Meet the most famous Oracle experts in person and discuss with them!

Agenda



 
Track 1
Track 2
Track 3
Lab Track

08:00 - 09:00
Track 1 Registration

09:00 - 09:55
Track 1 Opening + Keynote session: 23ai - What's New, What's Next expand description
Join us for this overview session as we explore what’s new for Oracle 23ai and what’s next on the roadmap beyond 23ai.
Lecturer
Connor McDonald

10:00 - 10:45
Track 1 A Brewery Use Case for Data Use Case Domains in Oracle 23ai expand description
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.
Lecturer
Dani Schnider
Track 2 Based on a true story: The APEX Chain Saw Massacre! All the ways your project can go wrong expand description
For several years I have been working on APEX applications that were worked on by 1 to 10 developers. Everyone has a different level of knowledge and experience.

But why am I telling you this? Because this presentation is not only my experience but also thousands of hours worked for clients from many industries: pharmacy, telecommunications, logistics, banking, and aviation.

And with the courtesy of my colleagues from work and my own experience also, I have collected a few interesting examples: sometimes funny, sometimes tragic, but as a warning and learning for others.

Anyone at this time may have a weaker day. This presentation includes cases of those bad days when the author let his imagination run wild!

The big question is: can we learn anything from these mistakes?

Warning: some of them cannot be unseen! To keep anonymity, all names and some details have been changed :)
Lecturer
Dominik Grabiński
Track 3 Around the World in 80 Dogs: A Rough Guide to the Database Character Set expand description
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
Lecturer
Patrick Jolliffe
Lab Track 10:00-11:30 SQL Macro or PL/SQL Function? Do I care? Can I let the transpiler deal with it? expand description
For decades it's been good practice not to repeat identical code all over. In SQL the normal way to achieve this has always been to write a PL/SQL function and call it from your SQL statements. Is this always a good idea? Do we have alternatives now? Yes, you can for example use SQL macros to let your reusable code become a part of your SQL, avoiding the impact of using PL/SQL. But do you have to worry about when it's possible to use a macro instead of a function? Not always. The SQL transpiler in Oracle Database 23ai can detect possibilities of embedding your function code in SQL like a macro. Learn about the issues with function calls from SQL and the pros and cons of alleviating these with SQL macros and/or SQL transpiler.
Lecturer
Kim Berg Hansen
Chris Saxon

11:00 - 11:45
Track 1 A Day in the Life of a Real-World Performance Engineer expand description
How does a real-world performance engineer interpret an Automatic Workload Repository or SQL Monitor Report? What do they look for, where do they focus their time and effort to get the best returns for the least effort? In this session learn about the common performance mistakes seen in the field and their impact on system performance, stability, and capacity. If you want to shrink your cloud footprint this session is for you.
Lecturer
Ivica Arsov
Track 2 AI's Sweet Tooth: A RAG Journey Through Uruguay's Best Alfajores de Dulce de Leche expand description
This presentation showcases how to build a Retrieval-Augmented Generation (RAG) application from scratch, designed to answer all your questions about Uruguay's most cherished sweet treat—the alfajor de dulce de leche. Leveraging Oracle AI Vector Search for efficient and accurate information retrieval and Oracle Generative AI for natural language understanding and response generation, we bridge the gap between advanced technology and culinary tradition. This session will include live demos, providing an interactive experience to see this solution in action.
Lecturer
Edelweiss Kammermann
Track 3 A deep dive into database I/O operations: are they keeping up with the kernel's pace? expand description
Database I/O may be considered a boring topic until your queries slow down to a crawl. Ultimately, it all begins with a read from "disk." Therefore, understanding how a database kernel interacts with the operating system, diagnosing bottlenecks, and understanding the I/O architecture can quickly become much-needed skills in tense situations.
Databases have evolved, as have operating systems. Much research went into Linux, undoubtedly one of the most advanced operating systems today. Let's look at various database engines and see how they interact with the O/S to perform I/O operations in nerd-level granularity. Do they keep up with the kernel developers' pace? How accessible is your troubleshooting data? Are there any tunable parameters to tweak? Come and find out in this session!
Lecturer
Martin Bach

12:00 - 12:45
Track 1 Clustering Factor - almost legendary expand description
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.
Lecturer
Piotr Sajda
Track 2 Assertions Creed expand description
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.
Lecturer
Erik van Roon
Track 3 Diving into TLS/SSL for database professionals expand description
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.
Lecturer
Ilmar Kerm

13:00 - 13:45
Track 1 Lunch

13:45 - 14:30
Track 1 DBAs in Action: Real-World Oracle Stories from the Frontline expand description
In a world where the DBA role has been repeatedly predicted to vanish, our experience tells a different story. This session brings insights from supporting hundreds of customers and managing thousands of databases across on-premises, cloud, and managed services environments. We will explore real-world case studies from the past year that underscore how seasoned DBAs remain pivotal in solving complex challenges.

Attendees will hear detailed accounts of scenarios, including on-call emergencies and planned work, such as:

- Performance incidents: on RAC, Exadata, and cloud services
- Datacenter migrations: simple and complex approaches
- Deployment automation: several flavors of automation challenges
- Recovering services from failures

Each case study illustrates technical expertise and strategic thinking that is still relevant in an era dominated by automated tools and self-service platforms.

Join me to see examples that challenge the narrative and demonstrate the enduring value of database specialists, and learn a few interesting solutions to problems we solved recently.
Lecturer
Nelson Calero
Track 2 Agentic Systems: empowering AI to achieve goals expand description
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).
Lecturer
Gianni Ceresa
Track 3 Enterprise Manager 24ai is it the big shot? expand description
What changed to EM13.5? What is new? Where or what is ai in this product?
EM24ai is available since last year and I was able to get some impressions and some production experience with the latest release.
If you ever wanted to know why you should move to EM24ai, you have to attend this session and probably and only probably you will know after.
Lecturer
Julian Frey
Lab Track 13:45-15:15 Monitoring Oracle DBs - the current tools landscape expand description
What are some good options for the Oracle DB monitoring these days? In this slightly opinionated LAB, I want to explore what are some good modern options to monitor your databases (or fleet of them). We'll consider different approaches to monitoring and play around with some of the best tools for the job. We'll dive into: - OEM 24ai - what's good actually about it, using emcli to automate most of it - Grafana (with different backends and oracle's node_exporter) - some good practical use cases - ELK stack - the king of log analysis for all your databases - I'll share the techniques I use to analyze Oracle's logs at large scale and other cool tricks for data analysis - analyzing Oracle logs with local LLMs - a feasible approach - my own monitoring framework - opinionated portable PL/SQL framework to measure, record and analyze metrics in databases you don't have direct access to
Lecturer
David Budáč

14:45-15:30
Track 1 Even more 23ai, Even fewer slides and powerpoint expand description
Last year’s 100% demo session is back again this year with a brand-new array of amazing Oracle Database 23ai features. Forget about Microsoft PowerPoint decks with dull speaker biographies, long-winded historical backgrounds, and silly memes, and get ready for a session that is 100% demo using the database tools you know and love. This is an opportunity to take your ability to build world-class applications and database management to the next level with Oracle Database 23ai.
Lecturer
Connor McDonald
Track 2 Fighting Bad PL/SQL & SQL with VS Code expand description
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.
Lecturer
Philipp Salvisberg
Track 3 Finding a Needle in a Haystack with Oracle Analytics and Vector Search expand description
Join 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!
Lecturer
Sylwester Deć

15:45-16:30
Track 1 Network Latency - important factor when considering migration to OCI/ADB expand description
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
Lecturer
Dawid Welder
Martin Berger
Track 2 Vector, Vector, Everywhere: Making Your Oracle Database Think Smarter (and Sassier!) expand description
Ready to give your Oracle database a brain upgrade? This session will demystify vector embeddings, showing you why this transformative tech is a game-changer for your data. We’ll get hands-on, demonstrating how to generate and load vectors into your Oracle Database using models from Oracle Cloud, Google Cloud, and even locally on GKE/OKE. How are vector’s used in similarity search ? Get ready to make your data smarter, faster, and way more insightful! Prepare to unlock a whole new dimension of data intelligence – no fancy spells required!
Lecturer
Kiran Tailor
Track 3 How should we design a database? You decide! expand description
When creating database tables there are many decisions you need to make. For example, should you use:

Surrogate or natural primary keys?
Enums or lookup tables for status codes?
Store or calculate derived values?

Each choice affects the table structure and the queries you'll write to fetch data.

Join this interactive session to see how these decisions affect your schema. Vote for your preferred option for each choice while we'll discuss their trade-offs. We'll then create the tables using the most popular answer to each question.

What will the final schema look like?

You decide!
Lecturer
Chris Saxon
Lab Track 15:45-17:15 Chattiness for DBAs and other slow systems. expand description
Because most IT manangers want to deploy “to the cloud” the amount of round trips and the time of the round-trips has become a serious issue. Those of you who had “providers” moving systems between datacentres without notice may already have experienced this 15yrs ago… (yep) Because “Numbers Tell the Tale”, and you may have to “expose chattiness”, we’ll take a look at chatty systems and try to quantify it using available tooling in Oracle (and maybe pg). Followed by some hints and tips to tackle “the latency problem” if you enmcounter it. note: this presentation will not dispute the speed of light, and no tachyons will be used at any time. NOTE: Very Tentative topic ATM! I'm making this one up as I go, based on a question and some bad experiences long time ago.
Lecturer
Piet de Visser

16:45-17:30
Track 1 How to completely botch your Database Migrations to OCI (and maybe how to avoid it) expand description
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.
Lecturer
Flora Barriele
Track 2 I saw that code and I cried… from laughing expand description
Remember a little red riding hood? She went rouge! Data leaks, sun is shining and the world burns. Let’s see live demo with the worst code you’ve ever seen in your life!
Lecturer
Sabine Heimsath
Track 3 Light Speed V2: Impacts of Latency on Cloud Architectures expand description
When talking about moving to the cloud, most vendors brag about IOPS, throughput, or raw compute power. Let's take a look at one of the harder problem to assess and solve - network latency. We'll talk about why it's important, some methods to assess network latency in the cloud, and ways that it may bite you in the a** if you're not paying attention.
Lecturer
Andy Colvin

17:45-18:30
Track 1 MongoDB API: Getting Developers to Love the Database Again expand description
MongoDB has become popular among developers due to its ease of use compared to SQL. Many SQL databases have also introduced a MongoDB API layer, including Oracle Database with OSON, FerretDB for PostgreSQL, MariaDB with MaxScale, and SAP HANA.
In this session, we will demonstrate how using a MongoDB API enhances the developer experience for building modern applications compared to using SQL. We'll also cover fundamental concepts to help us better understand the developer's perspective.
Additionally, we will explore some of the deeper internals, comparing how MongoDB functionality is emulated in SQL tables within Oracle Database versus how it is executed natively in MongoDB with WiredTiger.
Lecturer
Franck Pachot
Track 2 Listen Deeply, Build with Purpose: Transforming Tech Teams expand description
Game-changing teams aren’t born—they’re built. In this session, we’ll explore what it takes to lead tech teams that don’t just meet deadlines—they innovate, grow, and thrive. Drawing from my experience leading diverse teams and transitioning into tech, I’ll share actionable strategies to build trust, foster collaboration, and deliver meaningful results. This isn’t a buzzword-filled leadership talk—it’s about real, practical shifts that drive success. We’ll uncover what truly sparks innovation and how listening, understanding, and intentional action can transform a team. If you’re ready to rethink leadership and build a team that truly works, this is where it starts.
Lecturer
Tinatin Balavadze
Track 3 Remember remember the 5th of September - fucking memory problems expand description
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.
Lecturer
Neil Chandler

End

 
Track 1
Track 2
Track 3
Lab Track

9:00-9:45
Track 1 Oracle's SQLcl CI/CD bombshell: It will forever change your APEX & Database deployments expand description
A new SQLcl feature just dropped, and I’ll provide an honest, developer-focused review. You will see how the new "project" command simplifies the APEX & Oracle Database CI/CD process by enabling seamless management of database objects in GIT, generating Liquibase changelogs, creating deployable artifacts, and executing deployments in target environments. You’ll gain practical insights and best practices for using this feature, enhancing your development workflows effectively.
Lecturer
Rafał Grzegorczyk
Track 2 Supercharge MySQL capabilities with Javascript! expand description
Learn about one of the newest MySQL functionality: native Javascript code execution on the database!
MySQL-JavaScript unlocks new opportunities in application design that were once constrained by a trade-off. JavaScript stored programs empower developers to sidestep data movement and seamlessly implement advanced data processing logic inside the database with ease.
Therefore, now it is possible to open up, with low effort, to new use cases such as data transformation, data validation, and much more...
In this talk you will learn about the fundamentals of the Javascript implementation within MySQL, with example which will allow you to start off coding really quick!
Lecturer
Vittorio Cioe'
Track 3 TBC

10:00-10:45
Track 1 Oh No, There’s a Hacker Living in My Database expand description
In this live demo session, we’ll demonstrate how attackers can deploy malware within Oracle databases, hidden under PL/SQL code, triggers, or even internal SYS objects, without immediately raising suspicion. We’ll show how these unauthorized modifications can go unnoticed by traditional security measures. Using Oracle's ORAdiff tool, we’ll show how to perform rapid scans to detect these hidden threats by comparing database schemas, identifying unexpected changes, and flagging potentially malicious alterations.
Lecturer
Rodrigo Jorge
Track 2 Online Schema Changes: Real-world Experience with Edition-Based Redefinition expand description
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.
Lecturer
David Budáč
Ludovico Caldara
Track 3 OpenTelemetry and Databases: The New Era of Monitoring expand description
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.
Lecturer
Jasmin Fluri

11:00-11:45
Track 1 The Love and No Love with Oracle Performance Tools expand description
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.
Lecturer
Timur Akhmadeev
Track 2 Performance Grand Prix – Who Will Win the Race? expand description
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!
Lecturer
Monika Lewandowska
Track 3 Typical misstakes of the optimizer and how to recognize them expand description
The optimizer should generate an efficient execution plan for all syntactically correct queries in a fraction of a second. It is quite normal that the developers of the optimizer code had to make compromises.
There are situations in which the Optimizer repeatedly fails. Knowing these saves time in error diagnosis and rectification.
Over the course of time, I have developed catchy names for classic error situations that make it easier for me to classify Optimizer errors. I am happy to pass on this system.
We learn to recognize, classify and correct classic error situations by looking at the runtime statistics.
Lecturer
Lothar Flatz

12:00-12:45
Track 1 Predictions, Plans and Problems expand description
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.
Lecturer
Jonathan Lewis
Track 2 Fuck that PL/SQL - Im going Java Script expand description
Le me code something useful using MLE. The performance might be shit… but I will do it anyway.
Lecturer
Øyvind Isene
Track 3 AI based SQL code conversion
Lecturer
Kerry Osborne

13:00-13:45
Track 1 Lunch

13:45-14:30
Track 1 Too much it is too bad!!! expand description
Let's troubleshoot why having too much CPU can be a bad thing when you have too many tables and partitions. And became worst when one bug happens and the problem explodes exponentially.

It will be a live session about how the concurrent stats collection works, the internal scheduler jobs, the problem that happens when you have too much CPU, and why/how one bug the in resource manager will not allow the correct management. But I will show how to bypass the bug using the resource manager too.

What do you expect at POUG? Just the good stuff, right? So, I will show end to end. From the root cause until how to use concurrent stats collection in a system with too many tables and cpu's. And having everything under proper resource manager control with no starvation and no bad wait events.
Lecturer
Fernando Simon
Track 2 TBC
Track 3 SQL*Net Encryption & Authentication expand description
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.
Lecturer
Urh Srečnik
Lab Track 13:45-15:15 Sheldon Cooper learns about JSON in Oracle Database 23ai expand description
In modern application development, JSON is becoming the de-facto standard for storing and transmitting data. However, we can’t define relationships between the JSON documents themselves. JSON Relational Duality View addresses this problem. It gives the best of both worlds. It exposes data stored in relational database tables as JSON documents. We all love Sheldon Cooper from “The Big Bang Theory". We know that he is reluctant to any change. Join me in this session where LEONARD, PENNY, RAJ, HOWARD, AMY and BERNADETTE discuss several enhancements in the JSON functionality in Oracle Database 23ai. Through simple use-cases, they will try to persuade SHELDON to use JSON Relational-Duality View, a key addition in Oracle Database 23ai. Sheldon will learn to leverage the best of both relational and document data models. They will discuss JSON Schema, how to validate a JSON, JSON Data Type Constructors and other cool new enhancements of JSON in Oracle Database 23ai. Will Sheldon be convinced? Audience will need to have a basic understanding about Oracle SQL.
Lecturer
Rishin Mitra

14:45-15:30
Track 1 Path of suffering and hit pattern - CIS Benchmark and hardening for beginners expand description
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?
Lecturer
Axel vom Stein
Track 2 Search and you shall find. A walk through the Oracle 23ai search landscape expand description
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.
Lecturer
Niall Mc Phillips
Track 3 Upgrade Internals expand description
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.
Lecturer
Daniel Overby Hansen

15:45-16:30
Track 1 TTT - Totalna Teoria Tuningu expand description
45-minutowa prezentacja o historii i praktyce tuningu Oracle DB – od parametrów i metryk oraclowych, przez AWR, ASH, waity, analizy sesji oraz pełną historię zapytań SQL.
FlameGraph jako dodatkowa opcja wizualizacji, która pozwala szybciej zrozumieć złożone plany wykonania.
Celem prezentacji jest także dyskusja o tym, jak przekazywać dane w sposób, który staje się dla developerów i product definition managerów wędką – a nie tylko rybą łowioną w mętnej wodzie.
Pokazanie tego, co dzieje się w bazie i jaki ma to wpływ na biznes klienta.
Lecturer
Dariusz Polański
Track 2 SELECT AI: How to query your data using natural language expand description
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.
Lecturer
Andrzej Nowicki
Track 3 Write Consistency Internals. A Technical Deep Dive. expand description
In this session, we will take an in-depth look at write consistency in the Oracle database.

We will examine the internal mechanics of how the Oracle engine maintains consistency while handling conflicting transactions on a table and explore fascinating edge cases where write consistency behaves in surprising ways.

Due to limited instrumentation, write consistency remains a dark corner of the Oracle database. Therefore, this session will also demonstrate how to trace and observe it in real-time using BPF.
Lecturer
Christoph Lutz

End

How to get there


To use the maps, it is necessary to consent to the storage of cookies related to the Google Maps service. Details: privacy policy.

Yes, I agree

Concordia Design

Zwierzyniecka 3
Website

After party


Hades Pool Bilard & Karaoke Club

Święty Marcin 80/82 61-809 Poznan

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.