Database Administration & Monitoring

ARRAYSIZE or ROWPREFETCH in sqlplus?

ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)

Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch

During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)

One Host, multiple PostgreSQL Clusters – Monitoring using EDB PEM

At a customer we implemented the EDB Postgres Enterprise Manager. As they run multiple PostgreSQL cluster on one server, they wanted, for sure, to monitor all the cluster using PEM. This blog should give you a short guidance on(…)

Jenkins X ecosystem: Kaniko as image builder

For a few months now, we started a huge project at a customer; build a complete CI/CD platform for Documentum. The final goal is to create a CI/CD process for platform and software delivery to reduce as possible the delivery(…)

Power BI Report Server – Kerberos Advanced configuration

Introduction Following the basic configuration explained in a previous blog (Link), I describe here how to make more advanced configurations in some specific cases but often met by customers. It is only complementing what has being described in the(…)

Documentum – MigrationUtil – 5 – Change Installation Owner

The Documentum installation owner is the operating system user that owns the server executable and other related files along with the OS process when the server is running. It is originally determined when the server is installed, in fact, it(…)

SQL Server – Collecting last backup information in an AlwaysOn environment

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with(…)

Upgrade your Power BI Report Server

Introduction Even if upgrading your Power BI Report Server is straight forward, I have been asked many times where to find the installation files and how to run it that I thought a blog is worth it. Before you start(…)

Real time replication from Oracle to PostgreSQL using Data Replicator from DBPLUS

I've done quite some real time logical replication projects in the past, either using Oracle Golden Gate or EDB replication server. Build in logical replication in PostgreSQL (which(…)

Focus on 19c NOW!

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases.