Sponsor session 1 - ZFS Dive: exploring how the ZFS Storage Appliance works (Red Stack Tech)
This presentation will discuss the internals of the ZFS Storage Appliance, and ZFS file system. Starting with a quick recap of ZFS basics we will then explore the optimisations that make ZFS unique, as well as discussing how settings and configurations can be used to effect different workloads.
Sponsor session 2 - Oracle OpenStack is Cloudy (Advatech)
This year Oracle updated its OpenStack distributions for Linux and Solaris. Oracle is definitely not a leader in this area but since 2014 consistently bundles OpenStack with its operating systems and hypervisors. This presentation with live demo will introduce OpenStack to Oracle users, show how newly released Oracle VM x86 3.4 hypervisor can be managed by Dashboard instead of Oracle VM Manager and what it exactly means that Oracle operating systems are "Cloud-ready". As an example of cloud automation it will present Murano service configured to easily provision Oracle Pluggable 12c databases on users demand.
DBA, Heal Thyself: Five Diseases of IT Organizations and How to Cure Them
Ask any group of seasoned Oracle DBAs if they’ve ever lived through what must feel like a typical day in the life of Dilbert, Scott Adams’s quintessential cynic, and you’re bound to experience vigorous agreement. When a relatively simple database application deployment suddenly evolves into Project Death Spiral, or when there never seems to be enough DBA resources to keep up with application developer demands, or when IT management continues to make seemingly impossible demands for increased DBA productivity … then maybe it’s time to consider diagnosing the real problem in your IT organization and perhaps even applying the right treatment to relieve the pain, if not provide the cure.
Through humor and story-telling, this presentation will reveal five common diseases that seem to “harden the arteries” of IT organizations: Uniquitis, HypoRMANosis, Tengenertia, Toolichondria, and Idiomyopia – that Oracle DBAs must often battle to overcome to true root problems of their IT organization.
Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You
Oracle Standard Edition is commonly used database for small and middle size companies. One of the typical problems with Oracle SE is lack of proper monitoring build in database as Oracle Automatic Workload Repository is available for Enterprise Edition. DBA's can use a Statspack to monitor database but in lot of cases there is a need to better monitoring granularity. This is an area where OraSASH can be used to establish monitoring on session level and provide like ?ASH? data for DBA. OraSASH is a free product created by Kyle Hailey and now maintained by myself on Github repository. It is a implementation of ?AWR/ASH? like repository. This session will guide DBA through OraSASH design, installation and maintenance process. OrsSASH is providing similar tables to AWR/ASH and same queries can be run against both repositories ? there will be examples how to monitor database and steps how to find out database bottlenecks.
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 Oracle NoSQL or Apache HBase and an in-memory engine for data analysis is delivered with the product. 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 a query language which is designed for pattern matching and comes with a large number of algorithms for graph analysis already built-in. 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.
Top 10 Features of Oracle SQL Developer everybody should use, even in the Cloud - Heli Helskyaho
Oracle SQL Developer is a tool every Oracle user should be using. In Oracle SQL Developer there are excellent features that will make your life easier, does not matter if you are a dba, a developer or a database designer. There is plenty of great features for everybody, Learn about my favourite features that will hopefully make your life easier too and make you a more profitable member of your IT team. All the demos in this session are performed in the Oracle Cloud.
Parallel Execution in Oracle Database 12c
Many of us are facing with the problem of scanning lots of data. Daily growth of data becomes everyday problem and we are challenged to write SQLs which should scan millions of rows and run within minutes. This presentation will focus on parallel execution with Oracle Database 12c and how should you leverage its power. We will cover the concepts, what is parallel execution and how it works. You will learn the difference between traditional parallel execution and In-Memory parallel execution. We will cover different aspects of parallel execution, distribution methods, how to implement (monitor) parallel execution and how to effectively diagnose and trace.
The Forgotten Performance Tuning Trick - Clustering your Data
As data volumes continue to increase, SQL performance and tuning remain as critical as ever. But it is not all about Explain Plans, using hints and adding indexes. How you structure your data and how you cluster your information together is vital to getting the best performance from your database - and it is often overlooked. By using Index Organised Tables, Cluster, Partitioning, normal indexes and other tricks, you can not only access your data quicker, you can greatly increase the use of your database's memory.
Living in a Virtualised World: Oracle VM on Exadata
Virtualisation gains more an more ground. As a result of that one of our customers asked to implement of Oracle VM on Exadata.
This session will discuss the project implementation, issue encountered ...
It will answer following following questions :
What it is and what it is not? When could you use it? How does it work? How to install? How to patch? Which pitfalls and problems were encountered and how to solve them? How does it compare to other Engineered systems such as for example the Super Cluster? At the time of the conference the system we implemented will be in production for approximately 6 months, which will give us the opportunity to share a lot of information.
Function Madness: how a clever Architecure becomes a problem
After troubleshooting a system with CPU-overload, we found it was mainly due to PL/SQL function-calls. The result was some interesting investigation into PL/SQL functions. We demonstrate how good intended use of pl/sql functions can turn into abuse. After the presentation, the audience will be able to avoid some of the mistakes.
Combining Cloud Based Data with on-prem Exalytics using In-Memory Technologies
CIMA recently went live with ERP Cloud, In this talk we will look at the different ways data can be exported from ERP Cloud and how CIMA bring data from the ERP cloud into our on premise Exalytics system. This talk will also demonstrate the power of exalytics in dashboards and SQL performance. The combination of Exalytics and In-memory data management enabled CIMA to achieve levels of analysis that were just not possible before and become a game changer in the education sector. Having an engineered system you will need to somehow manage it, for this We will also look at how easily EM 13C can be installed, agent installed and used with TimesTen and Exalytics to manage and monitor the exalytics system. Chris Jenkins, director of in memory technologies at Oracle will explain and demonstrate the advantages/benefits of using the TimesTen plug in with EM13C. At the end of this talk the audience will be able to see how to retrieve cloud data to premise and the advantages of having and managing an exalytics engineered system with 13c.
Back2Basics - 50 Shades of #Fail: OBI Worst Practices in Real Life
Lists of "best practices" as well as "how-to's" on the subject of Oracle BI and all its facets are commonplace and often discussed. Real-life practices, however, are a completely different story. What happens when implementations go astray or dogmatically follow half-knowledge, misconceptions, or conveniently cheap shortcuts? Learn about recurring pitfalls, their origins, their impacts, and most importantly their remedies in an entertaining fashion. However bad you thought your project was, you’ve seen nothing yet...
(Still) No Silver Bullets : OBIEE 12c Performance in the Real World
Are you involved in the design and development of OBIEE systems and want to know the best way to go about ensuring good performance? Maybe you've an existing OBIEE system with performance "challenges" that you need to diagnose? This presentation looks at the practical elements of diagnosing the causes of performance issues in OBIEE, and discusses good practices to observe when developing new systems. It includes discussion of OBIEE 12c and with additional emphasis on analysis of Usage Tracking data for the accurate profiling and diagnosis of issues.
Query transformations are actually so called logical optimization which is done before the Cost Based Optimizer performs the physical optimization. Transformations are performed always and are performed transparently to the end user. In latest database releases Oracle introduced new transformations to boost the performance of certain SQL statements. In this presentation we will discuss most of the transformations.
Oracle Management Cloud: Tools for analysing, correlation and storing log files from Oracle environments. (Oracle)
Why has my plan changed.
When you write SQL, Oracle runs it through the Optimiser to determine the fastest way to access the data. This access path sometimes changes without anyone noticing. Sometimes it's faster. Sometimes it's slower. Dramatically, catastrophically slower. Why doesn't Oracle always get it right? Why does it change?
This presentation will answer the question Why - through the use of demonstrations, and explain what we can do to manage SQL execution plans within the database and minimise the opportunity for Oracle to get it wrong.
Managing the changes in database structures in agile project with Oracle SQL Developer Data Modeler
To be able to be agile with the changes in database structures you need a tool. Oracle SQL Developer Data Modeler is a free to use tool that can be used for designing different kinds of databases, not just Oracle. The tool is integrated to Subversion to enable the versioning of data structures. The tool also supports reverse engineering to offer the possibility to reverse engineer a database structures to the tool. While the design is in place the tool offers several possibilities for comparing two designs or comparing a design and a database. In this session you will get answers to these questions: How do they work and when to use which? Can I get the ALTER clauses to get my database at the same level with a design? What are the differences on version 3.5 of my database design compared to version 1.7? And many more...
Opening the black box called "Cost Based Optimizer"
Many application developers and also some DBA beginners are desperate when they encounter a problem with the suboptimal execution plan. The very first thing is that they try to use some »good« trick which solved a performance problem in the past. Unfortunately the find out that the medicine does not help. So what to do now? The right answer is to bite into sour apple and open the black box called “Cost Based Optimizer (CBO)” and try to understand why for this statement the optimizer failed in preparation of optimal execution plan. In this session we will try to open this black box and see how it works. We will discuss the three measures: selectivity, cardinality and cost and how different features influence the CBO decisions. We will not step into deep technical details but will rather stay at higher level in order to get the overall picture how the CBO prepares the execution plan.
Analyze This! Practical Examples of Oracle Analytical Functions
If you’ve ever struggled with a particularly complex reporting request from an applications developer – for instance, returning just a specific set of rows from a subset of rows already extracted, or creating the equivalent of a Microsoft Excel pivot table, or producing a report with subtotals and subsections just like a spreadsheet – then this session is just right for you. We’ll demonstrate the basics of how to produce these complex output matrices with just a few calls to Oracle 12cR1 analytic functions and discuss how you applications developers (as well as Oracle DBAs) can leverage them for deeper insights into your database, and the performance of its application workloads. The presentation will offer real-world examples of how best to deploy these features, including detailed sample code that you can put to immediate use.
How do you process a million records into your database a day? Or bulk load several Terabytes of historic data? SQL is "the fastest", PL/SQL gives you far more control.
I've been designing and working with VLDBS for twenty years and I've made enough mistakes to learn a few things.
In this presentation I will show, with examples from real projects, ways of using SQL and PL/SQL to bulk process data, critical considerations and real-world lessons on how to manage the loading of data.
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.