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!
VOODOO - the black magic of cheep cross-database replicationrozwiń opis
The history why we wrote our own replication tool between Oracle and PostgreSQL with a bit of low level archivelog architecture explanation.
- We should 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 Porsche... 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
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.
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 like working from the command line in sqlplus? Then you will love doing so in SQLcl. Maybe you don’t like working from the command line, but you have to? Then you will hate it a lot less in SQLcl.
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.
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.
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.
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.
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.
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?”
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.
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.
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.
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.
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 :-)
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.
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.
Graph Databases - Just hype, or the end of the relational world ?
Graph databases are the simplest approach to analyze complex relationships: social networks, financial connections (Panama Papers), human interactions … Come learn the new powerful analytics you can use with Oracle 12cR2 and Oracle Big Data: from the PGQL language to built-in graph algorithms.
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
Ticket includes entrance to our After Party with an open bar. More detailes soon!
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. Whatdoesitmean?