Oracle Team

PDB Snapshot Carousel Oracle 18.3

A new feature with Oracle 18c is the PDB snapshot carousel. As indicated by its name a PDB snapshot is a copy of a PDB at a specific point in time. You have the possibility to create up to eight(…)

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

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

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

Configure AFD with Grid Infrastructure software (SIHA & CRS) from very beginning.

Introduction : Oracle ASM Filter Driver (Oracle ASMFD) simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted. Oracle ASM Filter Driver (Oracle(…)

Masking Data With PostgreSQL

By Mouhamadou Diaw I was searching a tool for anonymizing data in a PostgreSQL database and I have tested the extension pg_anonymizer. PostgreSQL_anonymizer is a set of SQL functions that remove personally identifiable values from a(…)

[Oracle 18c new feature] Quick win to improve queries with Memoptimized Rowstore

With its 18th release Oracle comes with many improvements. Some of them are obvious and some of them more discrete. This is the case of the new buffer area (memory area) called the Memoptimize pool. This new area, part(…)