Database Administration & Monitoring

SQL Monitoring in PostgreSQL (2) – pg_stat_statements

The last post looked into how you can monitor queries using the logging system. This post will introduce pg_stat_statements. pg_stat_statements is a module that needs to be loaded and is not available in(…)

GoldenGate 12.2 additional column on the target

My colleague Hervé last week posted a blog concerning a bug in GoldenGate 12.1. You can find the blog here. In fact the problem is that GoldenGate works with the column position and not with the column(…)

SQL Monitoring in PostgreSQL (1) – the logging system

When developing an application as well as when the application is in production there is the need to identify long running queries. In Oracle one tool you might use for that is the SQL Monitor. In this post I’ll(…)

GoldenGate 12.2 new parameter ALLOWOUTPUTDIR

I will start a series of blog posts about the new features of GoldenGate 12.2. This first blog will be concerned by the new parameter ALLOWOUTPUTDIR. When I tried GoldenGate 12.2 for the first time, I reused the same configuration(…)

Manipulate Stretch database feature by script

On November 30th, I presented the Stretch Database feature in “Les Journées SQL Server 2015” in Paris. I explained how to manage by script this new feature in SQL Server 2016 CTP 3.0 I decided to share you my(…)

How to read XML database alert log?

Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was(…)

Upgrading PostgreSQL to a new major release

The last post looked into how to upgrade PostgreSQL to a new minor version. In this post I’ll look into how to upgrade PostgreSQL to a new major version. This is not as simple as just installing(…)

Patching PostgreSQL to a new minor release

If you are used to patch Oracle databases you probably know how to use opatch to apply PSUs. How does PostgreSQL handle this? Do we need to patch the existing binaries to apply security fixes? The answer is: No.

OCM 12c preparation: Manage PDB

By Franck Pachot . Let’s see the different ways to create a PDB, with different tools. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you(…)

OCM 12c preparation: Create CDB in command line

By Franck Pachot . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam - so don't expect any clue about the exam here.