Joël Cattin

Red Hat Enterprise Linux 8 – Stratis

The Initial Release (8.0.0) of Red Hat Enterprise Linux 8 is available since May 2019. I’ve already blogged about one of its new feature (AppStream) during the Beta version. In this post I will present(…)

Red Hat Enterprise Linux 8 – Application Streams

You may have heard that : Red Hat Enterprise Linux 8 is available for downloading in beta version since few weeks… You want to download it ? Click here. A significant change coming(…)

OEM Cloud Control 13c – Agent Gold Image

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I(…)

From Oracle to Postgres with the EDB Postgres Migration Portal

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover(…)

PostgreSQL – logical replication with pglogical

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called(…)

PostgreSQL 10 Beta 1 : pg_hba_file_rules view

This short blog to share a helpful stuff with the pg_hba.conf file : The pg_hba.conf file is the central configuration file to control client authentication. It is located in the database cluster’s data directory : postgres@ppas01:/u02/pgdata/PG10BETA1/ [PG10BETA1] ll(…)

Oracle 12cR2 : Optimizer Statistics Advisor

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations(…)

Oracle 12cR2 : Partitioning improvements – online conversion of a non-partitioned table to a partitioned table

It’s time to a new blog about partitioning improvement in 12cR2. After auto-list partitioning and multi-column list partitioning & read-only partitions, I’ll demonstrate how we can easily convert a non-partitioned table to a partitioned(…)

Oracle 12cR2 : Partitioning improvements – multi-column list partitioning & read-only partitions

In my last blog post I presented auto-list partitioning, a new partitioning functionality coming with 12cR2. In this one I will introduce two others : multi-column list partitioning and read-only partitions. Multi-column list partitioning Image :(…)

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic(…)