Author: Jared Still

How to create an Oracle 18c client image in Docker

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

Read More >

How to use Oracle Instant Client Docker images

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

Read More >

Improve Oracle Performance with ASM Filter Driver

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.

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 >

Normalize Your Database Tables for Optimal Flexibility

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;…

Read More >

How Many Sessions are Enough for Your Application Servers?

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…

Read More >

How to Display Database Statistics for All Objects Used in a SQL Statement

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…

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 >
Page 1 of 41234