Understanding MySQL isolation levels: repeatable-read

Isolation levels are a rare subject in MySQL literature. The documentation provides a terse description and focuses ...

MySQL crashes on DDL statement: a lesson on purge threads

Restructuring your database environments can be a high-stakes operation. Recently, I’ve encountered several reports ...

Orphaned disks in OVM and what to do with them

Some time ago I was doing a maintenance on an OVM and noticed that it had significant number of disks without ...

Oracle E-Business Suite and Java Web Start. Finally!

Great things always happen overnight. That's probably the case for European Oracle Apps DBAs in the same situation, ...

Oracle GoldenGate microservices architecture - first try.

Three or four months ago Oracle released a new 12.3 version of the Oracle GoldenGate (OGG) software. The release did ...

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Note: This article was updated following Symantec Trust issues earlier in 2018.

Oracle database upgrade on RDS AWS and SPM baselines

Introduction

A couple of days ago I saw a question posted online asking about how AWS upgrades an RDS ...

Oracle 12.2 ASM filter driver installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With ...

Updating Elasticsearch indexes with Spark

With the extensive adoption of Elasticsearch as a search and analytics engine, more ...

Multi Tb migration using mydumper

In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, ...

Oracle Scheduler fail to send email notifications

Introduction

In this blog post I would like to share an interesting issue we encountered couple of months ...

Upgrade existing TDE to use new unified key management in 12c Upgraded Database (non-cdb)

Standardizing the Oracle GoldenGate Home Path (OGG_HOME)

Introduction

I don't work with Oracle GoldenGate ...

Ansible and AWS automation

Overview

Change of database passwords through OEM

Changing passwords for system database accounts is a necessary but often tedious routine. However, with ...

Automating password rotation for Oracle databases

Password rotation is not the most exciting task in the world, and that's exactly why it's a perfect candidate for ...

Idempotent and Nullipotent in Cloud

It’s funny how the more things change in tech, the more we end up reaching for those dusty university textbooks. ...

Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Very often when reading data, we need to locate the most current record for a set of conditions. One typical example ...

The data platform in the age of serverless architecture

“The transformation of the superstructure, which takes place far more ...