All articles

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

AUDIT_SYS_OPERATIONS and top-level operation

By Franck Pachot . SYSDBA is powerful. You should use it only when you need to. And you should audit what is done when connected SYSDBA. This is achieved by AUDIT_SYS_OPERATION. But do you have an idea how much audit(…)

Documentum Administrator UCF Troubleshooting

Maybe you had some issues with UCF in DA as me. I had this for no reason since few days at a customer. The problem was that we use SSL with DA and the Unified Content Facilities (UCF) wasn’t happy(…)

Neue Datenbank Konsole Befehle (DBCC) CLONEDATABASE

Sie haben es vielleicht noch nicht gesehen, aber mit den Service Pack 2 von SQL Server 2014 gibt es einen neuen DBCC Befehl: CLONEDATABASE. „DBCC CLONEDATABASE sollte Kopien eines Schemas und den Statistiken einer Produktionsdatenbank erstellen, um bei Leistungsproblemen Abfragen(…)