The Sessions

This is the total list of titles and abstracts for the entire event. Each country will select the most relevant presentations for their members, so you’ll have to check your local event page to see which specific presentations you can look forward to.

Ludovico Caldara

Oracle Active Data Guard and Global Data Services in action!

Oracle Global Data Services (GDS) is a new 12c feature that facilitates enormously database services relocations across distributed environments. How does it work? How can we install it and configure it? Join this session to learn the answers. Live demos will complete the learning experience.

Adaptive Features or: How I Learned to Stop Worrying and Troubleshoot the Bomb.

Adaptive Dynamic Sampling, Adaptive Execution Plans, SQL Plan Directives: these new features are the new performance troublemakers when migrating databases from 11g to 12c. The optimizer uses them to seek for the perfect execution plan, but does it always succeed? This session will focus on the first steps required to quickly troubleshoot performance issues due to the adaptive features.

Oracle Database and Oracle ACFS: a lovely couple!

Oracle ACFS 12c supports Oracle Database files. Which new opportunities come out from this combination? What are the possible use cases? What about the performance? Join this session and learn more about this solution through graphs, examples and live demos.

Oracle Clusterware and Rapid Home Provisioning

Rapid Home Provisioning is a Clusterware feature introduced in 12.1.0.2 that simplifies the management and deployment of Oracle homes in a clustered environment. In this session you will discover the basics of this technology. Examples and live demos will complete the learning experience.

Migrating to 12c: 300 DBs in 300 days. What we learned.

For a customer in Switzerland, we are in process of migrating 400 databases to 12c. We have migrated 300 so far, and we have had good and bad surprises. This session will show a few scenarios that we faced during the upgrade project.

Self-Service Database Operations made easy with APEX

APEX can dramatically increase productivity through development of web applications. Even less skilled developers and DBAs can quickly develop solutions which facilitate everyday life. Join this session and learn how a big customer in Switzerland developed a Self-Service Database Operations Portal that reduced the routine tasks of the DBA Team by almost 100%.

Database Migration Assistant for Unicode (DMU): a Real Customer Case

DMU is the new tool introduced by Oracle for database conversion to the Unicode character set. Beside introducing briefly the tool, this session will focus on a real database conversion scenario faced by a customer, the problems encountered and the solutions.

Roel Hartman

Mastering the APEX Universal Theme

One of the most important features of Oracle Application Express 5 is the Universal Theme. This theme allows every database developer to create great looking applications without knowing any JavaScript, HTML or CSS.

But how do you make changes to comply to your company branding in such a way you don’t break anything else? And how do you add new templates and template options?

In this session you will learn how the Universal Theme works, what the components are and what you should and shouldn’t do when you make your changes.

Top 5 APEX JavaScript API’s

Oracle Application Express (APEX) is shipped with several JavaScript libraries, jQuery being the best known one of them. And on top of these libraries the APEX Development Team created their own. You probably used a couple of these API’s already, like $s, $v etc. 

But there are way more and some of them are extremely useful. But first you have to be aware they exists. And secondly you have to know how to use the properly.

This session will cover the most valuable JavaScript API’s with some real world examples.

Make your APEX Applications fly using JET components

At Oracle Open World 2015 Oracle introduced JET: JavaScript Extension Toolkit. In this session you will get a better insight what JET is and what it isn’t. We will also cover what APEX developers can learn from JET. And finally we will discover where the integration points are and we might even end up with a nice JET plugin!

The quest for the little gems in APEX 5.1

You have probably already heard about the stunning big new features of APEX 5.1, like Editable Grid, JET Charts and Live Template Options. But did you know that the APEX Development Team added a lot more gems in their product? Smaller gems, but definitely worth examining in some more detail.

In this session we will cover ten of those little gems that will make your upgrade to APEX 5.1 even more worthwhile!

John King

Oracle Database 12c New Features for Developers and DBAs

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements. An overview of Oracle 12c Multitenant Features (“Pluggable” databases; CDB &PDB) and In-memory Database are included too.

Using JSON in Oracle 12c

Oracle 12c added formal support for JSON data with the 12.1.0.2 update in July 2014. Oracle 12c stores JSON using standard Oracle character data types VARCHAR2, CLOB, and BLOB. A JSON-specific “IS JSON” test may be applied in CHECK constraints and WHERE clauses as can two other JSON-specific conditionals: JSON_EXISTS and JSON_TEXTCONTAINS. Three JSON-specific functions are also provided: JSON_VALUE, JSON_QUERY, and JSON_TABLE. Attendees will learn how to create tables using JSON columns, how to INSERT data into JSON columns, how to query JSON data, and how to use JSON_TABLE to represent JSON data as “normal” relational data.

To Cache or not to Cache; and How?

Recent advances in Oracle’s database have provided different statement caching

