Creating a test lab using VirtualBox / NAT networking

My job is almost completely reliant upon my ability to perform work in lab of virtual ...

Tracking ASM Metrics

Collecting ASM IO Metrics

Part 1: Oracle cloud database backup service

Oracle Cloud Database Backup Service (ODBS)

Oracle EBS R12.2: Restarting online patching enablement patch

If you are in process of upgrading to Oracle E-Business Suite 12.2.4, you would have went though ...

Oracle ASM rebalance - Turn it up. To 11?

If you've ever seen or heard of the movie This is Spinal Tap, then you have likely heard the phrase "Turn it ...

Oracle E-Business Suite: Virtual host names

The ability to use virtual host names with Oracle E-Business Suite is one of the features that I ...

Online resizing of ASM disks

The SAN administrator recently informed us that several disks were extended from 300GB to 600GB. These multipath ...

Part 2: Oracle Cloud Backups to AWS S3

Getting Started with Oracle Cloud Backups - Amazon Web Services (AWS)

Using Docker to visualize MySQL performance schema

Context

Last week, I was pleased to present at Percona Live Amsterdam 2015 regarding the importance of ...

RMAN full backup vs. level 0 incremental

Full backup vs. level 0 incremental: a physical comparison

Perhaps you've wondered about this. What is the ...

Nagios authentication with active directory

Nagios authentication with Active Directory (AD) aligns with user management ...

Three hidden Azure SQL database gotchas

Context

Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end ...

Oracle 12c - adaptive query optimization

Scenario:

A user complains that a batch job that is critical for the month end business ...

Patching fun: GI and database patches

Intro

So, it has been some time since I have patched a database. Patching seemed necessary in a 12c ...

Import/export multiple SSIS packages

While I was working on a migration project recently, I had the task of importing and then exporting multiple ...

RMAN 11g : How to restore / duplicate to a more recent patchset

In an Oracle DBA's life, you'll be regularly asked to work on applying a new patchset on a ...

Migration of Oracle Database to Amazon RDS using Golden Gate

Migrating Oracle to Amazon RDS with Minimal Downtime

Amazon RDS is a web service used to manage databases, ...

Issues with Plan Cache Reuse & Row Goal Optimization

I am presenting here on behalf of my colleague Fabiano ...

High "cursor: pin S wait on X" waits?

If your system meets any of the following criteria:

Oracle upgrade failures due to METHOD_OPT and XDBCONFIG

Background

Autoconfig in Oracle EBS R12.2

The evolution of autoconfig in oracle e-business suite

All seasoned Oracle Apps DBAs know that Autoconfig ...

Implementing fuzzy search in SQL server - part 2: Levenshtein distance

Introduction

The Levenshtein Distance, as discussed in my

Windows containers: installing SQL server

This blog post is a quick introduction to Containers in the Windows world, and a walk-through on installing SQL Server ...

Magic of "\d" in Vertica

A quick neat way to list down important and oft-needed information like names of databases, schemas, users, tables, ...

Difference between Oracle's table and Mongo's collection

Roughly speaking, the notion of 'Tables' in Oracle is similar to MongoDB's 'Collections'. They are NOT identical ...

asmcmd> a better "du"

I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was ...

Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding ...

EM12c : Login to GUI with the correct password causes authentication failure

Troubleshooting an EM12c Login "Authentication Failed" Error

So the other day I was trying to log in to my ...

Permissions in Redshift administration