Speaker Details

Former Oracle ACE Director who has joined the Oracle Developer Advocates Team. Over the past 25 years, he has worked with systems in Australia, the United Kingdom, Southeast Asia, Western Europe, and the United States. He has co-authored three books and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has three times won the Best Speaker award by the UK Oracle User Group, and was awarded a Lifetime Achievement award by the UKOUG in 2016.

Link:
Paper Title and Abstract

Partitioning 101

Stream: DBA:DEV

A look at the partitioning options at your disposal in Enterprise Edition from its inception up to array of improvements that have arrived in 12c Release 2. We'll look at the various types of partitioning, how to decide whether you should be using it (since its an extra cost option), how to get the best out of it, and where it might trip you up.

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

12 things Developers will love about 12c Release 2

Stream: DBA:DEV

Lost in the mix of the cloud type has been the incredible list of new features for developers. Hundreds of improvements and new facilities have arrived in Oracle Database 12c Release 2. This session redresses the balance and excites developers with all the new Oracle Database 12.2 goodies

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

DBAs versus Developers: Who will win the war

Stream: DBA:DEV

For decades, developers and DBAs have battled over who controls the world. With each new development paradigm, the battle flares again as developers seek greater flexibility, less structure and faster turnaround to deploy, whilst DBA's seek a more methodical approach, they having seen the wreckage that can sometimes result from "fast and loose". But does that just make the DBA an inhibitor to productivity ? Who is right ? Perhaps both are ? Can developers and DBAs can peacefully coexist ? Maybe with the right technology and the right knowledge, they can have both. In this session, using real examples, we will explain how to integrate the demands of the modern-day developer with the Oracle Database.

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

12 things DBA will love about 12c Release 2

Stream: DBA:DEV

Whilst most fanfare on 12.2 is about cloud-first and sharding, there is a multitude of other enhancements that DBAs would benefit from immediately. This session focuses on a the lesser known but still critical new features and improvements in 12.2.

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

20 years of tips and tricks

Stream: DBA:DEV

A collection of hints, tips, tools, features and techniques that over the years I’ve either seen, built myself or simply stolen from somebody smarter than myself.

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

Taming the beast .... The 12c optimizer

Stream: DBA:DEV

A huge amount of changes were implemented in the optimizer for Oracle 12c. This session will get you prepared for the changes ahead, and give you tips for ensuring a smooth upgrade from 11g.

Pre-requisites: Just an interest in the topic.
Paper Title and Abstract

Pattern Matching - the most powerful SQL functions you've ever seen

Stream: DEV

Analytical SQL functions in 8i transformed the SQL landscape in terms of the power it yielded to database developers. Nothing has come to close to the functional impact until now. The pattern matching facilities in Oracle 12c make it easy to perform data analysis that was in the past simply impossible.

Pre-requisites: Just an interest in the topic.