Oracle Team

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(…)

Another surprising journey in Documentum-land

The journey begins In a VM Oracle VirtualBox with Centos Linux 7.0, you install Documentum v7.3 and create a docbase dmtest with its schema in a database on another VM running Oracle Linux. You start the newly created docbase and successfully(…)

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(…)

Result cache invalidation caused by DML locks

By Franck Pachot . In a previous post about Result Cache, I was using 'set autotrace on' in my session to see when the result cache hit saves the logical reads. I got a comment, by(…)