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...
