All articles

SQL Server: why can’t I read the full table in parallel???

Why SQL Server keeps a full SELECT * serial: I/O cost is never divided across threads. Forcing parallelism burned 3x the CPU.

DDL filtering in GoldenGate extract and replicat

When replicating data with GoldenGate, you often want DDL changes (table alterations, new tables, dropped indexes, etc.) to follow alongside DML. But replicating all DDL is sometimes dangerous (TRUNCATE, DROP TABLE) or simply impossible (architecture differences between source and(…)

Listing and querying Oracle Enterprise Manager metric extensions

I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky. In fact, emcli(…)

Setup an LDAP server for Oracle naming on Enterprise Linux 9

Introduction To centralise Oracle naming resolution, you can use an LDAP server. You can use the commercial products from Oracle like Oracle Internet Directory (OID) or Oracle Universal Directory (OUD). Alternatively, you can also use OpenLDAP from your Linux(…)

Observability vs Monitoring

As engineers, we’ve all built dashboards, tuned alerts, and fought noisy monitoring systems. Tools like Elastic, Prometheus, Grafana, Zabbix, or(…)

TNS_ADMIN – which *.ora files Oracle will use

Introduction Oracle uses some configuration files (*.ora) related to the network. tnsnames.ora: A mapping of an alias name to a connect string for Oracle. A kind of “/etc/hosts” for Oracle databases ldap.ora: Configuration of ldap servers to use. A(…)

Moving JBoss EAP Workloads to OpenShift

More and more customers running traditional Java EE or Jakarta EE workloads are asking the same question: “We already use JBoss EAP. Should we move to Kubernetes or OpenShift, and do we need to replace the application server?”(…)

Oracle Forms: Java Web Start or FSAL?

A customer recently asked me about the difference between Java Web Start and the Forms Standalone Launcher for running Oracle Forms applications. I found it a very good question. From the user’s perspective, both methods look similar: the Forms application(…)

Oracle GenAI – Ask EM – Configure Oracle AI Database Assitant

Now that I have got an Oracle Enterprise Manager 24ai deployed in the cloud and an agent installed and configured on a DB System, I'm ready to configure OEM AI assistant. In this blog, I would like to guide you(…)

OGG-02454 Trail not found in checkpoint file when migrating a Coordinated Replicat

When migrating a Coordinated Replicat for a client, I faced a very specific OGG-02454 error that I wanted to share. When using the migration utility on a Classic Architecture Coordinated Replicat, every attempt failed at(…)