Database management

Oracle 21c: Attention Log – Useful or Superflous?

Attention.log is a feature, which was introduced in Oracle Database 21c, designed to capture high-level summaries of significant database events and activities. It differs from the alert.log in following points: High-Level Summaries: The attention.log focuses on summarizing critical and significant(…)

CloudNativePG – Storage

This is the next post in the series about CloudNativePG (the previous one are here, here, here, here, here and(…)

Cleanup Audit Trail – the Full Picture

Oracle Database 23ai introduces several enhancements to unified auditing, focused on flexibility, and effectiveness. Some of the new key features are: Desupport of Traditional Auditing: Traditional auditing is desupported in Oracle 23ai, which means all auditing must now be done(…)

Oracle 23ai New Backup & Recovery Features

In this article I will give a short overview of some Backup & Recovery features in the new Oracle 23ai database. Meanwhile there are more than 300 new features in Oracle 23ai most of them reflecting artificial intelligence. I will(…)

CloudNativePG – Scaling up and down

By now, if you followed the previous posts (here, here, here, here and here), we know quite a bit about how to use(…)

CloudNativePG – The kubectl plugin

As we’re getting more and more familiar with CloudNativePG, now it’s time to get more information about our cluster, either for monitoring or troubleshooting purposes. Getting information about the general state of our cluster can be easily done by using(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

CloudNativePG – PostgreSQL extensions

Now that we know how we can configure the PostgreSQL instance and access control, we’re going to look at what you can do when it comes to PostgreSQL extensions with CloudNativePG. As we have a running(…)

CloudNativePG – Configuring the PostgreSQL instance

In the last post we’ve created a more detailed version of the cluster definition for CloudNativePG. This gave us a PostgreSQL cluster with enabled data checksum, the correct locale, an increased size of the WAL segments and the possibility(…)

CloudnativePG – Bootstrapping an empty cluster

In the last post we’ve created a very simple three node PostgreSQL cluster using CloudNativePG and this was really easy to do. While this is great to get started quickly, you usually want to have(…)