Track 1
Advatech session: Coherent future of data(base) rozwiń opis
Deep dive into planning, architecture and implementation of robust, scale-out abstraction layer that allows you to offload database workload and consolidate data in heterogeneous environments.
Meet growing demands and prepare your data for modern applications with high-performance, real-time processing grid based on Oracle Coherence!
Track 2
VOODOO - the black magic of cheep cross-database replication rozwiń opis
The history why we wrote our own replication tool between Oracle and PostgreSQL with a bit of low level archivelog architecture explanation.
- We shuld buy a bar!
- Of course we should buy a bar!!! Brilliant why we didn’t think about it earlier!?
- Do you have a few hundred thousand euros?
- A pint then?
- A pint then.
We all want to have a bar and drive Porshe... But in most of the cases we can afford only a few pints and drive with VW. Replication engines are expensive and buying something like Golden Gate when you only have SE database and you want to replicate it to PostgreSQL is like buying a single malt to make Cola taste more bearable. That’s why we wrote our own replicator tool. A simple one. A cheep one. Nothing fancy. But it works. And we will use this subject as an excuse to show some low level archivelog tricks.
It will be a live demo, showing how to resolve replication problems in heterogenous database environment without spending lots of money:)
Track 1
Memory access Tracing/Profiling rozwiń 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.
Track 2
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.
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.
Track 1
Automate DBA Tasks With Ansible rozwiń 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.
Track 2
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.
Track 1
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.
Track 1
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.
Track 2
Back2Basics - A Day in the Life of an Oracle Analytics Query rozwiń 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?”
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.
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.
Track 2
What is "Standard APEX"? Understand the technology by analyzing the APEX dashboard competition apps rozwiń 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.
Track 2
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.
Track 1
Czy IaaS potrafi być atrakcyjny? - nowości od ORACLE (Maciek Tomkiewicz)
Track 2
A full Oracle Cloud Development Environment (Lukasz Klimas, Witold Świerzy)
10:00-10:45
Track 1
The journey of a bi-stack to the cloud rozwiń opis
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.
Track 2
Oracle Cloud Essentials for Dummies rozwiń opis
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.
Track 1
Researching the Oracle core - 3 slides and a lot of internals hacking fun in 45 minutes rozwiń opis
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 :-)
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.
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.
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.
Track 2
From Block to Lock - Lock modes from theory to practice rozwiń opis
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.
Track 1
AWR Warehouse - the Good, the Bad and the Ugly rozwiń opis
A brief high level overview of AWR Warehouse, and why anyone responsible for managing database instances should be using it we will drill into some of the internals of how it works and finish with some ideas about how to troubleshoot and resolve issues when it breaks.
Track 2
Graph Databases - Just hype, or the end of the relational world ? rozwiń opis
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.
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.
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.
W cenie biletu zawarty jest wstęp na after party z open barem. Wstęp z identyfikatorem konferencji od godziny 20.30 w restauracji CK Browar.
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!
Ta strona wykorzystuje własne pliki cookies, aby działać prawidłowo. Korzysta też z plików cookies podmiotów trzecich, dostarczających narzędzia marketingowe, usługę newslettera, odtwarzacze wideo, mapy oraz narzędzia analityczne. Do informacji zbieranych w cookies podmiotów trzecich mają dostęp dostawcy tych narzędzi. Czy zgadzasz się na korzystanie z innych niż niezbędne plików cookies zgodnie z polityką prywatności?
Jeżeli tutaj zaglądasz, to znak, że cenisz swoją prywatność. Wychodząc naprzeciw Twoim oczekiwaniom, na tej stronie został wdrożony mechanizm, który pozwala Ci kontrolować wykorzystywanie plików cookies oraz innych technologii śledzących.
Pliki cookies własne wykorzystywane są na tej stronie w celu zapewnienia prawidłowego działania poszczególnych funkcji strony a pliki cookies podmiotów trzecich w celu korzystania z narzędzi zewnętrznych na zasadach opisanych szczegółowo w polityce prywatności.
Jeżeli chcesz zaakceptować wszystkie stosowane przez tutaj pliki cookies, kliknij w poniższy przycisk.
Te pliki cookies pozostają zawsze aktywne i nie masz możliwości wyboru w tym zakresie. Są to pliki cookies, dzięki którym w sposób prawidłowy funkcjonują m.in. formularze na stronie oraz mechanizm logowania do konta użytkownika i utrzymywania sesji po zalogowaniu. Ponadto, w plikach cookies własnych zapisywana jest informacja o dokonanych przez Ciebie ustawieniach plików cookies.
Korzystamy z Google Analytics, czyli narzędzia pozwalającego na gromadzenie, przeglądanie i analizę statystyk związanych z aktywnością użytkowników na naszej stronie. Kod śledzący Google Analytics gromadzi informacje na temat Twojej aktywności na naszej stronie, które mogą być przez Google wykorzystywane przy budowaniu Twojego profilu użytkownika. Ponadto, informacje z Google Analytics mogą być wykorzystywane w ustawieniach kampanii reklamowych prowadzonych z wykorzystaniem Google Ads. Jeżeli sobie tego nie życzysz, możesz wyłączyć narzędzia Google.
Korzystamy z narzędzi marketingowych Facebooka. Dlatego osadziliśmy na stronie skrypty analityczne od Facebooka (Pixel Facebooka), które służą do gromadzenia informacji o Twojej aktywności na tej stronie oraz Twojego adresu IP. Na podstawie tak zgromadzonych informacji Facebook pozwala ustawiać reklamy z zaawansowanymi opcjami targetowania. Jeżeli sobie tego nie życzysz, możesz wyłączyć skrypty analityczne Facebooka.
Na stronie wykorzystujemy multimedia z serwisu YouTube. Odtwarzacze tych multimediów wykorzystują do swojego działania pliki cookies pochodzące od ich dostawcy. Dostawca może uzyskiwać dostęp do informacji gromadzonych w plikach cookies oraz Twojego adresu IP. Informacje te wykorzystywane są w celu zapewnienia prawidłowego działania odtwarzaczy oraz w celach analitycznych. Możesz nie pozwolić na wykorzystanie plików cookies związanych z odtwarzaczami, ale nie będziesz w stanie zobaczyć treści osadzonych jako odtwarzacze multimediów.
Używamy na stronie Google Maps. Te mapy wykorzystują pliki cookies dostarczane przez dostawcę usługi, aby działały poprawnie. Dostawca usługi może uzyskiwać dostęp do informacji gromadzonych w plikach cookies oraz Twojego adresu IP. Możesz dezaktywować pliki cookie powiązane z mapami, ale jeśli to zrobisz, nie będziesz mógł zobaczyć map na naszej stronie internetowej.
Osadziliśmy na stronie formularz pozwalający Ci zapisać się do naszego newslettera. Formularz wykorzystuje do swojego prawidłowego działania pliki cookies pochodzące od dostawcy systemu newsletterowego MailerLite. Dostawca może uzyskiwać dostęp do informacji gromadzonych w plikach cookies oraz Twojego adresu IP. Informacje te wykorzystywane są w celu zapewnienia prawidłowego działania formularza oraz w celach analitycznych. Możesz wyłączyć pliki cookies związane z formularzem, ale w takiej sytuacji nie będziesz w stanie zapisać się do newslettera.
