Exadata / Linux crash – capturing kernel dump on Linux systems
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 […]
Oracle tracing mechanism and when not to use it
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 […]
SQLcl tool – a modern SQL*Plus
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 4.2.0.15.257.0801). This is the list of features that I like the most. 1. autocomplete Better than rlwrap utility […]
SQL Developer 4.1 New Performance Related Features
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 […]