POUG 2018

Database consolidation brings another level to performance analysis. How to measure shared resources utilization, interaction between workloads and consolidation efficiency when running tens of databases on single Exadata or SuperCluster node? To address this challange you should consider tools like Enterprise Manager, BI Publisher or even Python language with Pandas - and I will show you them in practice.

Terms "translation", "globalization" and "localization" are often used interchangeably, while the differences are quite significant. If we want to create professional international application we must not only care about language, but also about elements that appeal to regional or cultural preferences including text direction, formats, calendars etc.
During this presentation I will show:
- how localization process works
- how you can cover it in APEX using built-in features, plugins and open source projects like OraOpenSource and translate-apex.com
- how you can use good practice from video game industry to create international APEX applications.

You can’t see or modify data within a database without using some tool or driver. My job at Oracle is to provide productivity tools and data access technologies to simplify and improve application development with the Oracle database. This includes Oracle APEX, SQL Developer, JDBC, open source drivers, ORDS, and developer tools for .NET. All are free for use and work with our free Oracle XE database. In this session I will share how challenges are changing and discuss future direction at the intersection of application development and Oracle database.

Databases are going to the Cloud. Sooner or later. Most of them perhaps. How does this affect the DBA profession? Accenture conducted a battery of tests looking at Oracle databases in the cloud. Nearly half the world’s data runs on Oracle databases, making them a valuable focal point for such tests.

A well designed application should look beautiful and , maybe more essential, perform outstanding. In this session the focus is on the latter. With APEX it’s just too easy to make a mess of your application. Keep things structured and you’ll be happier.

Everybody knows the children’s book series “Where is Waldo?” and how hard it can be to find this guy in his red-and-white-striped shirt, bobble hat and glasses. The same problem applies to finding memory leaks in Oracle. This will be an interactive talk and with help of the audience I will work out and demonstrate a systematic troubleshooting approach for finding memory leaks in Oracle. Together we will analyze and drill-down a memory leak bug in Oracle’s core/kernel code with help of a very simple and pretty common application case. Be prepared to find Waldo aka. the memory leak!

In this session we will take a closer look on the options the new JET Charting engine brings to the APEX world. There are a quite a lot of declarative options to explore, but also the JavaScript API is worthwhile to investigate.

Container is a very hype and powerful concept. Oracle plans to invest heavily in this container world. In the cloud and by officially supporting database on docker. In this session, you will learn the docker internals and how you can use it to deploy your database environment in seconds.

We will first start with the parallel execution concepts, why do we need it and get understanding where we can benefit from parallel processing. Once we cover the architecture and build a solid ground we dive into more details.

The Oracle Database handles geo-spatial and location information since many years. But the technology still remains mysterious to many developers. This session will demystify what it is all about. Come learn the jargon and speak GIS like a pro! Learn how to use spatial data in your day to day work.

What is Machine Learning and why should I care? In this session we will talk about the basic concepts of Machine Learning.

Have you ever thought how parallel transaction replication internally works? How OGG ensures that all transactions are replicated in spite of using multi-threading and changed apply order. Let’s go into the internals and find out yourself how it is done in details.

Thanks to developers the DBA has a job he can go to. Usually we DBAs love our jobs, and we can feel progress in our projects. But after three years in one project, I realised that a few habits never go away. This presentation is about what the DBA can do to make the daily life in a project bearable.

Taking the first steps in understanding the model clause.

How many companies can afford patching their environments regularly? Patching and maintaining a big amount of Oracle Databases is perceived as complex by most companies. Is there a way to make patching simpler and more controlled? What are the best (and worst) practices for Oracle Home maintenance? What are the challenges of the new release model that will bring us one new major release per year?
In this session, we will explain some ideas to improve Oracle Home management and database patching, as well as practical examples of automated environments, live demos included!

Starting with Oracle APEX 5 we can develop APEX applications using Universal Theme. Customers high requirements shows that it needs improvments and I will show you how to extend UT GRID columns, enhance templates for APEX components and fulfill requirements using report, and region custom templates.

Have you ever tried to gather incremental statistics on a database with more than 300000 partitions? With Oracle 12.1, this can be a nightmare. Fortunately, Oracle 12.2 provides new methods for synopsis calculation and more flexibility in the configuration of gathering incremental statistics.

This is about the basics: the join methods. Not really new, but the core stuff that must be understood for any SQL query tuning. The approach is with a maximum of live demos: SQL Monitoring in slow motion too see how the rows are processed by each operation in the execution plan.

Everybody knows how important testing is, but hardly any developer writes repeatable tests. Sure we create tests to make sure our code works, but this is hardly repeatable. This session will show you how Unit Testing can help your developers getting more productive and confident about their code.

Unplug yourself from APEX’s declarative limits! But APEX declarative functionality is limited, not providing the full capabilities of what is possible with web technologies these days. Fortunately APEX offers a mechanism to expand functionality in a declarative way: Plugins.