All articles

How we build our customized PostgreSQL Docker image

Docker becomes more and more popular these days and a lot of companies start to really use it. At one project we decided to build our own customized Docker image instead of using the official PostgreSQL one.

La Suisse concernée par le RGPD ?

Le 25 mai 2018 entretra en application le Règlement Général sur la Protection des Données (RGPD). Il impactera toutes les entreprises opérant du traitement de données à caractère personnel sur des résidents européens. A l’aube de cette échéance, beaucoup de(…)

V$MYSTAT delta values

By Franck Pachot . Here is a little script I use from time to time to look at V$MYSTAT values and displaying on one line a set of statistics with their delta value between two calls.

Index seek operator and residual IO

This blog post draws on the previous article about index seek and gotchas. I encountered another interesting case but it is not so much because of the nature of the problem I decided to write this(…)

Windows Server – Service not starting with ‘Error 1067: The process terminated unexpectedly’

Some time ago, we were installing a Migration Center (from fmeAG) on a Windows Server and at the end of the installation, the service named Migration Center Job Server is configured and finally started. Unfortunately this didn’t go well and(…)

Documentum – DA 7.3 showing java.lang.NullPointerException on every actions

Last year, we started to upgrade some Documentum Administrator from 7.2 to 7.3 and directly after, we started to see some NullPointerException on the log files. We are using DA 7.3 on some recent WebLogic Servers versions (12.1.3, 12.2.1.2). We(…)

WebLogic – SSO/Atn/Atz – Infinite loop

This blog will be the last of my series around the WebLogic SSO (how to enable logs,(…)

Server process name in Postgres and Oracle

By Franck Pachot . Every database analysis should start with system load analysis. If the host is in CPU starvation, then looking at other statistics can be pointless. With ‘top’ on Linux, or equivalent such as process explorer on(…)

12cR2 PDB archive

By Franck Pachot . In 12.1 we had the possibility to unplug a PDB by closing it and generating a .xml file that describes the PDB metadata required to plug the datafiles into another CDB. In 12.2 we got an(…)

JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU

By Franck Pachot . If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is(…)