Star Schema Design in Oracle: Fundamentals
This post was originally published on this siteWhat are the design rules for good performance in a star schema in an Oracle database? This blog post series introduces some recommendations for the physical database design. This first post is about constraints and indexes. For the…
optimizer_secure_view_merging and plsql_declarations
This post was originally published on this siteThe Original Problem A customer is currently upgrading some Oracle databases from 11.2 to 19c. One query was extremely slow on the new test system and my job was to find out why. The root cause was that…
Bye Bye Trivadis
This post was originally published on this siteToday is my last day at Trivadis. I worked for this company more than 23 years, and most of the time, I loved my job. To conclude my time as a consultant and trainer, here are three funny stories…
Quoted Identifiers #JoelKallmanDay
This post was originally published on this siteBackground and TL;DR Connor McDonald wrote a blog post named Cleaner DDL than DBMS_METADATA. Back then he asked me if it would be possible to let the formatter remove unnecessary double quotes from quoted identifiers. Yes, of course….
DOAG2022 Highlights
This post was originally published on this siteNobody knows what kind of restrictions we will experience later this year. That’s why the DOAG Conference + Exhibition 2022 took place in September instead of November. The organizers wanted an in-person event. While you can access some…
Azure Tip 13: How to delete an Azure Tenant and a painful error message “Unable to delete tenant”
This post was originally published on this siteWARNING: Following the instructions in this post will delete a lot of things that can not be recovered! If you really want to delete a tenant, MAKE SURE YOU ARE WORKING ON THE CORRECT ONE! The author of…
Book Review: “Faster: How to Optimize a System” by Cary Millsap
This post was originally published on this siteThere are many books on performance optimization, but this one differs in a few ways. It is more of an entertaining collection of short stories, but with many educational messages. My travel plans for the Kscope22 conference in…
Deleting Rows With Merge
This post was originally published on this siteThe merge statement allows you to insert, update and delete rows in the target table in one go. This is great. However, the delete part does not work as expected. Is it a bug? No, it works exactly…
Testing With utPLSQL – Made Easy With SQL Developer
This post was originally published on this siteNowadays, everything is about automation. Software testing is no exception. After an introduction, we will create and run utPLSQL tests with Oracle SQL Developer for a fictitious user story. Our tests will cover a PL/SQL package, a virtual…