Use docker and Oracle Dockerfile to easily install new Oracle client software.Read More >
Learn how to use Oracle Instant Client Docker images in your environment.Read More >
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 >
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 >
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 >
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 >
© 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.