Part 1: Oracle cloud database backup service

Oracle Cloud Database Backup Service (ODBS) This is part 1 of 3 in a series on "Getting Started with Oracle Cloud ...

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

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 up to 11." ...

Oracle RAC on Azure

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

Part 2: Oracle Cloud Backups to AWS S3

Getting Started with Oracle Cloud Backups - Amazon Web Services (AWS) This is part 2 of a 3 part series on "Getting ...

Options for Tracing Oracle dbms_stats

A Baffling Case of ORA-00942 Recently we had a good reason to find out what was going on behind the scenes with ...

How to run OpenTSDB with Google Bigtable

In a previous post ( OpenTSDB and Google Cloud Bigtable) we discussed OpenTSDB, an open source distributed database ...

MySQL on AWS: RDS vs EC2

When moving your MySQL instances to AWS, you would probably have to deal with this decision. This article will ...

Three hidden Azure SQL database gotchas

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

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 you need to ...

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. Let's ...

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 " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

Do AWR Reports Show the Whole Picture?

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

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

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 When working with Amazon AWS Aurora, there are some steps to consider when trying to get data out of an active ...

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

Permissions in Redshift administration

As with any database administration strategy, management of Redshift requires setting and revoking permissions. When ...

Virtual CPUs with Amazon Web Services

Some months ago, Amazon Web Services changed the way they measure CPU capacity on their EC2 compute platform. In ...

Oracle: What is an Unrecoverable Data File?

A data file is considered unrecoverable if an unrecoverable operation has been performed on an object residing in the ...