HIGH FIVE POUG

Kiedy: 1-2.09.2017

Gdzie: Kraków, Stara Zajezdnia

CFP: Papercall.io/pougv

Agenda



8:15-8:45
Registrationrozwiń opis

9:00-9:45
Sponsor 1rozwiń opis
Sponsor session 2rozwiń opis

10:00-10:45
Memory access Tracing/Profilingrozwiń opis
Using dynamic instrumentation tools like systemtap/perf/eBPF/intel pin/etc for troubleshooting performance/functional problem and for getting a deeper understanding of the internal working of the oracle database is becoming more common nowadays. Basically this tools can be used to trace/profile function calls,arguments,stack traces, memory access,hardware/software events and many others stuffs.In this session i will show different ways for tracing/profiling memory access with some use cases such as Troubleshooting Latch Contention using sytemtap,Unhiding user/dblink password using intel pin and Reverse engineering db link password decryption.
Prowadzący
Hatem Mahmoud
How to instrument your code easy and effectively (and why!)rozwiń opis
Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running?

This session is all about instrumenting your PL/SQL code, be it inside an APEX application or in a pure PL/SQL environment. What are the alternatives to the very common hand-knitted or organically grown solutions? We are going to look at a few open-source frameworks and analyze which requirements they can cover and what you might have to add yourself. After this session, you will know what to look for when choosing the right framework to enhance your project.
Prowadzący
Sabine Heimsath

11:00-11:45
SQLcl - SQL*Plus with benefitsrozwiń opis
Prowadzący
Erik van Roon
Oracle 12c for Developersrozwiń opis
Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you. You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases.
Prowadzący
Alex Nuijten

12:00-12:45
Automate DBA Tasks With Ansiblerozwiń opis
Every time you find yourself doing the same thing over and over, have you asked your self: How can I automate this? Nowadays cloud vendors are a major driving force for automation in our industry. This presentation focuses on the increasing role of automation and how it impacts the way Database Consultants and Administrator job is evolving. You will learn how you can decrease boring tasks and free up time for value-add work. We will take a detailed look at Ansible framework with which we can automate repetitive tasks.
Prowadzący
Ivica Arsov
SQL: The one language to rule all your data!rozwiń opis
SQL is a very powerful language and we have been using it for almost 40 years now to process our data. Did you know that SQL comes with many powerful techniques for analysing your data. Did you know that you can analyse data that is outside the database using SQL? Using the new Oracle Big Data SQL we can now analyse our data that is stored in our Database, in Hadoop and NoSQL all at the same time. This presentation will give demonstrations of the various analytical features available in SQL and PL/SQL and will show how you can now use the Oracle Big Data SQL to gather deeper insights of your data. The presentation will focus on some of the lessor know statistical functions, analytics functions and predictive analytics functions and how these can be used on all of your data.
Prowadzący
Brendan Tierny

13:00-14:00
Lunch breakrozwiń opis

14:00-14:45
Get the most out of Oracle Data Guard!rozwiń opis
If you use Oracle Data Guard feature just for data protection, you are using less than half of its potential. You already pay for it, so why not getting the most out of it? In this session I will show how you can use Oracle Data Guard capabilities for common tasks such as database cloning, database migration and reporting, with the help of other features included in Oracle Database Enterprise Edition.
Prowadzący
Ludovico Caldara
Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2rozwiń opis
Prowadzący
Jim Czuprynski

15:00-15:45
12cR2 Statistics Advisor: Do you gather statistics in the way the optimizer expects them?rozwiń opis
You can’t blame the optimizer unless you are sure you feed it with relevant statistics. There is the Auto Job which suits most of the cases, and there are some exceptions: volatile tables, partitioned tables, bulk load, histograms and bind variables, etc. Let’s define a few rules to know if you gather statistics in the right way, and see how the 12.2 new advisor can help to provide what the optimizer expects.
Prowadzący
Franck Pachot
Back2Basics - A Day in the Life of an Oracle Analytics Queryrozwiń opis
The Oracle Analytics product family is in use for years, has gone through many iterations, and is widespread across projects around the globe. Millions of analyses have been created, deployed, and run billions of times. The actual lifecycle of a query within this product stack from its inception through to the effective delivery of results may therefore be regarded as a given commodity not requiring a closer look. Few people have regarded an OBI query from this point of view: “How does it get constructed? How does it get translated between the different architectural components and the RPD layers? How, through what, and where does its lifecycle get influenced? Where can we as users/developers/administrators actively intervene with its makeup and structure? Why do we genuinely have to have an understanding of the subtleties of the lifecycle to create successful analytical solutions?”
Prowadzący
Christian Berg

