en pl

POUG 2019

Agenda

Dzień 1 Dzień 2
 
Track 1
Track 2
Track 3
8:00-9:00
Track 1 Rejestracja
9:00-9:15
Track 1 Otwarcie konferencji
9:15-10:00
Track 1 Getting more Adaptive in Optimization rozwiń opis
In each version optimizer becomes smarter and smarter.
Since 12C it can change its mind on the fly. But how does it do it?
What features help him to choose the best plan?

All you wanted to know about Adaptive Query Optimization in 12c/18c in one short session, with lots of examples and sence of humour 
Join us and start the adventure!
Prowadzący
Olena Vorovchenko
Track 2 Oracle Database Advanced Security rozwiń opis
Usually people and companies don’t care about security (or securing their systems) until the day they got attacked or have their private data leaked. The idea of this session is to show how we are vulnerable to attackers and the ways they use to get inside our databases, specially using rootkits.
Prowadzący
Rodrigo Jorge
Track 3 Low-code development in Oracle
Prowadzący
Adam Kierzkowski
10:10-10:55
Track 1 Troubleshooting Oracle performance issues – concurrency wait classSUBMITTED rozwiń opis
In this presentation I will cover the systematic approach of solving Oracle performance issue. I will show a difference between AWR and Active Session History ( plus ashtop / ash_wait_chains script created by Tanel Poder ) and I will explain how to drill down a problem until you find a root cause.
Prowadzący
Bartosz Zielinski
Track 2 MySQL 8.0 Community – Ready for GDPR ? rozwiń opis
One of the most topical subject today is security. New MySQL 8.0 version introduces several improvements about that, such as: • Encryption of Undo and Redo logs • Password rotation policy • New caching_sha2_password plugin • SQL Roles So… let’s have a look!
Prowadzący
Elisa Usai
Track 3 The SQL Horror Show rozwiń opis
One reason for poor query performance are bad written SQL statements. In this entertaining session, you will see some scary “horror queries”, but also solutions how to rewrite them to simpler and much faster SQL statements. A typical approach for performance tuning is: Keep your SQL simple and fast.
Prowadzący
Dani Schnider
11:05-11:50
Track 1 Keep them out of the database! rozwiń opis
Is it a no-brainer for a DBA to prevent unwanted connections to an Oracle database in a complex environment ? What are the essential aspects to understand ? What kind of technical solutions exist ? In the form of a discussion, Martin and Flora address important organizational and technical issues.
Prowadzący
Flora Barriele
 Martin Berger
Track 2 Automatic indexing and what else is new in 19c rozwiń opis
I was beta tester of 19c and ADW/ATP. The talk will cover what is new in autonomous in addition to hybrid tables, real-time statistics, automatic resolution of SQL plan regression, Data Pump, the new 19c parameters, etc.
Prowadzący
Julian Dontcheff
Track 3 Calling userdefined functions from SQL queries got faster in Oracle 12c. rozwiń opis
Version 12 of the Oracle database introduced some options that make executing PLSQL functions within SQL queries faster than ever before. This presentation will show how and when use to use the features, the performance gains and it will highlight the pitfalls that can be encountered.
Prowadzący
Erik van Roon
12:00-12:45
Track 1 From Transportable Tablespaces to Pluggable Databases rozwiń opis
After explaining the similitudes and differences between Transportable Tablespaces and PDB unplug/plug, the focus in on the multitenant features for clones and migrations, with demos of PDB online clone, remote clone, refreshable PDB clones, PDB relocate. Some are available without option and even in Standard Edition.
Prowadzący
Franck Pachot
Track 2 Oracle Database high availability from client perspective rozwiń opis
We will look deep into high availability technologies Oracle RAC provides, what actually happens during database failover or planned maintenance and how to configure database services so that Java applications experience no or minimal disruption during planned maintenance or unplanned downtime.
Prowadzący
Priit Piipuu
Track 3 How to make your daily rutine, code and database more efficient rozwiń opis
Databases in the cloud are not using magic and need same DBA attention in terms performance and monitoring. Monitoring is complicated for PaaS model like AWS RDS but still possible. Talk will cover a monitoring functionality build by AWS to monitor different RDS dababases using wait events
Prowadzący
Marcin Przepiorowski
12:45-13:45
Track 1 Lunch
13:45-14:30
Track 1 Oracle Partitioning for DBAs and Developers. Why, when and how to use it? rozwiń opis
Most VLDBs should use partitioning and in today’s world scaling up and out a database is something critical, so every DBA and Developer should work together to accomplish this task. Partitioning may help the application run faster and also helps DBAs to perform their work.
Prowadzący
Franky Weber Faust
Track 2 Little Red Riding Hood and the Data Thief rozwiń opis
We prepared the talk for 2 speakers & aim at many live demos as possible: One will try to protect data, the other will try to steal data. We will show demos how to implement VPD by using DBMS_RLS & sys_context. We stress that it is included in XE & the importance of the principle of least privilege.
Prowadzący
Jonas Gassenmeyer
 Sabine Heimsath
