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, ...

How to patch an exadata (part 5) - troubleshooting

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)

Simple steps to perform opatch maintenance with Ansible

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more ...

Standardizing the Oracle GoldenGate Home Path (OGG_HOME)

Introduction

I don't work with Oracle GoldenGate ...

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 ...

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 ...

Automation, PowerShell and Word Templates - let the technician do tech

In my work as a Database Consultant, I enjoy technical challenges, but it's always a painful process when I need to ...

Cloning Oracle grid infrastructure using Ansible

Sometimes your organization may decide to move to new hardware, to a new data center, and you, as an Oracle DBA, ...

How to analyze SQL server stack dumps

Troubleshooting SQL server stack dumps: A practical guide

As a SQL Server production DBA, at some point in ...

Dbatools and a SQL Agent

The mission:

Tell every DBA around the world about a secret formula that will give them ...

Database migration using Apache NiFi

Introduction

Bushy join trees in Oracle 12.2

Context

There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join ...

How to fix an AWR Warehouse after credentials change