Reducing Oracle TCO: Maximum Efficiency Architecture

IOUG Survey
Last year, Dell EMC sponsored the 2020 IOUG Database Priorities Survey. One of the questions was, “What leading factors do you weigh when selecting infrastructure for your Oracle environment?”

The number 1 factor respondents mentioned, was “Cost”. This confirms my own experiences when talking to our customers. High cost is often the main decision factor, followed closely by performance (#2) and a number of other factors, most of which I tend to categorize under the umbrella term “IT Operations”. As you may know from reading some of my other blogposts, I am passionate about achieving maximum efficiency for business applications – which is also the reason for choosing the name of this blog (Dirty Cache) since 2011. (more…)

 480 total views

We have moved!

Dirty Cache has moved to a new home: https://dirty-cache.com. New great content is coming up!

If you are a subscriber to my blog and you want to keep getting notices about new blog posts:

  • You’re an email subscriber: No action needed, I have moved email addresses to the new site
  • You’re a WordPress.com subscriber: Re-register on the new site via the SUBSCRIBE button with your email address. You will be informed from now on
  • You want to unsubscribe (email subscribers): Unsubscribe via the SUBSCRIBE section on the new front page.

Welcome back at our new site!

 452 total views

Oracle on VMware – The Final Frontier

Final FrontierA question I tend to ask my customers almost always is what their current state is regarding IT transformation and journey to the cloud. Of course such a strategy does not work very well on bare metal and some kind of isolation between services and physical hardware is required – which naturally includes virtualization, as well as the use of some kind of container technology, as-a-Service paradigms, changes in IT administration and operations etc.

Nearly always the answer includes “We already virtualized everything! … Well, ehm, except Oracle….”

TL;DR: There are no more roadblocks for virtualizing Oracle, including license issues. See the last section “Mythbusting” of this post for a summary on myths and truths.

(more…)

 879 total views

What was the name of that SQL script again? SQLWrap to the rescue!


If you are a frequent user of Oracle SQL*Plus, you probably also know about a tool called rlwrap. Bare SQL*Plus does not offer command history, arrow-key editing or any type of word completion so it feels like you’re thrown back in the late 90s using a Spartan SQL interface.

Prefixing “sqlplus” with “rlwrap” drastically improves usability as now you can easily edit your commands, recall history and possibly add a list of frequent used words for TAB autocompletion.

Alternatives are Oracle SQLcl, Oracle Developer or 3rd party tools like GQLPlus or Quest TOAD/SQL Navigator.

But for those who have to live with the natively provided SQLPlus, wrapping it in rlwrap offers an excellent user experience. You can even search the sqlplus history (type CTRL-R and enter parts of what you’re looking for). Many more keyboard shortcuts are available much like on the Linux BASH command line.
(more…)

 352 total views