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…
plscope-utils for SQL Developer 1.0 – What’s New?
This post was originally published on this siteIntroduction PL/Scope is an SDK for source code analysis. It is available since Oracle Database 11g Release 1 and has been significantly improved in 12c Release 2. plscope-utils for SQL Developer is a SQL Developer extension that simplifies…
Last Week in Stream Data Integration & Stream Analytics – 13.7.2022
This post was originally published on this siteThis is the 247th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
Housekeeping in Oracle: How to Get Rid of Old Data
This post was originally published on this siteHave you ever tried to delete a few million rows from a table with several hundred milllions of rows with a DELETE statement? If yes, then you know that this is a very bad idea. With Oracle Partitioning…
Last Week in Stream Data Integration & Stream Analytics – 27.6.2022
This post was originally published on this siteThis is the 246th edition of my blog series blog series around Stream Data Integration and Stream Analytics! As usual, find below the new blog articles, presentations, videos and software releases from last week. Happy reading and stay…
NVMes write back vs. write through performance
This post was originally published on this siteRecently I was running some benchmarks to double-check that the performance of AMD EPYCs servers delivered by Company A, match the performance of those delivered by Company B. I was using our benchmark automation tool (about which I…
Data Vault versus Database Vault
This post was originally published on this siteIn the Oracle community, the terms “Data Vault” and “Database Vault” are often confused, although they have nothing to do with each other. A short clarification. Some time ago I had a meeting with the development team and…