All articles

Adaptive Plans and cost of inactive branches

By Franck Pachot . Here are the details about an execution plan screenshot I've tweeted recently because the numbers looked odd. It's not a big problem, or maybe not a problem at all. Just something surprising. I don't like when(…)

Initiate a local GIT repository in command line

Objective of the document is to describe how to start manually with command lines a development project, from an existing GIT repository. Usage of GIT protocol for software development empowers projects team management. It is intended to ease(…)

Auditing in PostgreSQL

Today, especially in the Pharma and Banking sectors, sooner or later you will be faced with the requirement of auditing. Detailed requirements will vary but usually at least tracking logons to the database is a must. Some companies need more(…)

Understanding Row Level Security on PostgreSQL

By Mouhamadou Diaw In this article we will talk about a nice feature Row Level Security on PostgreSQL. We are using EDB Postgres (…)

Rolling Invalidate Window Exceeded

By Franck Pachot . Today I was doing a hard parse storm post-mortem analysis. One hypothesis was rolling invalidation causing invalidation, but figures didn't match. I often reproduce the hypothesis to check the numbers to be sure I interpret them(…)

The fastest way to get the Oracle sample schemas

Do you need the Oracle sample schemas to do a quick test or demonstration? And, as always, you did not install the sample schemas when you did the setup of your environment? The probably fastest way to get them installed(…)

Filenames in AWR reports

By Franck Pachot . If you have read my latest blog posts, you know I've measured IOPS with SLOB to estimate ACFS overhead on a fast storage. This blog is about something I learned after wasting one hour on the(…)

Letting GoldenGate automatically maintain the insert and update timestamps on the target

Today at one of our GoldenGate customers we were faced with the following requirement: For one of the tables on the target we needed two additional columns which shall hold the insert and update timestamps for when the row was(…)

ODA X6 database classes and shapes

By Franck Pachot . On the Oracle Database Appliance, like on the Oracle public Cloud, you define the CPU capacity with ‘shapes’. On the latest ODA, the X6, we have a new interface to provision a database. Let’s look(…)

ODA X6 command line and Web Console

By Franck Pachot . The ODA X6 comes with a new command line (odacli) which replaces oakcli, and with a small web console which can display information about the appliance, the databases and the provisioning jobs. It also has the(…)