Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
Azure SQL automatic index compaction: lower your fill factor under continuous inserts
Does Azure SQL automatic index compaction fix UUIDv7 page density? Yes after a load, but with continuous inserts it needs a fill factor below 100.
-
PGConf.EU 2026 – Day 2 & 3
Vacuum and autovacuum I started the second day of PGConf.EU with a session about vacuum and autovacuum, presented by Teresa Lopes.After a short introduction to how MVCC works, she presented the different elements related to autovacuum:What are the different phases of autovacuum? What can trigger autovacuum? Which parameters can influence autovacuum? All these points were explained in a simple and…
-
Retrieving GoldenGate logs, reports, and diagnostics with the REST API
I often need to retrieve report files or logs from GoldenGate deployments, and I wanted to find ways of automating this. Hence this blog, about retrieving all available logs with GoldenGate REST API. I previously wrote about the GoldenGate log files. Some of them (extract.log, replicat.log and others) are in fact just filters of other logs (ggserr.log or restapi.log). These…
-
Oracle OHS 14.1.2 Upgrade: Cache Broke Authentication
During a recent Oracle Fusion Middleware upgrade from 12.2.1.4 to 14.1.2, I encountered an interesting issue with Oracle HTTP Server (OHS) and WebGate. The upgraded components were running, but WebGate initialization failed and the application was inaccessible. The root cause was not an incorrect OAM registration or a missing configuration file. It was a stale ObAccessClient.xml in the OHS/WebGate runtime…
-
Anatomy of an Enterprise Manager metric extension
Recently, I was working on deploying metric extensions automatically in Enterprise Manager, but the more I looked into it, the more it turned into a different question: what does a metric extension look like ? In a previous blog, I presented the SYSMAN tables containing the metric extensions definitions. I also showed how to retrieve the targets where a metric…
-
Why attend PGConf.EU? My feedback from Valencia
This week I was in Valencia for the PGConf.EU 2026, the biggest PostgreSQL conference in Europe. Something surprised me right at the start. During the welcome session on the first day, the organizers asked who was attending for the first time, and around 30% of the room raised their hand! I don’t know exactly what it means, maybe more companies…
-
Oracle Reports 14.1.2 REP-50125 – A Hidden REPORTS_JVM_OPTIONS Requirement
How bytecode analysis exposed an ORB initialization defect during an Oracle Fusion Middleware upgrade! Context During a recent Oracle Fusion Middleware upgrade from 12.2.1.4 to 14.1.2, I encountered an unexpected startup failure affecting Oracle Reports Server. The installation, domain upgrade and reconfiguration had completed successfully. The following components were operational: However, the standalone Reports Server components, RptSvr_1 and RptSvr_2, failed…
-
Oracle WebLogic Configuration Wizard Freezes on Linux
During an Oracle Fusion Middleware 14.1.2 upgrade, I encountered an issue while reconfiguring an existing Oracle ADF domain. The WebLogic Configuration Wizard launched successfully through SSH X11 forwarding, but the graphical interface became unresponsive during the reconfiguration. There was no obvious error message, and the wizard could not proceed. The solution turned out to be a single Java parameter. The…
-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 390,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,230 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,753 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,130 reads
Trending, last 30 days
-
PGConf.EU 2026 – Day 1
Welcome to Valencia! This year, the European PostgreSQL conference, PGConf.EU, takes place at the Palacio de Congresos in Valencia, Spain. I am lucky to be able to attend it with some colleagues from dbi services. Let’s see what’s going on there… I started the first day with a quick tour of the both of the different conference sponsors. I then…
-
SQL Server 2025: is optimized locking really working? Ask the Extended Events
How to check what SQL Server 2025 optimized locking really does with Extended Events: escalations, LAQ attempts and restarts.
-
How to detect a suspended GoldenGate extract
While testing EVENTACTIONS (SUSPEND) on an extract, I noticed that nothing in INFO tells you the process is suspended. The extract shows as RUNNING, the lag might look fine for a while, and yet it has stopped capturing. You may use SUSPEND on purpose (to pause an extract when a specific DDL goes by, for instance). Or someone else put…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.