Database Administration & Monitoring

What are custom and generic plans in PostgreSQL?

I have already written a post about prepared statements in PostgreSQL some time ago. What I did not mention in that post is the concept of generic and custom plans. So lets have a look at(…)

Italian Oracle User Group Tech Days 2019

The Italian Oracle User Group (ITOUG) is an independent group of Oracle enthusiasts and experts which work together as volunteers to promote technical knowledge sharing in Italy.

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)

Restart a failed transportable tablespace import during a cross platform incremental backup migration

I’m currently working in a project to migrate a 11g-Datawarehouse-database from Solaris to Linux Intel (Endian-change). We do use the cross platform incremental backups method as described in My Oracle Support Note 1389592.1 for that. I.e. incremental backups are(…)

PostgreSQL 12: Detach postmaster process from pg_ctl’s session at server startup

Recently a commit landed in the PostgreSQL development tree that made me aware of something I did not know so far: When you start PostgreSQL with a script using pg_ctl and that(…)

PostgreSQL: When wal_level to logical

By Mouhamadou Diaw wal_level determines the quantity of information written to the WAL. With PostgreSQL 11 the parameter wal_level can have 3 values: -minimal : only information needed to recover from a crash or an immediate shutdown -replica(…)

Looping sssd_nss

Often Linux systems are connected to LDAP via sssd. A high CPU consuming sssd can be seen in top, like below ( e.g. 89.4 % CPU usage): 9020 root 20 0 1296344 466780 333364 R 89.4 0.8 41:20.17(…)

Red Hat Forum Switzerland 2019

Today (actually right now) we are a proud sponsor of the Red Hat Forum Switzerland 2019 in Geneva. With around 300 people attending this is quite a huge event and we had a lot of interesting(…)

Deploying SQL Server 2019 AGs on K8s with helm charts

This write-up follows my first article about helm chart with SQL Server. This time, I would like to cover the availability groups topic and how to deploy them with helm charts. In fact, to go(…)

Copy or Migrate a SSISDB environment

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate(…)