Jun 16, 2020 | Database, Episode 3
When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time and resources, but more importantly the same also applies to restores. RMAN has always provided a...
Jun 16, 2020 | Database, Episode 3
Oracle Data Guard is the premier replication technology for the Oracle database, Enterprise Edition. It has been around for what feels like eternities and yet there are quite few users of Data Guard who aren’t aware of the bells and whistles the product offers. And...
Jun 16, 2020 | Database, Episode 3
Nowadays we can have flexibility and quick-ingest capabilities of Data Lakes combined with data structuring, data integrity, security, and all the advantages of relational databases. We achieve this by integrating a flexible, scalable (object) storage layer with the...
Jun 16, 2020 | Database, Episode 3
Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example...
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...
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...
Apr 1, 2020 | Database, Episode 1
Automated Deployments save a lot of time. In this session shares, learnings from real-life projects and discusses challenges when you want to automate the deployment of your database application. Speaker: Jasmin FluriTitle: “Learnings of Deployment Automation...