May 6, 2020 | Analytics, Episode 2
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...
May 5, 2020 | Database, Episode 2
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 ?...
May 5, 2020 | Database, Episode 2
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...
May 5, 2020 | Database, Episode 2
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...
May 5, 2020 | Database, Episode 2
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...
May 4, 2020 | APEX, Episode 2
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...
May 4, 2020 | APEX, Episode 2
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...
May 4, 2020 | APEX, Episode 2
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...
May 4, 2020 | APEX, Episode 2
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...
Apr 1, 2020 | Database, Episode 1
Materialized Views are very useful to increase the performance of frequently executed queries. In many database applications, Materialized Views are accessed directly using SQL. However, the use of Query Rewrite is much more elegant and flexible: The optimizer decides...
Apr 1, 2020 | Database, Episode 1
There isn’t a lot of documentation about Oracle database mutexes. And probably for good reasons: most of the time they are not an issue. This sessions is about when mutexes do take a significant amount of time, what you see and how to diagnose. Speaker: Frits...
Apr 1, 2020 | Database, Episode 1
Your report runs slow? DATABASE FAULT! Transaction performance is low? DATABASE FAULT! Application down again? DATABASE FAULT! And what about the rain? Wait, but what if not… ?In this talk we will analyze SQL performance from an app perspective, by analyzing a TNS...
