Author: Jared Still

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 >

Oracle 12.2 ASM filter driver installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With the new image based Oracle Grid installation I expected this to be easy. To be fair, it was fairly easy,…

Read More >

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Note: This article was updated following Symantec Trust issues earlier in 2018. Sometimes I want to send email from my own databases for testing purposes. Lacking a mail server, I opted to use Amazon’s Simple Email Service (SES). SES is…

Read More >

Chart your course with sar

The sar (system activity reporter) is a Linux utility that actually started life long ago in System V Unix. In spite of its ancient origins, sar is still quite useful, and has even been enhanced in recent versions of Linux….

Read More >

Intel Skylake and Kaby Lake CPU Detector – Sherlock Holmes need not apply

Perhaps you’ve heard of the HyperThread bugs that are found in Intel Kaby Lake and some Skylake processors. (This article is intended for Linux based servers). No?  Then you may wish to read this article from the Debian support list:…

Read More >

Enqueue bytes – is that a pun?

Jared Still explains how to troubleshoot enqueue locking events in Oracle databases.

Read More >
Page 2 of 512345