Database Administration & Monitoring

Transparent Data Encryption – Certificate in master database: is it really a good practice?

As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That's why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on(…)

Foglight

As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But(…)

PostgreSQL : Get my database server name

By Mouhamadou Diaw I was looking for a build-in function to get the hostname of the server hosting my PostgreSQL cluster. But seems that there is no build-in function. Looking in the extensions, I find the extension hostname which(…)

PostgreSQL 12 : New option –socketdir for pg_upgrade

By Mouhamadou Diaw PostgreSQL 12 is under development but tests can be done. Steps to install this version can be found in this dbi blog . Many thanks to Daniel. While reading the documentation I(…)

OEM Cloud Control 13c – Agent Gold Image

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I(…)

odacli create-database fails on ODA X7-2HA with java.lang.OutOfMemoryError

Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer(…)

Oooooops or how to undelete a file on an ext4 filesystem

It happens within the blink of an eye. A delete command was executed and half a second after you hit the enter button you knew it. That was a mistake. This is the scenario which leads to this blog entry(…)

OEM 13c Repository view gc$metric_values_daily

Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information:     The report displays the details for(…)

PostgreSQL 12: csv output format for psql

Getting data out of PostgreSQL in csv format is not a big issue. Using copy you can do that easily. PostgreSQL 12 will enhance psql so that you can directly return csv formatted output from a(…)

PostgreSQL 12: log_statement_sample_rate

A common way to identify long running queries in PostgreSQL is to set log_min_duration_statement to a value that is known to cause troubles. In other words: If you know most of your statements usually execute in(…)