All articles

Find the SQL Plan Baseline for a plan operation

By Franck Pachot . If you decide to capture SQL Plan Baselines, you achieve plan stability by being conservative: if the optimizer comes with a new execution plan, it is loaded into the SQL Plan Management base, but not(…)

AWS RDS for PostgreSQL – 4 – Changing parameters

If you followed that last posts about DB Parameter Groups, Subnet Groups and Setting up the RDS instance you should have a running RDS instance. You should also(…)

Starting an Oracle Database when a first connection comes in

To save resources I thought about the idea to start an Oracle database automatically when a first connection comes in. I.e. if there are many smaller databases on a server, which are not required during specific times, then we may(…)

Cleanup a failed Oracle XE installation on Linux Mint

On this Blog I described on how to install Oracle XE on a current Linux Mint version (19.3. Tricia when writing the Blog). After the conversion of the Oracle provided rpm to a deb installation file with the tool(…)

Setup Oracle XE on Linux Mint – a funny exercise

On my old Laptop (Acer Travelmate with an Intel Celeron N3160 CPU) I wanted to install Oracle XE. Currently the available XE version is 18.4. My Laptop runs on Linux Mint 19.3 (Tricia). The Blog will describe the steps I(…)

AWS RDS for PostgreSQL – 3 – Creating the RDS PostgreSQL instance

In the last tow posts we had a look at DB Parameter Groups and Subnet Groups as these need to be ready when you want to deploy a RDS PostgreSQL instance on(…)

PostgreSQL 13: Backup validation and backup manifests

Currently a lot of stuff is being committed for PostgreSQL and what we will look at in this post is a feature, I am sure, a lot of PostgreSQL users have been waiting for for a long time: Finally there(…)

AWS RDS for PostgreSQL – 2 – Subnet groups

In the last post we had a look at DB Parameter Groups when it comes to AWS RDS for PostgreSQL. This is one of the first things you should think about. But(…)

AWS RDS for PostgreSQL – 1 – DB Parameter Groups

When your go for AWS RDS you can very quickly bring up a database instance and start using it. I've written about my thoughts using this approach here and really encourage you(…)

Some thoughts about working with/on AWS

In the last year working with/on AWS has become an almost daily task in my life as a consultant and trainer. From a trainer perspective there is not much to say about it because we use a very limited amount(…)