All articles

How to destroy your performance: PL/SQL vs SQL

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing(…)

MariaDB: audit plugin

Why should you Audit your MySQL Instances? First to provide you a way to track user accessing sensible data Secondly to investigate on suspicious queries in all your critical databases Thirdly to comply with law and industry standards(…)

Partitioning – When data movement is not performed as expected

This blog is about an interesting partitioning story and curious data movements during merge operation. I was at my one of my customer uses intensively partitioning for various reasons including archiving and manageability. A couple of days(…)

Documentum story – ADTS not working anymore?

A few weeks ago, on one of our Documentum environments, we find out thanks to our monitoring that the Renditions weren’t generated anymore by our CTS/ADTS Server… This happened in a Sandbox environment where a lot of dev/testing was done in(…)

How to install Mirantis OpenStack 9.0 using VirtualBox – part 3

In the two first blogs, I installed the Fuel environment and deployed OpenStack in the Fuel slave nodes and all of that from the Fuel Master node. In this blog, I will show you  all the steps to follow in(…)

Documentum story – dm_LogPurge and dfc.date_format

What is the relation between dfc.date_format and dm_LogPurge? This is the question we had to answer as we hit an issue. An issue with the dm_LogPurge job. As usual once a repository has been created we are configuring several Documentum(…)

OTN Appreciation Day : External tables

As part of the OTN Appreciation Day (see https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/) I’m writing about one of my favorite Oracle features: External tables. Traditionally people loaded data in an Oracle database using SQL*Loader. With the introduction of external tables, SQL*Loader became obsolete (in(…)

How to install Mirantis OpenStack 9.0 using VirtualBox – part 2

The  last blog ended up with a successful installation of the Fuel Master. In this blog, I will deploy Openstack on the three Fuel slave nodes. The first node will be the controller node and all(…)

How to install Mirantis OpenStack 9.0 using VirtualBox – part 1

In this series of  blogs, I am going to  give a quick overview of OpenStack and learn how to install it using Mirantis. “Mirantis is the #1 pure play OpenStack company. More customers rely on Mirantis than any other(…)

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is(…)