Author: Jared Still

Use docker and Oracle Dockerfile to easily install new Oracle client software.

Learn how to use Oracle Instant Client Docker images in your environment.

It has been asked “Why user Oracle’s ASM Filter Driver?”. Here’s one reason I found: ASM Filter Driver performs 20% better then ASMLib.

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…

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…

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…

Though the nature of applications has changed greatly over the years, some of the basic concepts of working with data are foundational, and do not, or at least should not, change. One of the precepts of Data Modeling is normalization;…

How much sand can you pour through a funnel? Perhaps this is something you have tried to do at some time. If you have, you would have found that to do so successfully it is necessary to control how much…

When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the statistics are up-to-date for all objects that are used in the execution plans. There are a number of…

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…