Episode 2

May 4th – 6th 2020

After a successful first try we are back with Episode 2 of ACEs@home. It is getting busy out there, a lot of online events are happening and therefore we tried to find a spot with little to no conflicts with other initiatives.

This means that the order of the days/topics is different but the format will remain unchanged: 3 half-days, each one with a main topic, 4 sessions each.

Based on feedback we slightly adapted the timing. The Zoom sessions will start at 12:50 CEST (06:50 EDT) to allow everybody to connect. We added a longer break between session 2 and 3, to give you time to get some fresh air, a drink or just answer that email which can’t wait any longer…

sponsored by
dbi services

Sponsored by dbi services
dbi services designs, develops and operates cutting-edge middleware infrastructure to allow its customers to focus on their core businesses.
With consultants who are experts in Oracle, Microsoft, Open Source, Cloud and ECM technologies, the company is equipped to offer tailor-made and efficient solutions. dbi services is based in Delémont, Basel, Bern, Nyon and Zurich, and employs 80 associates whose knowledge and skills are constantly progressing owing particularly to continuous training. With operations in Switzerland, but also in France and Germany, dbi services enjoys the trust of 300 companies – SMEs and multinationals – operating in various sectors.
www.dbi-services.com

Monday, May 4th

APEX

12:50-17:15 CEST
(06:50-11:15 EDT)

13:00 Alan Arentsen ACE Where it all comes together, secured payments with APEX
14:00 Niall Mc Phillips ACE Long Live Multimedia with APEX and REST!
15:15 Karen Cannell ACE Director Validate your APEX Validations: Both Sides Now
16:15 Tobias Arnhold ACE Fighting climate change with Oracle - a worldwide initiative

Tuesday, May 5th

Database

12:50-17:15 CEST
(06:50-11:15 EDT)

13:00 Christian Antognini ACE Director Shareable Cursors
14:00 Neil Chandler ACE Director Why Has My Plan Changed. Top 7 Plan Stability Pitfalls and How To Avoid Them!
15:15 Franck Pachot ACE Director 19 features you will miss if you leave Oracle Database
16:15 Flora Barriele ACE Associate
Martin Berger ACE
Keep them out of the database !

Wednesday, May 6th

Analytics

12:50-17:00 CEST
(06:50-11:00 EDT)

13:00 Becky Wagner ACE
Christian Berg ACE Director
Oracle Analytics Security - Everything you ever wanted to know but were too afraid to ask (part 1)
14:00 Becky Wagner ACE
Christian Berg ACE Director
Oracle Analytics Security - Everything you ever wanted to know but were too afraid to ask (part 2)
15:00 Abi Giles-Haigh ACE
Chris Saxon Oracle
Game of Fraud Detection With SQL and Machine Learning
16:00 Mike Durran Oracle Embedding with Oracle Analytics Cloud
Alan Arentsen
Karen Cannell
Niall Mc Phillips
Tobias Arnhold
Christian Antognini
Flora Barriele
Franck Pachot
Martin Berger
Neil Chandler
Abi Giles-Haigh
Becky Wagner
Chris Saxon
Christian Berg
Mike Durran
Mike Durran

Sessions details, recordings and slides

Mike Durran: Embedding with Oracle Analytics Cloud

The ability to embed your analytics from Oracle Analytics Cloud (OAC) is useful in a number of scenarios including the creation of custom applications that re-use analytics from OAC
as well as the integration of OAC analytics in your own websites. This session will discuss how to perform embedding of OAC content, starting with a basic example, we will cover the
end to end process for creating content in OAC, then how to reference that content outside of the core OAC instance in addition to options for authentication.

Speaker: Mike Durran
Title: “Embedding with Oracle Analytics Cloud”
Recorded on: Wednesday, May 6th 2020

Abi Giles-Haigh, Chris Saxon: Game of Fraud Detection With SQL and Machine Learning

Someone’s stealing money from the Iron Bank! After a series of fraudulent transactions, a huge sum of cash is missing.
But who’s the culprit?
This session will show you how to use SQL to implement simple rules-based analysis. It’ll then show you how to use machine learning to spot advanced fraudulent activity. This will cover the pros and cons of both approaches. Finally, demonstrating how a hybrid solution can give you the best of both worlds. The demonstration will be implemented in Autonomous Data Warehouse and Oracle Analytics Cloud for the Iron Bank.
This session is for developers, data scientists, and analysts searching for complex patterns in data.

Speaker: Abi Giles-Haigh, Chris Saxon
Title: “Game of Fraud Detection With SQL and Machine Learning”
Recorded on: Wednesday, May 6th 2020
Slides:

Becky Wagner, Christian Berg: Oracle Analytics Security – Everything you ever wanted to know but were too afraid to ask

Most analytics professionals sooner or later touch one part or another of Oracle Analytics Security but almost never mange to acquaint themselves with every single aspect of it. With the advent of the cloud vs on-premises split of the product line the topic has become even more of an interesting territory as the options branch out. This Oracle Analytics Security deep dive will cover detailed security topics in OAC and OAS, their usage and application, as well as compare what is different between them and new since OBIEE 12c.

Speaker: Becky Wagner, Christian Berg
Title: “Oracle Analytics Security – Everything you ever wanted to know but were too afraid to ask”
Recorded on: Wednesday, May 6th 2020

