Unusual Use of the RMAN uncatalog Command
A fresh year is the perfect time to learn something new. Recently, I have come across warning...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Rman
Restoring a Dropped Oracle PDB Without a CDB Backup
Background I ran into a situation where we needed to restore just one dropped (and recreated)...
Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)
In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance...
Defining “real-time’ or ‘streaming’ analytics and its use cases
This is the first in a series on real-time or streaming data analytics best practices, including...
Oracle Cloud Infrastructure: Should you consider it for your Oracle database workloads?
Oracle users have had the ability to run database workloads in the cloud for years, but options...
How Linux Hugepages work to improve Oracle performance
This post is not intended to be an in-depth discussion of how Linux Hugepages work, but rather just...
Automating Oracle RMAN backup configuration on Linux with Ansible
Having valid backup of the databases is one of the most important tasks for every DBAs. Having...
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...
Duplicate indexes in MySQL
Why do we sometimes want to keep duplicate indexes? I’ve done dutiful DBA work in the past to...
Magic of "\d" in Vertica
A quick neat way to list down important and oft-needed information like names of databases,...
