All articles

Monitoring tools for PostgreSQL – pgcluu

The last posts introduced the logging system, pg_stat_statements and pg_activity. All of these can be used to monitor sql statements the PostgreSQL server is executing. In this post I’ll look into pgcluu:(…)

Control-M Application Integrator verwaltet Microsoft PowerShell Code & Credentials

Welche Vorteile hat “Control-M Application Integrator”? Bei einem Kunden, der Control-M im Einsatz hat, habe ich auf einem Windows Server ganz viele Windows und PowerShell Scripts angetroffen. Unter diesen Scripts waren einige die nach einem bestimmten Keyword in einem Log-File(…)

SQL Monitoring in PostgreSQL (3) – pg_activity

The last posts looked at how the logging system and the pg_stat_statements extension can be used to monitor sql statements in PostgreSQL. This post will introduce pg_activity which is very similar to(…)

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

SQL Plan Directive: disabling usage and column groups

By Franck Pachot . Yesterday I came upon a comment on oracle-l while I was reading my slides for the UKOUG TECH15 SuperSunday. I've one slide and one demo about disabling SPD usage but that's not(…)