Oracle DBSAT Discoverer feature

Oracle EBS Vision Instance on docker

Continuing my previous efforts in getting docker running on Oracle Linux in this blog post, I worked on getting ...

Oracle parallel query hints reference - part 6: USE_PARTITION_WISE_GBY

Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is "brand new," introduced in ...

Text index usage within MongoDB

Igor Donchovski Published : Aug 24, 2023 Last Updated : Jul 30, 2018 3 min read

So you have a broken Cassandra SSTable file?

Every few months I have a customer come to me with the following concern: my compactions for one of my Cassandra ...

Troubleshooting RAC GoldenGate relocation

During Oracle RAC online patching, the GoldenGate resource must be relocated to a surviving node to maintain ...

MySQL plugin for Oracle Enterprise Manager 13c Cloud Control

This is the same

Oracle parallel query hints reference - part 5: PQ_DISTRIBUTE_WINDOW

Welcome to part 5 of the series.

Setting up MySQL encrypted replication on MySQL 5.7 with GTID

In this blog post, I'll walk you through setting up encrypted replication on MySQL 5.7 with GTID enabled. I will walk ...

Log buffer #551: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

EBS 12.2 issues seen in the wild

Recently, I was involved in an EBS upgrade project, and also in operational support of an EBS production environment. ...

Log buffer #549: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle, SQL Server and MySQL.

How to find unused indexes and drop them safely in MongoDB

Darshan Jayarama Published : Aug 24, 2023 Last Updated : Sep 27, 2018 2 min read

How to test an Oracle database upgrade using a physical standby

It was a Thursday morning. I started my day at work and found out that I was tasked ...

HugePages for Oracle Database in Azure Cloud

So, what's up?

Log buffer #555: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

How to efficiently back up and restore crontab

When a database environment is being patched, entries from crontab are commented and then removed when patching is ...

Authenticating MySQL 8.0 (Enterprise) against active directory

Recently our team was tasked to implement MySQL 8.0 in production for a client. While MySQL 8.0 is looking very ...

Installing Oracle 18c using command line

Introduction

Just three days ago Oracle released Oracle 18c for general installation on-premises. We've had ...

Does Oracle allocate PGA in HugePages?

The short question

How to manage multiple MySQL binary installations with SYSTEMD

This blog will go into how to manage multiple MySQL binary installations with SYSTEMD using the systemctl command. With ...

Choosing best index for your MongoDB query

Introduction

Indexing plays a quintessential role in database query performance and MongoDB is no ...

Getting started with Oracle Database Backup Service in 2018

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found

HugePages for Oracle database in Oracle Cloud

I recently published a

Airflow Scheduler: the very basics

Apache Airflow is a great tool for scheduling jobs. It has a nice UI out of the box. It allows you to create a directed ...

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on ...

Is slave_exec_mode idempotent actually idempotent?

Background

Co-Author: Rafael Alvarez When you look up the word