All articles

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

Some months ago, I wrote a blog regarding a Windows Service not starting up with the error 1067. The first time I faced this(…)

Statspack installation scripts

By Franck Pachot . When Diagnostic Pack is disabled, either because you don't have Diagnostic Pack or you are in Standard Edition, I highly recommend to install Statspack. When you will need it, to investigate on an issue that occured(…)

#SwissPGDay is a place where you can meet developers of the PostgreSQL community

As the #SwissPGDay is located one hour south of  Zurich we traveled yesterday evening to Rapperswil, where is a nice little Swiss city. For the People coming one day before, Stephan Wagner organized a nice dinner in(…)

DataGuard and Transparent Data Encryption

By Mouhamadou Diaw Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will(…)

PGIO, PG_STAT_ACTIVITY and PG_STAT_STATEMENTS

By Franck Pachot . For an Oracle DBA, we are used to join active sessions (from V$SESSION where status='ACTIVE) with active statements (from V$SQL where users_executing>0) on the SQL_ID. V$ACTIVE_SESSION_HISTORY also displays the TOP_LEVEL_SQL_ID to get the entrypoint of the(…)

Lighty for PostgreSQL

By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)

Oracle Virtual Private Database

By Mouhamadou Diaw Oracle Virtual Private Database (VPD) enables you to dynamically add a WHERE clause in any SQL statement that a user executes. The WHERE clause filters the data the user is allowed to access, based on the identity(…)

Kernel panic – not syncing: Out of memory and no killable processes

By Franck Pachot . This is a quick post to give a solution (maybe not the best one as this was just quick troubleshooting) if, at boot, you see something like: Trying to allocate 1041 pages for VMLINUZ [Linux=EFI, setup=0x111f,(…)

18c: No Active Data Guard required (and detected) when only CDB$ROOT and PDB$SEED are opened in read-only

By Franck Pachot . When you clone a PDB on the primary CDB, you want that the same is automatically done on the standby ones. Unfortunately, for this operation, the CDB must be opened read-only. In 12.1 even the PDB(…)

Introduction to databases for {Power.Coders} with MySQL

By Franck Pachot . This week I took some days off to do something related to my job but a bit different. I've given a course on Databases and SQL. But not for my usual customers. And not(…)