Flora Barriele, Martin Berger: Keep them out of the database !

Is it a no-brainer for a DBA to prevent unwanted connections to an Oracle database ?
In the form of a discussion, Martin and Flora address important organizational and technical issues regarding this topic.
How to grasp the business needs concerning access policies ? How to deal with a complex environment with hundreds of databases, from 10g to 18c ? What kind of technical solutions can be implemented according to a company’s situation ?
From both a technical and management perspective, they present benefits and practical examples of different solutions like Connection Manager, Database Service Firewall (ACL), logon triggers, audit & report methods, and to what extent you can combine them.
This presentation focuses on helping you understand the big picture and choose among different solutions what best fits your specific situation.

Speaker: Flora Barriele, Martin Berger
Title: “Keep them out of the database !”
Recorded on: Tuesday, May 5th 2020
Slides:

Franck Pachot: 19 features you will miss if you leave Oracle Database

Today, the choice of the database technology is in the hands of the developers, and Open Source alternatives look appealing. Many talks and papers show the growing features of MySQL or PostgreSQL, which competes with the commercial RDBMS. But do not forget the core features that are there for decades. They may not be there, or less efficient, in those alternative solutions. Let’s show those basic features, with demos: in-place updates, cursor sharing, guaranteed disk writes, advanced materialized views, IOT, wait events, online operations,… Many were already in Oracle 30 years ago and we take them for granted. We may not realize what we will miss when going to another RDBMS.

Speaker: Franck Pachot
Title: “19 features you will miss if you leave Oracle Database”
Recorded on: Tuesday, May 5th 2020
Slides:

Neil Chandler: Why Has My Plan Changed. Top 7 Plan Stability Pitfalls and How To Avoid Them!

When you write SQL, Oracle runs it through the Optimiser to determine the fastest way to access the data.
This access path sometimes changes without anyone noticing.
Sometimes it’s faster.
Sometimes it’s slower. Dramatically, catastrophically slower.
Why doesn’t Oracle always get it right? Why does it change?
This presentation will answer the question Why – through the use of live demonstrations, and explain what we can do to manage SQL execution plans within the database and minimise the opportunity for Oracle to get it wrong.

Speaker: Neil Chandler
Title: “Why Has My Plan Changed. Top 7 Plan Stability Pitfalls and How To Avoid Them!”
Recorded on: Tuesday, May 5th 2020

Christian Antognini: Shareable Cursors

The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused?
The aim of this presentation is not only to discuss what parent and child cursors are but also, and foremost, to examine in what situations it is possible to reuse them. In doing so, topics such as bind variable peeking, bind variable graduation, adaptive cursor sharing and statistics feedback will be covered as well.

Speaker: Christian Antognini
Title: “Shareable Cursors”
Recorded on: Tuesday, May 5th 2020
Slides:

Tobias Arnhold: Fighting climate change with Oracle – a worldwide initiative

The fabe team is building an app to help people stop climate change and human-caused extinctions by following a new 3Rs for the 21st century: reduce consumption, rescue species, and reconnect with nature. The team is all volunteer and distributed across the globe. We are using a 100% Oracle stack (Oracle Database on the Cloud, APEX and ORDS) to offer a mobile experience. We faced a number of challenges including:

  • How to make APEX work for a paradigm that is outside its “sweet spot”
  • Create an efficient workflow to take an idea through UI design to development and automated tests
  • Optimize interactions across cultures and timezones
  • Manage work-life balance and expectations

Speaker: Tobias Arnhold
Title: “Fighting climate change with Oracle – a worldwide initiative”
Recorded on: Monday, May 4th 2020

Karen Cannell: Validate your APEX Validations: Both Sides Now

Time to validate your APEX validation processes: Are you always validating client side and server side? Are you using the most efficient validation options? Are you up to speed on interactive grid validation options, single and multi-row? Are your validations firing all the time, when they are supposed to? Are you sure? If any of the above questions make you pause – attend this session on APEX validation processes and best practices.

Speaker: Karen Cannell
Title: “Validate your APEX Validations: Both Sides Now”
Recorded on: Monday, May 4th 2020

Niall Mc Phillips: Long Live Multimedia with APEX and REST!

Part of the Oracle database since Oracle8, Oracle have discontinued Oracle Multimedia as of Oracle 19c. This leaves existing customers with a dilemma, either keep their multimedia on 18c and put off the inevitable for as long as possible, or find another solution for image processing.We’ll take a look at some of the alternatives available to APEX and PL/SQL developers. In particular how to use RESTful web services to call a cloud providers to process images. Image resizing, watermark creation and other manipulations will be demonstrated.

Speaker: Niall Mc Phillips
Title: “Long Live Multimedia with APEX and REST!”
Recorded on: Monday, May 4th 2020

Alan Arentsen: Where it all comes together, secured payments with APEX

Every Oracle release new features are introduced, but when to use them?
In this presentation we are not diving deep into one specific feature but make use of a few to implement a payment interface with Oracle APEX.
You will see everything you need to know to build an interace like that.
I will also share the difficulties you will encounter building an interface like this.
So if you want to know more about a real life use case for authentication, REST communication, JSON in the database and Webhooks this presentation will certainly please you. I will use Mollie as a payment provider.

Speaker: Alan Arentsen
Title: “Where it all comes together, secured payments with APEX”
Recorded on: Monday, May 4th 2020