Bash performance tuning by example – How to delete 1 million files from file system, and how to do that fast?
In this article I’ll show my approach to solve real world performance problem by using bash scripting language. Problem statement is: How to delete 1 million files from file system, and how to do that fast? File system maintenance is important aspect of sysadmin job. It’s not only important to maintain file system, […]
This article has been motivated from real life issue experienced on Exadata system running a few dozen of Oracle databases. I have already written about Exadata shortcoming in one of previous articles where I stressed that one of the main disadvantages of Exadata machine is non-existent virtualization technology. Oracle recognizes Oracle VM as the only […]
Quite recently I had to trace/profile an extremely intensive batch job to provide information to Oracle for a further analysis. At very first moment it was obvious that this is a wrong approach and whatever we’ll get, it cannot server as evidence of performance issue that we have, as TKProf is designed to trace single […]
With the new version of SQL Developer 4.1, Oracle makes available early adopter of the SQLcl, a new tool that might replace SQL*Plus tool. I’ve make some tests with version last updated on September 14th, 2015 (version 18.104.22.168.257.0801). This is the list of features that I like the most. 1. autocomplete Better than rlwrap utility […]
SQL Developer has been my favorite tool for database development and administration from the beginning, as it has many advantages over commercial tools, neglecting the price difference. The name of the tool is a bit misleading as it suggest that the target audience are database developers, which is not correct. The main progress during the […]