Track 3 Test your PLSQL - your database will love you rozwiń opis
Want to learn how to bring quality and maintainability into your project? Join my session to find out how to make unit testing part of delivery process and avoid irritating bugs and slow QA process. In this session you will see a live demo of utPLSQL testing as part of software delivery life cycle
Prowadzący
Jacek Gębal
14:40-15:25
Track 1 REST Enabling your Oracle Database rozwiń opis
You need Web Services for your Oracle Database. You don’t have extra money, and you want to leverage your SQL and PL/SQL skills. But it also needs to be secure, fast, and REST/HTTP compliant - and communicate via {JSON}.

This talk will show you how to setup and use Oracle REST Data Services.
Prowadzący
Jeff Smith
Track 2 The MacGyver Approach rozwiń opis
There was this twisted written query and no time to fix it. I had to throw a sql profile on it to make it perform. To achieve this, I had to turn the execution plan inside out. I thought “if I can fix this mess, I call my self MacGyver.”
Prowadzący
Lothar Flatz
Track 3 PL/SQL Secure Coding Practices rozwiń opis
This presentation focuses on the issues behind the insecure code out in the wild. We will move through sql injection attacks and how they occur and the coding methods to defend against sql injection.
Prowadzący
Rob Lockard
15:35-16:20
Track 1 Database Stats. Doing It Right, The Easy Way rozwiń opis
The performance of your database query optimization is driven by your database stats.

I’ll show you what you may need to do, to ensure well gathered stats to get the best out of the optimizer.
Prowadzący
Neil Chandler
Track 2 Data Guard New Features
Prowadzący
Pieter Van Puymbroeck
Track 3 APEX's classic report: the power of no template rozwiń opis
The classic report is on of the APEX components that are a bit undervalued. It offers great potential when you must adjust the generated HTML after it has been sent to the browser. The session will introduce concepts for creating highly adjustable reports which allow lots of user interaction.
Prowadzący
Richard Martens
16:30-17:15
Track 1 The Heart of Oracle rozwiń opis
Knowing the fundamentals of how Oracle works will help you be a better developer or DBA. It’s not complex, but you have probably never been told before. This session will tell you. And I make it fun.
Prowadzący
Martin Widlake
Track 2 DBFS - savior or pitfall... rozwiń opis
Is DBFS for you? What are the cons and pros of using DBFS? This talk will address these questions based on the day to day usage of DBFS for multiple systems, with the primary goal of addressing ETL processing. Rarely used feature, may well address your requirements or may cause headaches.
Prowadzący
Przemysław Potrząsaj
Track 3 FABE the largest world wide APEX community project rozwiń opis
Doing a community project includes a lot of challenges:
- work life balance / prioritization / expectations
- multi cultural / different timezone interaction
- new technical challenges
- database inside the cloud

I will share my view about this great project and what it means to participate in a community project.
Prowadzący
Tobias Arnhold
Koniec
 
Track 1
Track 2
Track 3
10:00-10-45
Track 1 SQL Optimization Walk Through rozwiń opis
We’ll take a real SQL (or maybe two) and will walk through the steps needed to understand why SQL is running slower than it can, why Oracle is doing what it does, and possible solutions for these issues.
Prowadzący
Timur Akhmadeev
Track 2 The database platform – the end of progress? rozwiń opis
Not any new processors? Not any new disk arrays? The same SAN till the end of the time? Moor’s low not working anymore? Marketing instead of technology?

