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
-
Avoid Oracle Passwords in cleartext with KeePass and Oracle Wallet
Interactive work How to avoid cleartext passwords with Oracle? In this post I will focus on databases with traditional accounts with username/password, and not on other authentication methods like kerberos (AD). For interactive work, it is not a problem, you can iteractively type the password At least on Linux, the sqlplus and rman tool will rewrite the commandline and hide…
-
SQL Server: How many row versions does an RCSI read walk?
How many row versions does an RCSI read walk when a transaction stays open? Measured with the new Azure SQL version read metrics.
-
Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study
I have written twice about what happens when a table replicated with GoldenGate has no primary key. I covered the common misconceptions about row identification and the risk of migrating tables with no primary key. Both explain why a missing key can be a real risk, but I often get asked what a missing primary key costs. Let’s address these…
-
Json and Oracle 19c
What is JSON JSON (JavaScript Object Notation) is a lightweight text format for storing and exchanging structured data. The information is organized as key–value pairs and lists. Assume we have server certificates in json form: Or as a one-liner As we can see, that’s simple ASCII text. And the certificate is usually around 2KB. So that it easily fits in…
-
Oracle RAC Clusterware upgrade 23.26.1 after 19.30 OC4J issue
If you planning to upgrade your Oracle RAC Clusterware from version 19.30 or higher to release 23.26.1 please be aware that this will not work as there is issue with de-supported qosmserver and OC4J resource come in 19.30 update. To avoid problem described below, install 23.26.4 which bypass this issue during upgrade. Always upgrade to version which was released the…
-
Default autoRestart delay breaking GoldenGate extract
When analyzing a customer’s GoldenGate deployment after a server reboot, I found a weird extract, which reported RUNNING. However, it was not extracting anything at all. Its report files were full of ABENDING entries. Here is a description of the problem, and what could have avoided this. managedProcessSettings ADD EXTRACT/ADD REPLICAT over the REST API accepts a managedProcessSettings object. It…
-
M-Files Cloud vs. Self-Hosted: Are You Really Better at Protecting Your Information?
We don’t want our data in somebody else’s cloud. We want to keep control of our information. I’ve heard this argument, or variations of it, many times when discussing ECM architecture with customers. It’s a perfectly legitimate concern. Information is one of an organization’s most valuable assets, and nobody wants to lose control over it. However, there is a question…
-
GoldenGate distribution path profile in 23.26.4.0.0
In a previous post about updating the profiles of all extracts and replicats at once, I wrote that a profile does not apply to distribution paths. With GoldenGate 23.26.4.0.0, that is no longer true. When looking at the help of ADD DISTPATH in the adminclient, it shows a new PROFILE clause: A distribution path or a receiver path can now…
-
Copy big dumpfiles between firewall zones
If you have to transfer a big Oracle DataPump export (dumpfiles) from one firewall zone to another, it is often not possible to transfer it directly from the source- to the destination-host. Instead, you have to transfer it to a jumphost (or your laptop), then from there to the destination host. But this is not optimal. You’ll need to store…
-
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 410,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,228 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,738 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,113 reads
Trending, last 30 days
-
applyOps and manual oplog replay for MongoDB PITR
mongorestore –oplogReplay gives you point-in-time recovery for a whole instance, replayed from the captured oplog of a single backup. It has no equivalent for a single database or a single collection. Say you need “restore just this one collection to 4:35pm” instead of the whole instance. The supported tooling has nothing to offer for in-place namespace point-in-time recovery (PITR). The…
-
Governing AI agents in ECM: Who is really in control?
In my previous article, M-Files AI: From Intelligent Metadata to AI Agents, I explored how AI in Enterprise Content Management has evolved. We have progressed from automatically classifying documents and suggesting metadata, to AI that can understand information, answer questions and reason about business context. Increasingly, it can also perform tasks. This evolution is exciting! Imagine an AI agent that…
-
Oracle Base Database Cloud@Customer
Base Database Cloud@Customer: is it an ODA Cloud@Customer?
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.