All articles

Installing ZFS on OEL7 UEK4 for Docker storage

By Franck Pachot . The Oracle Database is fully supported on Docker according that Linux is Red Hat Enterprise Linux 7 or Oracle Enterprise Linux 7 with Unbreakable Enterprise 4. This is documented in MOS(…)

Google Cloud Spanner – inserting data

By Franck Pachot . In a previous post I've created a Google Cloud Spanner database and inserted a few rows from the GUI. This is definitely not a solution fo many rows and here is a(…)

Control File issues on duplicating with non patched Oracle version.

Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or(…)

Restarting a failed transportable tablespace metadata import

I’m currently working in a project to migrate a 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(…)

Google Cloud Spanner – no decimal numeric data types

By Franck Pachot . Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages(…)

Drilling down the pgSentinel Active Session History

By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity,(…)

PGDay Amsterdam – follow up 2 – Where do null values go to in a hash partitioned table?

This is the second follow up which covers this question: When you hash partition a table in PostgreSQL 11 where do null values for the partitioned column go to? Lets go...

Database Vault : Rules, Rule Sets and Command Rules

By Mouhamadou Diaw In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database(…)

PGDay Amsterdam – follow up 1 – Adding columns with a default value and changing the default value right after

As always, this time during my talk about the PostgreSQL 11 new features in Amsterdam, there have been question I could not immediately answer. The first one was this: Suppose we add a column with a default value in PostgreSQL(…)

What a great event – PGDay Amsterdam

PostgreSQL conferences are always cool and this time it was in Amsterdam: PGDay Amsterdam. Beside that meeting all the great people was fun again the location was really outstanding: The TOBACCO Theater: Some(…)