Over the last decades the enterprise class systems, and database systems as a part of it, was perceived as IT market locomotive.

It was reflected by technology trends, strong attention of most important vendors and – as a result - wide offer of new announced, truly innovative products.

The IT market is still growing dynamically and cover wider area of technology and users activities. The grow caused as an effect deep structural market rebuilding, which has close the market of enterprise solutions as narrow and shrinking niche. The consequences of it make important changes to Enterprise Solutions Market, IT environments and actual availability of new technologies. I have tried to summarize the prominent (and natural) trends from wilder perspective because we, professionals caring about business critical solutions deeply depends of them.
Prowadzący
Zbigniew Swoczyna
Track 3 Accelerate Development with automation rozwiń opis
In this presentation Ron will discuss DevOps and the explore why automation is key to developer agility. Ron will demonstrate how automation can accelerate development and improve quality by ensuring consistent platform configurations and by delivering the right data to the right people, fast!
Prowadzący
Ron Ekins
11:00-11:45
Track 1 Deep Dive into the Implementation of Oracle's Join Methods: Past, Present and Future rozwiń opis
Join processing in relational databases involves combining the output of two row sources (e.g. tables) into one result row source. Most SQL analytic workloads are dominated by time spent in join processing because of the nature of the operation being heavily compute and bandwidth intensive. Oracle has developed numerous traditional join methods over the years (e.g. nested loop, sort merge, hash joins, etc.). Some of these methods have fallen out of favor over time by the optimizer (i.e. past), others are time-tested and commonly selected by the optimizer to this day (present), and then there's a new class of join algorithms which leverage the latest In-Memory Columnar data formats to deliver the fastest join evaluation known in industry (future). This talk will dive into the technical implementation details of Oracle's plurality of join methods (including specialized ones such as vector transformation which optimizes aggregations over joins), give insight into why the optimizer may choose one method over the other, and what the SQL and storage engines are actually doing under the hood to implement the join.
Prowadzący
Shasank Chavan
Track 2 We are Serverless - It still Works. And this (what we think) has happened. rozwiń opis
Going Serverless to a cloud-provider gave use some interesting experiences. The result was Positive, but with interesting lessons about the tools (java, pl/sql, python, docker and lambdas), the data, the (oracle-)database, and the people and processes needed to control the new situation.
Prowadzący
Piet de Visser
Track 3 Beer Pong: SQL vs PGQL rozwiń opis
SQL is in Relational Databases what PGQL is in the Graph Databases world (Oracle-wise). Did you ever think at challenging both solution? Doing the same job, compare how nice, easy, fast it is. Let’s see how it goes…
Prowadzący
Gianni Ceresa
12:00-12:45
Track 1 Double Feature & Extended Cut: Oracle's kernel debug, diagnostics & tracing infrastructure rozwiń opis
Geek man and Weed man are doing a Double Feature (2 continuous slots a 30 to 45 minutes needed).

Geek man aka Stefan Koehler Weed man aka Hatem Mahmoud
Prowadzący
Stefan Koehler
 Hatem Mahmoud
Track 2 Home Management and database patching with RHP rozwiń opis
How to manage multiple of Oracle homes?
How to patch or upgrade many of databases?
Can it be done with a single button click?
The session will demonstrate the way to answer above questions using the Rapid Home Provisioning server. The main focus will be on the RHP functionalities that do not require additional licencing.
Prowadzący
Krzysztof Łojek
Track 3 Conquer Big Data with Oracle 18c, In-Memory External Tables and Analytic Functions rozwiń opis
There’s an onslaught of Big Data coming to our IT shops - zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c?
Prowadzący
Jim Czuprynski
12:45-14:00
Track 1 Lunch
14:00-14:45
Track 1 A deep dive into Oracle parsing rozwiń opis
As a spoiler/teaser: the documentation is mostly wrong about it, and certain critical parts of parsing can be moved to execution time. Because what is happening is generally considered to be taking place at parsing time, that time is now spend in in sql execution in the statistics, however since it’s considered parsing, that time is added to parsing time too, making it hard if not impossible to understand the statistics if there are actual parsing problems.
Prowadzący
Frits Hoogland
Track 2 Long live to CMAN! Or why Oracle still cares about CMAN and why you should do it too rozwiń opis
Oracle Connection Manager (CMAN) is the Swiss-army knife for database connections. Starting with Oracle 18c, it has been extended with the new Traffic Director Mode (CMAN TDM), that allows transparent failover for applications that do not implement it natively. Come to this session to know more!
Prowadzący
Ludovico Caldara
Track 3 A Gentle Introduction to Polymorphic Table Functions rozwiń opis
Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism and how you could apply this in pre-18c databases. After this session you will understand when to use which technique.
Prowadzący
Patrick Barel
15:00-15:45
Track 1 ASH and AWR: beyond ?/rdbms/admin/{awrrpt,ashrpt.sql} rozwiń opis
Oracle EE systems licensed to use the Diagnostics Pack offer a wealth of tools to assess performance. Analysts often resort to ASH and AWR reports, and often stop right there. Yet there is more! This talk features scripts contributed by renown performance experts helping you find problems quickly.
Prowadzący
Martin Bach
Track 2 Oracle XE - The world's best database completely free rozwiń opis
If you need a reliable database, but unsure about license costs, Oracle XE is for you.

