POUG 2019

We’ll take a real SQL (or maybe two) and will walk through the steps needed to understand why SQL is running slower than it can, why Oracle is doing what it does, and possible solutions for these issues.

Not any new processors? Not any new disk arrays? The same SAN till the end of the time? Moor’s low not working anymore? Marketing instead of technology?

Over the last decades the enterprise class systems, and database systems as a part of it, was perceived as IT market locomotive.

It was reflected by technology trends, strong attention of most important vendors and – as a result - wide offer of new announced, truly innovative products.

The IT market is still growing dynamically and cover wider area of technology and users activities. The grow caused as an effect deep structural market rebuilding, which has close the market of enterprise solutions as narrow and shrinking niche. The consequences of it make important changes to Enterprise Solutions Market, IT environments and actual availability of new technologies. I have tried to summarize the prominent (and natural) trends from wilder perspective because we, professionals caring about business critical solutions deeply depends of them.

In this presentation Ron will discuss DevOps and the explore why automation is key to developer agility. Ron will demonstrate how automation can accelerate development and improve quality by ensuring consistent platform configurations and by delivering the right data to the right people, fast!

Join processing in relational databases involves combining the output of two row sources (e.g. tables) into one result row source. Most SQL analytic workloads are dominated by time spent in join processing because of the nature of the operation being heavily compute and bandwidth intensive. Oracle has developed numerous traditional join methods over the years (e.g. nested loop, sort merge, hash joins, etc.). Some of these methods have fallen out of favor over time by the optimizer (i.e. past), others are time-tested and commonly selected by the optimizer to this day (present), and then there's a new class of join algorithms which leverage the latest In-Memory Columnar data formats to deliver the fastest join evaluation known in industry (future). This talk will dive into the technical implementation details of Oracle's plurality of join methods (including specialized ones such as vector transformation which optimizes aggregations over joins), give insight into why the optimizer may choose one method over the other, and what the SQL and storage engines are actually doing under the hood to implement the join.

Going Serverless to a cloud-provider gave use some interesting experiences. The result was Positive, but with interesting lessons about the tools (java, pl/sql, python, docker and lambdas), the data, the (oracle-)database, and the people and processes needed to control the new situation.

SQL is in Relational Databases what PGQL is in the Graph Databases world (Oracle-wise). Did you ever think at challenging both solution? Doing the same job, compare how nice, easy, fast it is. Let’s see how it goes…

Geek man and Weed man are doing a Double Feature (2 continuous slots a 30 to 45 minutes needed).

Geek man aka Stefan Koehler Weed man aka Hatem Mahmoud

How to manage multiple of Oracle homes?
How to patch or upgrade many of databases?
Can it be done with a single button click?
The session will demonstrate the way to answer above questions using the Rapid Home Provisioning server. The main focus will be on the RHP functionalities that do not require additional licencing.

There’s an onslaught of Big Data coming to our IT shops - zettabytes of it! – but instead of your application developers struggling to learn new languages and techniques to analyze it, why not leverage Oracle Database 18c?

As a spoiler/teaser: the documentation is mostly wrong about it, and certain critical parts of parsing can be moved to execution time. Because what is happening is generally considered to be taking place at parsing time, that time is now spend in in sql execution in the statistics, however since it’s considered parsing, that time is added to parsing time too, making it hard if not impossible to understand the statistics if there are actual parsing problems.

Oracle Connection Manager (CMAN) is the Swiss-army knife for database connections. Starting with Oracle 18c, it has been extended with the new Traffic Director Mode (CMAN TDM), that allows transparent failover for applications that do not implement it natively. Come to this session to know more!

Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism and how you could apply this in pre-18c databases. After this session you will understand when to use which technique.

Oracle EE systems licensed to use the Diagnostics Pack offer a wealth of tools to assess performance. Analysts often resort to ASH and AWR reports, and often stop right there. Yet there is more! This talk features scripts contributed by renown performance experts helping you find problems quickly.

If you need a reliable database, but unsure about license costs, Oracle XE is for you.

This presentation will show you what you can do with Oracle XE, APEX, and new features as advanced analytics. The presentation is aimed at beginners, and people who mistakenly believe Oracle has to be expensive.

l’ve been benchmarking ORDS. I’ll cover why, how, and
things I’ve learnt along the way, including using reverse proxies to
cache responses and handle SSL certificates. I’ll share details of my
Vagrant build so you can check my findings. I’m assuming attendees
will have basic knowledge of ORDS.

Upgrades and Migrations work ALWAYS fine. Always?

What if … something goes terribly wrong? What if … you need to reverse to a state 3 days ago? What if … you don’t want to lose any data changes?

Then you need this talk showing you Fallback Strategies - Live and in Action with demos.

Everyone who had to go through a Oracle DBA Training knows the existence of DBA_FEATURE_USAGE_STATISTICS. If you have to take care of features used, inflexible regime of DFUS is boring. If you want to understand the moving parts behind the scene, this presentation will help you to reach your goal.

I’ve managed Oracle Compression for 8 years, anyone using, or planning to use Oracle compression needs to hear what I have learned.