POUG2024

11-12 października 2024, Poznań

Agenda



 
Track 1
Track 2

08:00 - 09:00
REGISTRATIONrozwiń opis

09:00 - 09:55
Keynote sessionrozwiń opis

10:00 - 10:45
APEX, ORDS and JRDV - The Three Amigosrozwiń opis
APEX, ORDS and JSON Relational Duality Views (JRDV) are the best things that Oracle has to offer. JRDV gives the flexibility of JSON Documents and the advantages of Relational.
This presentation introduces the concepts of JRDV and how you can use this is a real world scenario.
Lecturer
Alex Nuijten
Oracle Database 23c - What's newrozwiń opis
A presentation (mostly live demos) of some of the new features coming in Oracle Database 23c. Learn about features.
Lecturer
Patrick Barel
Oracle Performance Troubleshooting - real cases rozwiń opis
I would like to present a couple of performance cases and share with the audience my approach how to find the issue and fix it.
The presentation will contain real scenarios.
Lecturer
Bartosz Zielinski

11:00 - 11:45
Big Brother Tracking Videos using APEX & OCI AI Servicesrozwiń opis
You've seen it in the movies and on TV. Big Brother is watching and tracking you. How can they do this? Let us bring you on a journey by building a Picture & Video Monitoring application using APEX and OCI AI Services. Along the way, we will illustrate the good, the bad and the ugly of how to do it.
Lecturer
Brendan Tierney
A Deep Dive View to the Performance of Viewsrozwiń opis
Once upon a time, views (and views on views on views) were one of the main reasons for performance problems in Oracle. Let’s take a look at how the Oracle optimizer has improved over the years and how it deals with views today to make them as fast as possible.
Lecturer
Dani Schnider
Zooming in on macrosrozwiń opis
SQL macros were introduced in Oracle database version 21c. You know, that version really nobody is
actually using. They backported *some* of the functionality to 19c, so you may have table expression
macros available in your daily work already.
But release of 23c is getting closer and when POUG 2024 starts it could very well be generally available,
and with it the full power of SQL macros. So, it's high time to really delve into them.

SQL macros allow us to define bits and pieces of code (expressions/table expressions) that are placed
into the sql statement that references the macro.

Sounds great.
So, let's have a look at what types of SQL macros there are, what they could be used for and the syntax
of creating and using SQL macros. We will also have a look at how they compare to other options we have
to centralize definition of expressions and to make SQL statements more dynamic.
Do we now make everything a SQL macro, or are there reasons not to? What are the limitations of SQL macros?
Join this session to get those questions answered.
Lecturer
Erik van Roon

12:00 - 12:45
A summary of the most useful new SQL features in 23crozwiń opis
Oracle 23c brings in many improvements and new features to SQL language. In this session I'll cover the ones that I find the most useful and the ones that will make your life easier. We'll not cover all the details, but it'll be a good starting point to inspire and present some use-cases.
Lecturer
Andrzej Nowicki
Your listener is wrong and I can prove it!rozwiń opis
In this session I will do a live demo and show how to configure listener parameters properly and together with REMOTE_LISTENER you can have just one entry. And you continue to have RAC, TAF, DG, and all HA features. I will not use CMAN and just free Oracle solutions. Few slides, full demo.
Lecturer
Fernando Simon
No more witch's brew: simplify database security management with Oracle 23crozwiń opis
In this 95% live demo session, explore how Oracle 23c raises the bar in terms of security.
Simplify privilege management with Schema Privileges, Read-Only users, and Hybrid Read-Only PDBs. Explore audit policies on individual columns. Examine the powerful SQL Firewall and its OCI integration.
Lecturer
Flora Barriele

13:00 - 14:00
LUNCHrozwiń opis

14:00 - 14:45
Isolation Levels and MVCC in SQL Databases: A Technical Comparative Studyrozwiń opis
All databases behave differently regarding isolation levels, and all have their dark side (Oracle infamous ORA-1555, PostgreSQL craving for vacuum, SQL Server NOLOCK insanity, MySQL InnoDB dubious repeatable reads)
Lecturer
Franck Pachot
Analytics in 2024 can hurt your database in new, unexpected, waysrozwiń opis
Analytics nowadays is different from BI 10 years ago and even more than reporting 20+ years ago.
The modern trends have a different impact on your server, and also on the DBA job because users do different things with databases compared to the past. An overview of the impact of the new trends.
Lecturer
Gianni Ceresa
3 problems - 3 strategiesrozwiń opis
Taking a high-level view there are only three reasons why you may be called to address a performance problem.

A specific task takes too long to complete
A "batch" process recently over-ran its SLA
"The system" is too slow

The fastest solution starts by picking the strategy that suits the problem.
Lecturer
Jonathan Lewis