This presentation will show you what you can do with Oracle XE, APEX, and new features as advanced analytics. The presentation is aimed at beginners, and people who mistakenly believe Oracle has to be expensive.
Prowadzący
Øyvind Isene
Track 3 ORDS Under Siege rozwiń opis
l’ve been benchmarking ORDS. I’ll cover why, how, and
things I’ve learnt along the way, including using reverse proxies to
cache responses and handle SSL certificates. I’ll share details of my
Vagrant build so you can check my findings. I’m assuming attendees
will have basic knowledge of ORDS.
Prowadzący
Patrick Jolliffe
16:00-16:45
Track 1 Being Smarter Than Chuck Norris - Fallback Strategies live in action! rozwiń opis
Upgrades and Migrations work ALWAYS fine. Always?

What if … something goes terribly wrong? What if … you need to reverse to a state 3 days ago? What if … you don’t want to lose any data changes?

Then you need this talk showing you Fallback Strategies - Live and in Action with demos.
Prowadzący
Mike Dietrich
Track 2 What's used in your database? the value available behind DBA_FEATURE_USAGE_STATISTICS  rozwiń opis
Everyone who had to go through a Oracle DBA Training knows the existence of DBA_FEATURE_USAGE_STATISTICS. If you have to take care of features used, inflexible regime of DFUS is boring. If you want to understand the moving parts behind the scene, this presentation will help you to reach your goal.
Prowadzący
Martin Berger
Track 3 Top 10 Database Compression Insights – What You Need to Know rozwiń opis
I’ve managed Oracle Compression for 8 years, anyone using, or planning to use Oracle compression needs to hear what I have learned.
Prowadzący
Gregg Christman
17:00-18:00
Track 1 Discussion panel
Koniec

Prelegenci

Bartosz Zielinski
Dani Schnider
Elisa Usai
Erik van Roon
Flora Barriele
Franck Pachot
Franky Weber Faust
Gianni Ceresa
Gregg Christman
Hatem Mahmoud
Jacek Gębal
Jeff Smith
Jim Czuprynski
Oracle ACE Director
Jonas Gassenmeyer
Julian Dontcheff
Krzysztof Łojek
Lothar Flatz
Ludovico Caldara
Marcin Przepiorowski
Oracle ACE
Martin Bach
Martin Berger
Martin Widlake
Oracle ACE Director, Oak Table
Mike Dietrich
Neil Chandler
Oracle ACE
Olena Vorovchenko
Øyvind Isene
Patrick Barel
Patrick Jolliffe
Piet de Visser
Oracle ACE
Pieter Van Puymbroeck
Senior Oracle DBA
Priit Piipuu
Przemysław Potrząsaj
Richard Martens
Rob Lockard
Rodrigo Jorge
Ron Ekins
Sabine Heimsath
Oracle ACE Associate
Shasank Chavan
Stefan Koehler
Timur Akhmadeev
Tobias Arnhold
Bilety dostępne!

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ę.

Kino Nowe Horyzonty

ul. Kazimierza Wielkiego 19a-21, Wrocław
Strona www

After party

Grey Music Club, ul. Świętego Mikołaja 8, Wrocław

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