Please turn JavaScript on
dbi Blog icon

dbi Blog

Following Dbi Blog's news feed is very easy. Subscribe using the "follow" button on the top right and if you want to, choose the updates by topic or tag.

We will deliver them to your inbox, your phone, or you can use follow.it like your own online RSS reader. You can unsubscribe whenever you want with one click.

Keep up to date with Dbi Blog!

Dbi Blog: Home - dbi services

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  1.15 / day

Message History

A SELECT SUM(v) over a 10,000-row table, under RCSI in Azure SQL Database, with STATISTICS IO on:

Table '[dbo].[t]'. Scan count 1, logical reads 330, physical reads 0, ... Object '[dbo].[t]'. Tempdb versions read 0, in-row PVS versions read 10000, off-row PVS versions read 210000, online index PVS versions read 0.

The Table line looks like a normal scan of 330 pa...


Read full story

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


Read full story
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:

{ "subject": "C=CH, ST=Zurich, ...",...

Read full story

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


Read full story

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


Read full story