15:00 - 15:45
Using good friends — Prometheus and Grafana — to monitor Oracle databaserozwiń opis
There is many ways to monitor an Oracle database and I would like to present how to add a database monitoring to the existing monitoring stack based on the Prometheus and Grafana.
Lecturer
Marcin Przepiorowski
5 Tips for Being a Top Expertrozwiń opis
British people like myself find it very hard to say “I am good at what I do”, and almost impossible to say “I am very good at what I do”. Now that I am retired, I can at long last say “I was very, very good at what I did”.
I can’t promise I can tell you how to be as awesome as I was, but I think I can tell you how to be better than you are at the moment. And hopefully have a laugh along the way. It’s got to be worth an hour of your time, hasn’t it? And you must be tired of all the tech talk by now!
Beer is recommended for this talk.
I might sneak in some tech...
Lecturer
Martin Widlake
Migrating the Beast - 180TB size, 15TB redo per day, and data types from outer spacerozwiń opis
Want to see the most challenging migration our team has ever been with? Then this is for you. Exotic data types? Tons of redo? Five standbys, some of them in 2500km distance? And of course, moving from Big to Little Endianness.
Lecturer
Mike Dietrich

16:00 - 16:45
The Big Bang Theoryrozwiń opis
In the beginning, there was nothing, which exploded.
Oracle started to extend, ushering in a new era. Initially, simple literals began to take shape. With the expansion of Oracle and the increase in the complexity of the Database World grew, new, more advanced forms of features emerged- :bind variables. Although invisible, sometimes we can subtly peek at them. These mysterious creatures play a crucial role in system performance. Over time, they evolve into more intelligent forms and significantly impact cardinality calculations, parsing process and cursor sharing functionality. Without them, we would live in a Hard Parse World with great parsing overhead!
:Bind variables are fearful and unpredictable, easy to misunderstand. Knowing them is essential for optimizing database performance.
Let’s trace for :bind variables and try to understand their habits and essential contributions to the ecosystem of the Database World: advance cursor sharing, statistics, histogram, cardinality calculations, parsing and more.
Maybe you'll discover things that will surprise you!
It’s POUG - let’s DEMO!
Lecturer
Monika Lewandowska
Oracle Transactions - more than meets the eyerozwiń opis
Explaining the details of Oracle transaction internals, with all of the horrors of block dumps.
Lecturer
Neil Chandler
What's Our Vector, Victor? Navigating AI Vector Searches in Oracle 23crozwiń opis
Demystifying AI Vector Search in the Oracle database. What are vectors?

Prepare, generate and embed. New search operators and functions. Examples.

Vector distances + measurement methods. Similarity searches

Integrate with PL/SQL and APEX applications.
Lecturer
Niall Mc Phillips

17:00 - 17:45
Avoid PTSD with Flashbackrozwiń opis
If your work as a DBA, developer, test leader, or CIO frequently causes you a lot of stress, Flashback in the database may be for you. Learn how to be ready for accidents, unusual data changes, testing, and compliance with variations of Flashback technology in the Oracle database.
Lecturer
Øyvind Isene
Journey to the Unknown - Everything about NULL in the Oracle Databaserozwiń opis
Come learn about (or review your knowledge of) this fundamental (and controversial) concept in relational database design.
When (and why) did it come about? What exactly it is? How best to deal with in the Oracle Database as developer or DBA.
Lecturer
Patrick Jolliffe
distributed databases, what to expect.rozwiń opis
The next trend (hype?) is : Clustered, serverless, distributed, sharded, replicated, databases.
A lot of buzzwords, and I have omitted “multi-cloud”, “raft” and “vector”.
We’ll try to find out how various vendors interpret those (buzz)words and how/when these are useful.
Lecturer
Piet de Visser

Koniec

 
Track 1
Track 2

09:00 - 09:45
Sponsor's sessionrozwiń opis
Sponsor's sessionrozwiń opis
Sponsor's sessionrozwiń opis

10:00 - 10:45
Simplifying DevOps with APEX and Autonomous Databaserozwiń opis
Lecturer
Piotr Kurzynoga
Estimate the boost'able areas of your SQLrozwiń opis
Example of SQL profiling accompanied by primary school level math.
TEMP, Flash, ASH, SQL and battle with time.
How much time can you gain when you change your SQL *without* even running it?
Lecturer
Piotr Sajda
Harry Potter and the Deathly SQL Injectionsrozwiń opis
We all love the Harry Potter. If Oracle database was Hogwarts, will Harry Potter be able to protect Hogwarts and his wizard friends from the attacks of “The Dark Lords”? Join me in this session where I will discuss what is meant by SQL Injection. Through simple examples, I will explain First Order, Second Order and Lateral Attacks and how the hackers can exploit vulnerabilities introduced through bad coding practices, to break into the Oracle database. Finally, I will discuss some considerations that a developer should keep in mind while developing Oracle PL/SQL code, to make their code SQL Injection proof. Audience will need to have a basic understanding about Oracle SQL and PL/SQL.
Lecturer
Rishin Mitra