16:00-16:45
Apache Hive for Oracle DBAsrozwiń opis
The ideia of the workshop is to digg into Hive and their technical architecture and implementation features and limitations and make the audience compare it to RDBMS and Oracle. This will be a pretty technical talk and will expose the DBAs to the new world of Hive ecosystem and their use cases. Live demos on Apache Hive cluster will be the focus point for learning.
Prowadzący
Luis Marques
12.2 Histograms are Evil, like Chocolate is Evil (or, how to avoid getting slapped by Maria)rozwiń opis
Prowadzący
Neil Chandler

17:00-17:45
Interpreting AWR Reportsrozwiń opis
How one can interpret that big pile of numbers you get in AWR report? Do you need a crystal ball, or you net to go to a fortune teller or just use a systematic approach and find out what those numbers can reveal you. The latter will be sufficient.
This will be a two sessions presentation. We will use drill down approach for the interpretation of the AWR report and find out what mean different part of the report and how they are interrelated.
Prowadzący
Jože Senegačnik
What is "Standard APEX"? Understand the technology by analyzing the APEX dashboard competition appsrozwiń opis
This presentation is for beginners and professionals, young and old specialists because it argues with the master question itself: What is the right way to do it? And by showing the different results of the APEX Dashboard competition you will understand the problematic from a visual point of view and a technical point of view. Get crushed by seeing what really matters and what will kill you the day after.
Prowadzący
Tobias Arnhold

18:00-18:45
Interpreting AWR Reportsrozwiń opis
Prowadzący
Jože Senegačnik
Martin Widlake goes wild: TOP 10 ways of drinking beer, combined with TOP 10 ways of bad programming habits. Because you can't talk about it being sober.rozwiń opis
Prowadzący
Martin Widlake

Koniec

8:15-8:45
Registration

9:00-9:45
Sponsor session 3
Sponsor session 4

10:00-10:45
The journey of a bi-stack to the cloud
Bi is can be a complex matter in big organisations. This presentation will tell the story about a strategic business decision to move the on premises BI stack to the Microsoft Azure cloud. This talk will focus more on the db-part than the bi part.

This presentation will cover - how we managed to move +300TB divided over several multi TB databases to the cloud - which services were chosen to run the database servers and why - how performance testing and sizing has been done - how automatic provisioning has been done for providing developers what they need in agreed SLA’s. - how we dealed with the short deadline - why the Azure Cloud was chosen over the Oracle cloud - Cost savings?

The deadline of the project was end of the year 2016. This gives the opportunity to give you an insight in a very fresh project of the move to the cloud from a complete BI environment.
Prowadzący
Pieter Van Puymbroeck
Oracle Cloud Essentials for Dummies
CIMA won The Oracle Excellence Award 2016 for Cloud Innovation and Integration. Want to know why?, In this talk we will be looking at the decisions businesses have to consider when moving applications such as ERP and HCM to the cloud. . In this talk we will look at the real-world experiences when implementing a PAAS Cloud service such as DBCS and SOA. We will discuss topics such as: topologies; backups; user and key management; provisioning; Security; monitoring post go-live, etc. Delegates will learn about important design considerations and some of the vital tasks they need to do to make their Oracle PaaS environments consistent and easily manageable (over and above the click-click-click of demonstrations!). Once you have the data in the cloud, how do we report on this?, we will look at ways to extract this data for BI?

At the end of the talk the audience should have a clear understanding of the challenges and possible solutions in moving to the cloud. You should be able to walk away with answers to the following :

1) Things to consider when moving to the cloud. 2) Security in the Cloud. 3) Behaviors that may need to change in the business. 4) How to extract data from the cloud. 5) Integrating Cloud Data with Premise Data.
Prowadzący
Kiran Tailor

11:00-11:45
Researching the Oracle core - 3 slides and a lot of internals hacking fun in 45 minutes
Warning: Please don’t expect any fancy Microsoft PowerPoint slides in this session. It is pure (live) Oracle core hacking fun but also very educational at the same time. For example you will learn how to extract various information from the Oracle core and how to use it in different troubleshooting scenarios or just for educational purpose. Understanding the Oracle core helps you to become a better troubleshooter :-)
Prowadzący
Stefan Koehler
PL/SQL Secure Coding Practices
This presentation will focus on writing secure PL/SQL code. We will define and identify sql injection bugs along with other common coding bugs that can lead to a data breach. Once we have defined these bugs, we will go through a design and coding architecture that drastically improves your infosec posture.
Prowadzący
Rob Lockard

