Tag: Linux

HugePages for Oracle Database in Azure Cloud

So, what’s up? In case you don’t know, my co-worker Gleb Otochkin has written a couple of blog entries about HugePages’ support in different cloud providers here and here. Given that I am preparing a presentation about HugePages, I reached…

Read More >

Linux file system for SQL Server DBAs

With Microsoft releasing SQL Server on Linux and a lot of SQL Server DBAs coming from a predominantly Windows background, this post is going to arm the DBA with the fundamental knowledge of the Linux file system. If you come…

Read More >

Setting up Docker on Oracle Linux

Over the last couple of years, I have been hearing about Docker at different conferences. It’s a container technology that seems to have gained a lot of popularity. In recent months, I have started exploring how Docker can be used…

Read More >

BTRFS performance compared to LVM+EXT4 with regards to database workloads

Introduction In many database builds, backups pose a very large problem. Most backup systems require an exclusive table lock and don’t have any support for incremental backups; they require a full backup every time. When database sizes grow to several…

Read More >

Site reliability engineering – networking

Introduction In this blog post, I’m not going to talk about what the term SRE means or how it works. My understanding is that Google has invented the term “Site Reliability Engineer” and that this is Google’s way of doing…

Read More >

How to immediately kill ALL processes for a Unix user

On occasion I have found it necessary to immediately kill all processes for a particular user on a Linux or Unix server. It has been quite some time since I found it necessary to do so, and the occasions for…

Read More >

How Linux Hugepages work to improve Oracle performance

This post is not intended to be an in-depth discussion of how Linux Hugepages work, but rather just a cursory explanation. In the course of discussing this topic with many DBAs I have found that while many DBAs may know…

Read More >

CPU utilization is not a useful metric

Once upon a time CPU utilization was quite a useful metric. Following are the output of several tools that provide CPU utilization metrics: top top reports a load of 1.66. Is this correct? No. The correct load number is probably…

Read More >

Cleaning up PID files when Oracle GRID/RAC upgrades and patches fail

Unfortunately is it not all that unusual for a patch or upgrade to Oracle Grid or RAC to fail, requiring a rollback. Frequently when that is necessary, the rollback actions then also fail. The reason for the rollback failure is…

Read More >

The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)

We tend to configure a server following Oracle best practices for the kernel parameters, but what once was a server of a couple instances, soon becomes a huge and heavy environment with four, six or ten instances running on it…

Read More >
Page 2 of 712345...Last Page »