Part 1: Oracle cloud database backup service

Oracle Cloud Database Backup Service (ODBS)

Network multicast support on Azure

OLTP type 64 compression and 'enq: TX - allocate ITL entry' on Exadata

Recently we've seen a strange problem with the deadlocks at the client database on Exadata, Oracle version ...

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 RAC on Azure

Microsoft Azure provides an acceptable and affordable platform for a training environment. I am an Oracle DBA, and ...

Part 2: Oracle Cloud Backups to AWS S3

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

Options for Tracing Oracle dbms_stats

A Baffling Case of ORA-00942

How to run OpenTSDB with Google Bigtable

In a previous post (

MySQL on AWS: RDS vs EC2

Three hidden Azure SQL database gotchas

Context

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

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Introduction

When you have a SQL Server environment where a very complex replication setup is in place, and ...

GoldenGate 12.2 big data adapters: part 1 - HDFS

December 2015 brought us a new version of GoldenGate, and a new version for Big Data adapters for the GoldenGate. ...

Benchmarking Google Cloud SQL instances

Google Cloud SQL is a fully managed database service that makes it easy to set-up, maintain, manage, and administer ...

Investigating IO performance on Amazon EC2

I published a blog post called "

Do AWR Reports Show the Whole Picture?

Introduction

AWR report is a great source of aggregated information on top activities happening in our ...

Backup Oracle databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take ...

Distinguish real SQL execution plans from fake ones!

As an Oracle DBA, one of our daily tasks is to optimize bad SQL statements that are affecting the system and causing ...

Google Cloud Dataproc in ETL pipeline - part 1 (logging)

Google Cloud Dataproc, now generally available, provides access to fully managed Hadoop and Apache Spark ...

DBAs: The 5 key skills you will need in the cloud

Like many organizations, yours is likely under pressure to reduce costs and resources, while increasing storage ...

Creating an external slave for a live AWS Aurora Instance

Overview

Investigating IO performance on Amazon RDS for Oracle

I've recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when ...

Permissions in Redshift administration