12:00-12:45
dNFS for DBA's
Direct NFS is an Oracle implementation of the standard NFS protocol inside Oracle Database. Using this native solution Oracle instance is able to better handle IO traffic and bypass a kernel layer of operating system. dNFS is commonly used for Exadata backups into ZFS Appliance and for Oracle databases using a NFS based solutions (like NetApp or Delphix ).

The goal of this presentation is a show DBA’s what is a Direct NFS, how to configure, use and monitor it. Proper configuration and monitoring are important to achieve a maximum performance and easy problem diagnostic. There will be examples of configuration with and without direct NFS.

NFS protocol is based on the TCP/IP protocol and this presentation will also show a recommended configuration of the TCP stack and explain how network should be monitored.
Prowadzący
Marcin Przepiorowski
Docker for Dummies
You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon. In this session you’ll learn what Docker is and how you can benefit from it in your daily work.
Prowadzący
Roel Hartman

13:00-14:00
Lunch break

14:00-14:45
Title: 45 most useful new DBA commands in Oracle 12.2
Prowadzący
Julian Dontcheff
Common Pitfalls in Complex Apps Performance Troubleshooting
This session is going to discuss simple things to remember while tackling performance issues with complex applications deployed in multiple tiers.
Prowadzący
Timur Akhmadeev

15:00-15:45
Dino DBA goes Dev-Ops.
As a DBA or Database-person you will be asked to join a Dev_Ops team and use some of the Agile methods. When this happens, you will have to absorb new knowledge and work-habits. But you will also have to educate your colleagues on what is possible and impossible at the database level. We will try to give some guidelines, and point out a few embarrassing mistakes we made in these situations.
Prowadzący
Piet de Visser
From Block to Lock - Lock modes from theory to practice
A familiar scenario for database administrators - a user reports a “Lock in the database”. This situation is often very critical and there is a limited time for the solution. During the presentation, there will be a classification and an explanation of the different kind of locks.
Prowadzący
Tobias Deml

16:00-16:45
Oracle Enterprise Manager 13c: Write powerful scripts with EMCLI
Enterprise Manager Cloud Control already helps you to manage and monitor your datacenter with ease, but how about making things easier by using EMCLI? EMCLI supports Python scripting since 12.1.0.3. An introductory Python knowledge is more than enough to create useful EMCLI scripts to handle bulk operations or to automatise regular tasks. In this session, I’ll explain the basics of EMCLI and show how you can use EMCLI internal scripting engine. The concepts will be explained using sample scripts.

This session targets users who are familiar with Enterprise Manager Could Control.
Prowadzący
Gokhan Atil
Graph Databases - Just hype, or the end of the relational world ?
Graph databases have become increasingly popular over the last few years, largely because graph structures are highly flexible and provide a simple and intuitive way of modeling data which subsequently can be queried easily. In graph databases data is held in a graph consisting of a set of nodes with links between them rather than keeping data records in tables as is the case in relational technologies.

Since 2015 Oracle offers a graph database based on the concept of property graphs as part of Oracle Big Data Spatial and Graph. The actual data store can either be an Oracle Database, Oracle NoSQL or Apache HBase. Graph analytics are done using an in-memory engine.

For data access it uses an API based on the open source Apache Tinkerpop project, which has evolved into the industry standard in these kinds of environments. Besides this it includes the PGQL query language designed for pattern matching, and it comes with a large number of built-in algorithms for graph analysis.

In this paper we will explain the fundamentals of property graph databases and highlight use cases in which property graph implementations are superior to relational technologies. Besides looking into the architecture and query language of Oracle Big Data Spatial and Graph we will show which kinds of applications can benefit from specific algorithms.

We will cover the conversion of relational tables to graph structures, as well as the visualization of property graph data using commercial and open source tools. And finally, we will look into a series of benchmarks based on typical datasets which have been conducted against similar technologies.
Prowadzący
Albert Godfrind

17:00-17:45
Jonathan Lewis speech
Prowadzący
Jonathan Lewis

18:00-18:45
Discussion panel
Prowadzący
Kerry Osborne

Koniec

Jak dojechać


Stara Zajezdnia

Kraków

Stara Zajezdnia Kraków by DeSilva to bardzo klimatyczne miejsce w sąsiedztwie Starego Rynku i Wisły. A co najważniejsze, mają halę piwną z minibrowarem.

Strona www

After party


W cenie biletu zawarty jest wstęp na after party z open barem. Więcej szczegółów 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.

Zapraszamy Państwa do współpracy przy organizacji kolejnego spotkania POUG. Bycie partnerem biznesowym daje Państwu możliwość zaprezentowania swojej marki przed i podczas wydarzenia.

Zgłoszenie