POUG2024

11-12 października 2024, Poznań

Agenda



 
Track 1
Track 2
Track 3

08:00 - 09:00
Track 1 REGISTRATION

09:00 - 09:55
Track 1 Keynote session

10:00 - 10:45
Track 1 APEX, ORDS and JRDV - The Three Amigos rozwiń 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.
Prowadzący
Alex Nuijten
Roel Hartman
Track 2 Oracle Database 23c - What's new rozwiń opis
A presentation (mostly live demos) of some of the new features coming in Oracle Database 23c. Learn about features.
Prowadzący
Patrick Barel
Track 3 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.
Prowadzący
Bartosz Zielinski

11:00 - 11:45
Track 1 Big Brother Tracking Videos using APEX & OCI AI Services rozwiń 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.
Prowadzący
Brendan Tierney
Track 2 A Deep Dive View to the Performance of Views rozwiń 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.
Prowadzący
Dani Schnider
Track 3 Zooming in on macros rozwiń 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.
Prowadzący
Erik van Roon

12:00 - 12:45
Track 1 A summary of the most useful new SQL features in 23c rozwiń 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.
Prowadzący
Andrzej Nowicki
Track 2 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.
Prowadzący
Fernando Simon
Track 3 No more witch's brew: simplify database security management with Oracle 23c rozwiń 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.
Prowadzący
Flora Barriele

13:00 - 14:00
Track 1 LUNCH

14:00 - 14:45
Track 1 Isolation Levels and MVCC in SQL Databases: A Technical Comparative Study rozwiń 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)
Prowadzący
Franck Pachot
Track 2 Analytics in 2024 can hurt your database in new, unexpected, ways rozwiń 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.
Prowadzący
Gianni Ceresa
Track 3 3 problems - 3 strategies rozwiń 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.
Prowadzący
Jonathan Lewis

15:00 - 15:45
Track 1 Using good friends — Prometheus and Grafana — to monitor Oracle database rozwiń 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.
Prowadzący
Marcin Przepiorowski
Track 2 5 Tips for Being a Top Expert rozwiń 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...
Prowadzący
Martin Widlake
Track 3 Migrating the Beast - 180TB size, 15TB redo per day, and data types from outer space rozwiń 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.
Prowadzący
Mike Dietrich

16:00 - 16:45
Track 1 The Big Bind Theory rozwiń 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!
Prowadzący
Monika Lewandowska
Track 2 Oracle Transactions - more than meets the eye rozwiń opis
Explaining the details of Oracle transaction internals, with all of the horrors of block dumps.
Prowadzący
Neil Chandler
Track 3 What's Our Vector, Victor? Navigating AI Vector Searches in Oracle 23c rozwiń 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.
Prowadzący
Niall Mc Phillips

17:00 - 17:45
Track 1 Avoid PTSD with Flashback rozwiń 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.
Prowadzący
Øyvind Isene
Track 2 Journey to the Unknown - Everything about NULL in the Oracle Database rozwiń 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.
Prowadzący
Patrick Jolliffe
Track 3 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.
Prowadzący
Piet de Visser

Koniec

 
Track 1
Track 2
Track 3

09:00 - 09:45
Track 1 Sponsor's session
Track 2 Sponsor's session
Track 3 Sponsor's session

10:00 - 10:45
Track 1 Simplifying DevOps with APEX and Autonomous Database
Prowadzący
Piotr Kurzynoga
Track 2 Estimate the boost'able areas of your SQL rozwiń 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?
Prowadzący
Piotr Sajda
Track 3 23ai - Zero Slides, Zero PowerPoint, Zero Marketing, 100% Live Demo! rozwiń opis
Perhaps for the first time in its history, Oracle built a database with the core focus being a simpler, better, easier to use database for DBAs and Developers. Oracle Database 23c is packed with these small but critical enhancements that everyone should be made aware of.
Prowadzący
Connor McDonald

11:00 - 11:45
Track 1 Continuous Integration and (CI/CD) for the Oracle Database Developer rozwiń opis
Learn how we set up a development and deployment process using SQLcl, Liquibase and GitLab that doesn't slow down your development speed.
Prowadzący
Roel Hartman
Track 2 Guardians of the Data - Protecting Oracle Backups from Ransomware and Malicious Intent rozwiń 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
Track 3 High Availability and Disaster Recovery with Oracle Database@Azure rozwiń 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.
Prowadzący
Sinan Petrus Toma

12:00 - 12:45
Track 1 ORDS in depth rozwiń 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?
Prowadzący
Julian Frey
Track 2 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.
Prowadzący
Christoph Lutz
Track 3 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.
Prowadzący
Jasmin Fluri

13:00 - 14:00
Track 1 LUNCH

14:00 - 14:45
Track 1 Automated monitoring of Data Guard Fast-Start failover rozwiń 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.
Prowadzący
Ilmar Kerm
Track 2 What hackers 😇 can do to your Oracle Database if you don't patch rozwiń 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.
Prowadzący
Rodrigo Jorge
Track 3 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!
Prowadzący
Martin Klier

15:00 - 15:45
Track 1 Streamlined Analytics: Maximizing Oracle Database for In-Place Processing rozwiń opis
Maximize Oracle Database to cut data movement between OLTP and OLAP/DW. Use Materialized Views, In-Memory Store, and more to reduce network traffic, lower processing needs, and decrease data redundancy. Enhance efficiency and cut costs with streamlined, integrated analytics.
Prowadzący
Franky Weber Faust
Track 2 Advanced JavaScript in Oracle Database 23c rozwiń opis
Introducing JavaScript in Oracle Database 23c offers developers more choices in writing server-side code.
This talk introduces advanced use cases for In-Database JavaScript, including performance instrumentation, community modules, REST calls & the fetch API, and post-execution debugging.
Prowadzący
Martin Bach
Track 3 DBMS/Utility-Packages - Explore the possibilities! rozwiń opis
An overview and classification of the PL/SQL-Packages which you will not get from Oracle. Understand what extended features you can use with PL/SQL-Packages and see the use of mostly unknown PL/SQL-Packages in some selected examples.

When using the Oracle Database you get a bunch of PL/SQL-Packages for free. This includes the DBMS_ and also several other Utility-Packages. All these PL/SQL-Packages add extra functionality to the Oracle Database. Some of the extended features can’t be used without knowledge of these PL/SQL-Packages. The extensions and PL/SQL-Packages are not only for Developers, even Database Administrators should have interests in them. This presentation gives a rough survey of the PL/SQL-Packages, categorizes them and some selected examples will be pointed out. The presentation is aimed at PL/SQL user more or less independent of their respective job roles (Developer, DBA).
Prowadzący
Axel vom Stein

16:00 - 16:45
Track 1 TBC
Track 2 TBC
Track 3 TBC

Koniec

Jak dojechać


Concordia Design

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