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 >
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 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 >
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 >
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 >
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 >
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 >
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 >
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 >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.