Monitor Cassandra using Zabbix

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

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

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 gh-ost for online schema changes

The pt-online-schema-change tool has been a workhorse for years, allowing MySQL DBAs to alter tables with minimal ...

Protect against MySQL vulnerability CVE-2016-6662

Overview On September 12, 2016, a security vulnerability affecting all current versions of MySQL and its various ...

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

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

ORA-01156 when adding standy redo log in dataguard configuration

Database version = 11.2.0.3.0 If you get following error while adding a Standby Redo Log (SRL) to a standby database in ...

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

Add space to tablespace - corrective action in OEM 13c

OEM 13c came out with a good new feature as a corrective action to add space to tablespaces. It could be done in OEM ...

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

Auditing MySQL Users With McAfee Plugin

It is a common auditing requirement to log user connection events, including whether or not authentication was ...

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

Enabling achivelog mode in 12c RAC database

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

Cassandra 3.9 Security feature walk-through

As an enterprise level NoSQL database software, Apache Cassandra provides many out-of-the-box security features that ...