All articles

MERGE JOIN CARTESIAN: a join method or a join type?

By Franck Pachot . I'll present about join methods at POUG and DOAG. I'll show how the different join methods work in order to better understand them. The idea is to show Nested Loops, Hash Join, Sort Merge Join, Merge(…)

Backing up and restoring EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. The last blogs in the series are already some days old: Setting up MiniShift,(…)

New installed Fusion Middleware Reports or Forms WebLogic Servers fails to start after configuring SSL

We installed a Fusion Middleware reports and Forms 12.2.1.2.0 on a Linux Server. Those are single node Reports and Forms WebLogic Servers. After disabling the Non SSL Listen Port, we got the below error in the WebLogic Servers(…)

How much free space can be reclaimed from a segment?

By Franck Pachot . You have the feeling that your table takes more blocks than it should? Here are the queries I use to quickly check the free space. The idea is to call DBMS_SPACE.SPACE_USAGE and infer the minimum(…)

Catching interface state changes with Network Manager

Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As(…)

When does PostgreSQL create the table and index files on disk?

A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The(…)

Documentum – Silent Install – Docbroker & Licences

In a previous blog, I quickly went through the different things to know about the silent installations as well as how to install the CS(…)

Oracle 18c preinstall RPM on RedHat RHEL

By Franck Pachot . The Linux prerequisites for Oracle Database are all documented but using the pre-install rpm makes all things easier. Before 18c, this was easy on Oracle Enterprise Linux (OEL) but not so easy on RedHat (RHEL) where(…)

Documentum – Silent Install – Things to know, binaries & JMS installation

Documentum introduced some time ago already the silent installations for its software. The way to use this changed a little bit but it seems they finally found their way. This blog will be the first of a series to present(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).