Options. SQL and PL/SQL performance may be improved by using caching features properly. This session will explore various statement caching features of SQL and

PL/SQL including SQL Statement Result Cache, PL/SQL Function Result Cache,

SQL WITH clause Function (12c), and PL/SQL PRAGMA UDF (12c). In this session, we will examine the performance benefits (and potential issues) of each method via live demonstration using Oracle SQL Developer and SQL*Plus. This session will also discuss the issues involved in using PL/SQL from SQL statements, and using SQL from PL/SQL.

DBaaS: Taking Advantage of Oracle Cloud Database 

Oracle has been the database leader for decades. Oracle extends that leadership to an industry-leading Database as a Service (DBaaS) Cloud Service. With Oracle’s DBaaS organizations can eliminate the need to identify, purchase, and provision new systems to accommodate changing and expanding database needs. Instead, we simply provision a database in the cloud, choosing from among many options to install a database instance of the size and type required in minutes (rather than weeks). Whether creating a production instance or building a test database the Oracle DBaaS makes things easy. In this session you’ll learn the capabilities of Oracle DBaaS, see a live demonstrations of the ease of deploying and using a new service.

Accessing Your Database in the Cloud; Oracle REST Data Services (ORDS) in Action

Many organizations store the “crown jewels” in their Oracle databases and need to make that data available easily to mobile and cloud-based applications. The modern world of services and microservices is increasingly reliant upon HTTP-style or REST-style APIs. Oracle’s REST Data Services (ORDS) make getting data from Oracle Database, Oracle Database JSON document store, and Oracle NoSQL data sources easy. In this session attendees will learn how to use ORDS to make data available using industry-standard API calls.

12c WITH or Without? Getting the Most Out of PL/SQL

Oracle 12c PL/SQL provides several performance-enhancing features including the ability to use WITH to define PL/SQL as part of SQL or PRAGMA UDF to anticipate processing. In addition, Oracle 11gR2 gave us the PL/SQL Result Cache and 12c adds INVOKER RIGHTS caching. This session will discuss how the different features work, what their strengths and costs are, and how to maximize performance by choosing features carefully.

UX is not UI

With the explosion of mobile apps; UX (User Experience) garners more attention with each passing day. Sadly, applications often focus on the User Interface (UI) rather on solving the problems faced by the application user. UX is the formulation of a strategy to provide a solution; UI is simply a small (but important part) of the overall solution. UX design focuses on a strategy to help the user accomplish a task directly and simply. This session will highlight the important facets of UX design and help attendees create more-useful applications.

Cloud: So Much More Than The Same-Old-Thing!

Cloud-this; Cloud-that; Cloud blah blah blah. Are you one of those who think “this is the same old stuff we’ve been doing for years with a new name”? Well, you’re a little-bit right, but mostly you’re wrong! In this session you will learn that the cloud is in fact a combination of features enabling your organization to maximize its IT resource while getting out of the data center business. Cloud provides a combination of on-demand self-service, broad network access, resource pooling, rapid elasticity, and measured service. Organizations use cloud Infrastructure as a Service (Iaas), Platform as a Service (PaaS), and Software as a Service (Saas) depending upon their need and their desire to manage the environment. Finally, choices must be made to use Public Cloud, Private Cloud, or a Hybrid Cloud. Attendees will understand the specifics of cloud architecture and how their organizations can leverage cloud to best advantage.

Martin Widlake

The Heart of Oracle – How the core RDBMS works

How does the Oracle RDBMS actually work? In this session I’ll tell you how, covering the core structures and activities that drive the RDBMS. Whilst this is an overview presentation it is still technical.

The session will help you better understand SQL and database performance, how data moves between disk, memory & your queries, how Oracle ensures you see a consistent set of data and, most importantly, what a “Consistent Get” actually is. And why the data files are less important then Redo.

If you can write a select statement you can understand everything in this talk – and might end up knowing some things most oracle professionals don’t know.

Understanding how the database works really helps you to use it more efficiently.

Tips on Bulk Data Processing with SQL and PL/SQL

How do you process a million records into your database a day? Or bulk load several Terabytes of historic data? SQL is “the fastest” but PL/SQL gives you far more control. Which is best? That depends on what your overall process is and how often you are running it.

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.

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. It is an urban myth that you no longer need to consider where your data actually is, if you care about performance that is.

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.

Calling PL/SQL from SQL – Performance, Practicality and Point-in-Time view

We can use PL/SQL to extend SQL in any way we want. A PL/SQL function is treated by SQL as though it is part of the language and gives us great flexibility to improve and simplify our code.

However, there are performance considerations with calling PL/SQL from SQL. In this presentation I cover those concerns and also enhancements in Oracle 12c & 11g that improve performance.

There are also dangers with calling PL/SQL function from SQL which are often overlooked. I explain those issues and how you can avoid them.