Monitor Cassandra using Zabbix

Zabbix is an open-source based enterprise level monitoring solution that aims for monitoring distributed network ...

Oracle E-Business Suite and Java Web Start. Finally!

Great things always happen overnight. That's probably the case for European Oracle Apps DBAs in the same situation, ...

Replicating users and tablespaces with Oracle GoldenGate

I decided to write this blog post after reading some comments on my older posts and several online discussions where ...

How to patch an exadata (part 5) - troubleshooting

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 5: Troubleshooting In this post I'll be sharing a ...

Parting with ocm.rsp isn't really sweet sorrow...

Context Now that we're well into 2017, let's sit back and ask the question: "What was the best news of 2016 in the ...

A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point. 1) Set the environment to ...

How to store performance counters directly on SQL server using TypePerf Command

Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive ...

How to patch an exadata (part 6) - timing

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 6: Timing Now that we know how to patch every ...

How to patch an exadata (part 4) - the rollback procedure

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 4: The Rollback Procedure You will most likely never ...

Using transportable tablespaces with partitioned tables

Overview In this post I will explain how to transfer a partitioned table using transportable tablespaces on MySQL 5.6. ...

ORA-30926 while using impdp over a database link

Background The other day I was doing an import using impdp in 12.1.0.2, and received the following error:'ORA-30926: ...

SQL Server default configurations that you should change

Who here takes the time to adjust default values for SQL Server Configuration after installing it? Unless your company ...

Simple steps to perform opatch maintenance with Ansible

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more ...

How to patch an exadata (part 3) - grid and database OH patching

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 3.4 Patching the Grid Infrastructure 3.4.0 - ...

Reading execution plans for parallel DML

Introduction: Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post ...

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

Using the MariaDB CONNECT engine to merge heterogeneous data sources

Background

AWS DMS tips for Oracle migrations

Investigating IO performance on Amazon EC2

I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

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

Cloning Oracle grid infrastructure using Ansible

Sometimes your organization may decide to move to new hardware, to a new data center, and you, as an Oracle DBA, would ...

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

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

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

Duplicate indexes in MySQL

Why do we sometimes want to keep duplicate indexes? I’ve done dutiful DBA work in the past to identify and remove what ...

Bushy join trees in Oracle 12.2

Context There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the ...