BE SHARING

Database Administration & Monitoring

PostgreSQL 16: More I/O statistics

14.02.2023 by Daniel Westermann

PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: postgres=# select viewname from pg_views where viewname like '%statio%'; viewname -------------------------- pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_tables(…)

Cloud

Migration with Data Guard: Oracle on Windows AWS to Oracle Cloud Infrastructure (OCI)

13.02.2023 by David Carroll

Oracle offers a number of methods to migrate Oracle databases to the Oracle Cloud Infrastructure (OCI). From Data Pump through RMAN, Data Guard and even Golden Gate there should be a solution for just about everyone. However, most of these(…)

Database Administration & Monitoring

Upgrade OEM 13c from R4 to R5

24.01.2023 by Oracle Team

By Mouhamadou Diaw Upgrading Enterprise Manger Cloud Control can be tricky. In this blog I am describing an upgrade I did for a client. The source version is OEM13c R4 And the target version will be EM13c R5 Before(…)

Database Administration & Monitoring

How to submit a talk for a conference

23.01.2023 by Julia Gugel

I already did some talks at conferences and I had already the honor to select talks for a conference. During this talk selection I found some excellent examples on how to do to a proposal, but unfortunately also some examples(…)

Database Administration & Monitoring

SQL Server: Heap page deallocation and IndexOptimize

23.01.2023 by Steven Naudet

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.

Database Administration & Monitoring

PostgreSQL 16: reserved_connections

22.01.2023 by Daniel Westermann

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)

Database Administration & Monitoring

Converting from Unix timestamps to “real” timestamps in PostgreSQL

13.01.2023 by Daniel Westermann

Recently we’ve been asked how an application can be changed from using Unix timestamps to PostgreSQL timestamps. It is still not so uncommon to store dates and times in numeric data types,(…)

Database Administration & Monitoring

Patching ODA HA from 19.10 to 19.17

12.01.2023 by Oracle Team

By Mouhamadou Diaw In this blog I am describing an ODA HA (serveroda1 and serveroda2) patch from 19.10 to 19.17. The process is the same that patching a non-HA ODA. Few tasks may need to be done on both(…)

Database Administration & Monitoring

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

29.12.2022 by Daniel Westermann

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Database Administration & Monitoring

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (1) – The server

28.12.2022 by Daniel Westermann

Most of you probably heard of Red Hat Satellite, a product which is used to manage Linux infrastructures. Maybe you also heard about SUSE Manager, which does more or less the same(…)