All articles

A SQLite extension for gawk (part II)

Welcome to part II of a three-part article on extending gawk with a SQLite binding. Part I is here. Part II is followed by(…)

An SQLite extension for gawk (part I)

Quick: what is the most used database management system on our planet ? Oracle ? Wrong. SQL server ? Wrong again ! MySQL ? You’re almost there. It’s SQLite. Surprised ? I must confess that I was too. Actually, SQLite(…)

Adding a timeout in monitoring probes

A few months ago day, as I was writing the documentation for a monitoring probe, I suddenly realized that that probe, along with others I wrote during that time to monitor Documentum installations, had all a big, unexpected flaw. Indeed,(…)

Documentum – Checking warnings&errors from an xPlore full re-index

When working with xPlore as a Full Text Server (indexing), there are a few ways to perform a full re-index. You can potentially do it from the IndexAgent UI, from the Dsearch UI, from the file system (with an ids.txt(…)

Oracle 18c : Active Data Guard and AWR Reports

By Mouhamadou Diaw Since Oracle Database 12c Release 2 (12.2), Automatic Workload Repository (AWR) data can be captured for Active Data Guard (ADG) standby databases. This feature enables analyzing any performance-related issues for ADG standby databases AWR snapshots for(…)

SQL Plan stability in 11G using stored outlines

Plan stability preserves execution plans in stored outlines. An outline is implemented as a set of optimizer hints that are associated with the SQL statement. If the use of the outline is enabled for the statement, then Oracle Database automatically(…)

Upgrade Oracle Internet Directory from 11G (11.1.1.9) to 12C (12.2.1.3)

There is no in-place upgrade for the OID 11.1.1.9 to OID 12C 12.2.1.3. The steps to follow are the following: Install the required JDK version Install the Fusion Middleware Infrastructure 12c (12.2.1.3) Install the OID 12C (12.2.1.3) in the Fusion(…)

Oracle 12.2 : Windows Virtual Account

By Mouhamadou Diaw With Oracle 12.2 we can use a Virtual Account during the Oracle installation on Windows. Virtual Accounts allow you to install an Oracle Database and, create and manage Database services without passwords. A Virtual Account can be(…)

MongoDB OPS Manager

MongoDB OPS Manager (MMS) is a tool for administering and managing MongoDB deployments, particularly large clusters. MongoDB Inc. qualified it as “the best way to manage your MongoDB data center“. OPS Manager also allows you to deploy a complete MongoDB cluster(…)

Java9 new features

Java9 is on its way now, in this blog I’ll talk about the new features I found interesting, the performances and so on. Configure Eclipse for Java9 Prior to Eclipse Oxygen 4.7.1a, you’ll have to configure eclipse a(…)