Harmonogram

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

After party