Infrastructure at your Service

 
Daniel Westermann

temBoard on SLES15 – 1 – The WebUI

By | Database Administration & Monitoring | No Comments

During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there are only packages for Debian and CentOS/RHEL. As temBoard is written in Python you can also install it using pip. That requires a bit more work compared to the package method, but it is perfectly fine. The only downside (but this is true for…

Read More
Dieter Henig

Clone a Terabyte Database in Seconds

By | Database Administration & Monitoring, Database management, DevOps, Hardware & Storage, Oracle | One Comment

Introduction Have you ever cloned a database using RMAN? Have you ever gotten the advice not to clone during daytime to avoid performance downgrade on the entire storage or network? For a proof of concept, we wanted to evaluate a Pure Storage array in terms of feasibility and speed of database cloning by using storage-based snapshot technology. First, I want to mention that PureStorage produces Storage devices in several sizes, all based on NVMe devices…

Read More
Franck Pachot

Some Artificial Intuition in Oracle SQL_ID?

By | Oracle | One Comment

By Franck Pachot . This post is something I discovered by chance when writing about tagging SQL statement with recognizable comments. We know that Oracle is introducing more and more artificial intelligence and machine learning in the database engine, but here is the first time I see something where random or hash values seems to bring some meaning. There are two common ways to run a query and find it in V$SQL: add some tag…

Read More
Joël Cattin

Automating Linux patching with Ansible

By | Ansible, DevOps, Operation systems, Security | No Comments

Since the beginning of the year, several vulnerabilities have been discovered in the Linux Kernel as well as in others important and widely-used packages. Among them, there was the famous CVE-2021-3156 affecting the sudo package and allowing any unprivileged user to gain root privileges. This one had a base score of 7.8, which is considered as high. This kind of events demonstrate the importance of having a strong patching strategy to ensure up-to-date softwares and…

Read More
Steven Naudet

SQL Server: Create a Shared Storage for your Failover Cluster LAB

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

I’m currently working on the migration of a Failover Clustered SSAS instance from Windows Server 2012 to Windows Server 2019. The context is quite complex and in order to choose the right migration scenario I need to play with it on my LAB environment first. I usually work with AlwaysOn architectures and it’s not often that I need to set up an FCI with its Cluster Shared Volume. As a reminder, a Cluster Shared Volume…

Read More
Grégory Steulet

Oracle Java Virtual Machine included in Oracle Database license ?

By | Database Administration & Monitoring | No Comments

Introduction A customer of mine asked me a licensing question regarding the usage or Oracle Java (OJVM) in an Oracle database.  Basically this customer have an Oracle Database Standard Edition License and would like to use Oracle JVM in order to load Java classes in his PL/SQL code executed by this database. The customer would like to ensure that his Oracle Database Standard Edition gives him the right to execute Java Classes in his PL/SQL…

Read More
Saïd Mendi

Working with multipass, a VM manager

By | Cloud, Development & Performance | No Comments

Introduction What if you need quickly to launch virtual machine instances running Ubuntu for development and testing purposes. Multipass from Canonical can be the right tool for this. You can even customize the instances during launch by using Cloud-init in order to simulate a small cloud deployment from your laptop or desktop. So, in this short blog post, I will talk about this tool and demonstrate how easy it is to use it.

Read More
Franck Pachot

Should CPU-intensive logic be done in the DB or in application server?

By | Cloud, Postgres | No Comments

By Franck Pachot . Should CPU-intensive logic be done in the DB or in application server? Here was a answer found in Reddit: Comment from discussion xpiv’s comment from discussion "Should CPU-intensive logic be done in the DB or in application server?". Reducing the CPU usage on the database server is a major cost saver with commercial databases, like Oracle Enterprise Edition where you pay license per core. But even in Open Source, on-premises or…

Read More
Lazhar Felahi

Oracle Data Integrator Cloud

By | Application integration & Middleware, Cloud, Database Administration & Monitoring, Enterprise content management, Oracle | No Comments

Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data from the source system and Loads and Transforms data into the target system while traditional…

Read More
Franck Pachot

ORA-32635: not a single cell reference predicate

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I spent 30 minutes to try to understand this error with a query that I’ve run in many environments for years. So if you google it you may arrive here and the solution may be checking whether you have NLS_COMP=LINGUISTIC SQL> alter session set nls_comp=linguistic; Session altered. SQL> alter session set nls_language=french; Session modifiee. SQL> select * from ( 2 select 42 snap_id,’TM’ type,’DB time’ name,0 microseconds from dual 3 )…

Read More
Clemens Bleile

Adding nmon to Oracle OSWatcher

By | Oracle | No Comments

nmon (nmon is short for Nigel’s performance Monitor for Linux on POWER, x86, x86_64, Mainframe & now ARM (Raspberry Pi)) is a nice tool to monitor a Linux system. Originally it came from the AIX-platform, where it is very popular. I asked myself if I can add nmon to the OSWatcher framework to automatically gather nmon data. It is actually possible. Here’s what I did: First I installed nmon: In my case (Oracle Enterprise Linux…

Read More
Daniel Westermann

PostgreSQL 14: LZ4 compression for TOAST

By | Database Administration & Monitoring | No Comments

In PostgreSQL a row or tuple can not span multiple pages (a page is typically 8kB), but of course you can store larger rows and PostgreSQL brakes and compresses these rows into smaller chunks by using a technique called TOAST. Once your table contains a toast-able data type a so-called toast table is created automatically. Up to PostgreSQL 13 you had no choice how the data is compressed, but a recent commit brings the option…

Read More