11:00 - 11:45
APEX CI/CD from the trenchesrozwiń opis
Learn how we set up a development and deployment process using SQLcl, Liquibase and GitLab that doesn't slow down your development speed.
Lecturer
Roel Hartman
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
High Availability and Disaster Recovery with Oracle Database@Azurerozwiń opis
Running Azure's applications and need Oracle Exadata, Oracle RAC, and Data Guard for the best high availability and disaster recovery for your mission-critical workloads inside Azure's data centers? Oracle Database@Azure makes it possible. Including simplified operation tasks via Cloud Automation.
Lecturer
Sinan Petrus Toma

12:00 - 12:45
ORDS in depthrozwiń opis
The Oracle Rest API has been there for some years and gets new releases frequently.
In addition to the possibility to create your own endpoints, you can also use the db-api endpoints.
These are used for DBA Tasks like creating a new CDB or adding a new PDB but it can also be used to get performance information out of the database (e.g. ASH information).
But what is Oracle doing under the hood? What needs to be considered while using these APIs?
Lecturer
Julian Frey
Let's trace it! Peeking into the inner workings of Oracle with bpftrace.rozwiń opis
Troubleshooting and analyzing complex problem scenarios requires the use of appropriate tools. While modern BPF based tracing tools have gained a lot of traction in many areas, they haven't been widely adopted by Oracle DBAs yet.

This presentation aims to fill that gap by demonstrating how to leverage bpftrace to peek into the inner mechanics of Oracle.

Using dynamic instrumentation, we will look at how to probe Oracle kernel functions and study introspection techniques to directly read internal data structures from the Oracle SGA to observe and examine session level activity, wait events and latches.
Lecturer
Christoph Lutz
Let’s GO!rozwiń opis
Everything you need to know to start programming in Golang! This talk introduces Golang, its features, and explains why a compiled language is superior to a scripted language for automation.

Golang gained a lot of popularity in operations in recent years. A fast, compiled language similar to C simply allows programming new functionalities. This talk explains everything you need to know for starting programming in Go. It introduces Golang and its features and walks through how to program a REST endpoint accessing data. After a language introduction, you’ll get to know Golang during a live-coding session. You’ll learn how to write tests for Golang and how to make your application maintainable and observable.
Lecturer
Jasmin Fluri

13:00 - 14:00
LUNCHrozwiń opis

14:00 - 14:45
Automated monitoring of Data Guard Fast-Start failoverrozwiń opis
In this presentation we look at different metrics and data sources that are essential for making sure that databases in Data Guard FSFO configuration are healthy and able to take on the traffic from the client applications in case of problems - with the end goal of automation and alerting in mind.
Lecturer
Ilmar Kerm
What hackers 😇 can do to your Oracle Database if you don't patchrozwiń opis
This 100% live demo session will put you in the mind of Kamil's friends and show a real-world attack scenario, from the moment a cybercriminal enters your Oracle database server until he dominates all your company's data systems.
In this session, I will show different attack vectors, and vulnerabilities exploit that a hacker will use to explore database systems' weaknesses and how we could protect from each. This is a dynamic session, and the attendees will vote on which way the attack will be performed.
Lecturer
Rodrigo Jorge
Roam with the Beast: Let the Oracle Cost-Based Optimizer run!rozwiń opis
In this presentation, we delve into the heart of Oracle Database's Cost-Based Optimizer (CBO), and explore why allowing it to roam freely leads to optimal long-term query performance.

Discover why the key to unlocking the CBO's potential lies not in restraining it with hints or profiles but in empowering it with a wealth of knowledge. We'll explore the art of crafting strategic indexes, harnessing the power of statistics, and other ingenious meta-information techniques to guide the CBO's decision-making process. Learn how to keep the optimizer dynamic and responsive, adapting to evolving data landscapes without sacrificing performance.

Buckle up as we deal with 10 operations having a reputation of being "bad" or "slow" – from Hash Joins to Table Access Full – that might sound like performance pitfalls. But, in truth, they can be powerful allies when orchestrated under the right circumstances.

Join us on a journey where seemingly bad choices transform into performance triumphs, demonstrating that in the realm of Oracle optimization, knowledge is power, and the true mastery lies in understanding and supporting the CBO rather than attempting to control its every move. Rule less, optimize more!
Lecturer
Martin Klier

15:00 - 15:45
rozwiń opis

16:00 - 16:45
rozwiń opis

Koniec

Jak dojechać


Concordia Design

Website

After party


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.