Oracle Team

ADWC: start/stop with PSM Command Line Interface

By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is(…)

ADWC: Creation of Autonomous Data Warehouse Cloud service

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with(…)

Oracle 18c clone PDB and Transparent Data Encryption

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)

Covering indexes in Oracle, and branch size

By Franck Pachot . A covering index is an index that contains all the columns required by your query, so that you don't have to do a TABLE ACCESS BY INDEX ROWID, which is the major cost of an index(…)

Automating Oracle Linux Installation with Kickstart

Automating Oracle Linux Installation with Kickstart Kickstart ? If you need to setup from scratch several Oracle Linux systems for your Oracle databases, it can be boring to repeat the install tasks again and again on each servers. Automation(…)

PgBackRest : Dedicated Backup Host

By Mouhamadou Diaw In previous blogs (blog1 and blog2) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration(…)

After IoT, IoP makes its way to the database

By Franck Pachot . At each new Oracle version, I like to check what’s new, not only from the documentation, but also from exposed internals. I look (and sometimes diff) on catalog views definitions, undocumented parameters, and even the(…)

Docker: efficiently building images for large software

By Franck Pachot . I see increasing demand to build a Docker image for the Oracle Database. But the installation process for Oracle does not really fit the Docker way to install by layers: you need to unzip the distribution,(…)

Docker-CE on Oracle Enterprise Linux 7

By Franck Pachot . Here is how I install the latest Docker version on Oracle Linux 7. You find several blog posts about it which all install 'docker-engine'. But things move fast in this agile world and docker package name(…)

Hash Partitioning in PostgreSQL 11

By Mouhamadou Diaw PostgreSQL 10 comes with partition support. But Hash Partitioning was not supported. PostgreSQL 11 will support Hash Partition. In the documentation we can read The table is partitioned by specifying a modulus and a remainder(…)