Infrastructure at your Service

 
Daniel Westermann

Switching from CentOS 8 to Red Hat 8

By | Database Administration & Monitoring | 2 Comments

We have quite a few customers still running on CentOS 8 and you probably already are aware that CentOS 8 will be end of life by the end of this year. This forces a lot of companies to either switch to an alternative or to stick with CentOS stream. For most enterprise workloads CentOS stream is not a solution as it is rolling release, and if you want to keep a Red Hat compatible enterprise…

Read More
Mouhamadou Diaw

Install Enterprise Manager 13c R5: Check the db edition Failed

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database of the repository is an Oracle pluggable database 19.12 The server for the EM binaries has following OS [[email protected]:/opt/oracle]$ cat /etc/os-release NAME=”Red Hat Enterprise Linux” VERSION=”8.4 (Ootpa)” ID=”rhel” ID_LIKE=”fedora” VERSION_ID=”8.4″ PLATFORM_ID=”platform:el8″ PRETTY_NAME=”Red Hat Enterprise Linux 8.4 (Ootpa)” ANSI_COLOR=”0;31″ CPE_NAME=”cpe:/o:redhat:enterprise_linux:8.4:GA” HOME_URL=”https://www.redhat.com/”…

Read More
Lazhar Felahi

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

By | Database Administration & Monitoring | No Comments

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK COLLECT plus FORALL instead of standard Insert statement to insert data improve performance dramatically, let’s me show you : Here is a customer case on how using BULK COLLECT plus FORALL to improve Insert operations for…

Read More
Alain Fuhrer

DataPump and the Transform option – Not very well known, but it can be useful

By | Database Administration & Monitoring | No Comments

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of a 2TB database from AIX to Linux which means we had to change the endianness of the data. We decided to perform the Migration with Full Transportable database, convert the database files with rman and afterwards…

Read More
Daniel Westermann

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

By | Database Administration & Monitoring | No Comments

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a dedicated backup host for pgBackRest, which centralizes all backups of the PostgreSQL instances. Sometimes we have several of those, e.g. one for production instances, another for test and development or even a dedicated one for development. How you…

Read More
Christophe Cosme

SQL Server database design – Moving table to new filegroups

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction A database is very often created without thinking of its growing and in the most cases that is not really an issue until the data volume is not increasing a lot. And most of the time when a high data volume is expected, some actions are taken to organize the database in a more complex way, creating several data files or several filegroups with several files attached to them. But when the design has…

Read More
Steven Naudet

dbi Event Recap: SQL Server Automatic Tuning and Query Store

By | Database Administration & Monitoring | No Comments

Earlier this month, dbi services hosted a free multi-technology event. Details are available on our website. I had the opportunity to present a session about the Query Store and the Automatic Tuning feature available on SQL Server and Azure SQL Database. The first session in Lausanne was in French. A week later in Olten, I did it again in English. Session attendees learned: Query Store: Why, How, What? How to identify and fix a Plan…

Read More
Daniel Westermann

Minor PostgreSQL version upgrades in a Patroni cluster

By | Database Administration & Monitoring | No Comments

Last week PostgreSQL 14.1, and all other minor versions for the supported version of PostgreSQL have been released. As usual, it is highly recommended to update to the latest minor release as soon as possible. Minor version updates of PostgreSQL are just a matter of installing the new binaries, shutting down the old cluster and starting it up again using the new binaries, that’s it. If you are using packages the procedure is to shutdown…

Read More
Jérôme Dubar

Get prepared to move your Oracle databases to OCI

By | Cloud, Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you should consider if you’re using Oracle databases. But what do you need to plan before…

Read More
Steven Naudet

SQL Server: Is Fill Factor applied during INSERT?

By | Database Administration & Monitoring, SQL Server | No Comments

The Fill factor setting controls the amount of space that is left available on the index data pages. The goal is to allow new rows to be inserted or existing ones to change size (UPDATE)  without resulting in a page split. By default, the server setting is set to “0” which means that the leaf-level pages are filled to their maximum capacity (8060 bytes). The Fill Factor setting is not applied when data are inserted…

Read More