Index Advanced Compression: Multi-Column Index Part II (Blow Out)

I previously discussed how Index Advanced Compression can automatically determine not only the correct number of columns to compress, but also the correct number of columns to compress within specific leaf blocks of the index. However, this doesn’t mean we can just order the columns within the index without due consideration from a “compression” perspective. As […]

OOW2015 Middleware Management

This posting covers the Middleware Management sessions at OOW2015. Note that these are middleware management via Enterprise Manager, as opposed to sessions specifically covering middleware features and functions. Also, I have not duplicated here sessions I have already documented under Oracle Management Cloud or Private Cloud / DBLM, so please visit those posts for sessions that fall under both categories. The following sessions fall under this category:

  • The Management of Identity and Access: Breaches, (more...)

OOW2015 Database Manageability

This posting covers the Database Manageability sessions at OOW2015. Note that these are database manageability via Enterprise Manager, as opposed to sessions specifically covering database features and functions. The following sessions fall under this category:

  • Risk-Free Administration for Expert Database Administrators [CON9725] October 26, 4:00 pm – 4:45 pm | Moscone South—104 – The SPA Quick Check, SQL Performance Analyzer, Database Replay, and Concurrent Replay features in Oracle Real Application Testing provide a cost-effective and (more...)

Give it a REST Apex

REST or "Representational state transfer" to give it it's full name has been around for a while, i hear lots of people talking about it but to be frank i don't really have a clue what it's really about.

I tried to find a simple explanation by searching the net but couldn't really find one that just explained it in simple terms so i gave up.

Even the 'simple' wikipedia link didn't seem (more...)

OOW2015 Private Cloud and DBLM

Yesterday I posted an entry on what was coming with OOW2015, specifically discussing the Oracle Management Cloud sessions. This post is similar but looking at one of the more “traditional” EM areas that my team is responsible for – Private Cloud and DBLM. The sessions that are of most interest here are:

  • Hybrid Cloud Management Using Oracle Exalogic [CON9744] October 26, 11:00 am – 11:45 am | Intercontinental—Intercontinental B (5th Floor) – The latest version (more...)

Delphix Express : Free version of Delphix available

Delphix Express is available!

Delphix Express is a free version of Delphix

Delphix Express differs from Delphix enterprise in that it is limited to 25 GB of managed storage.

Screen Shot 2015-09-23 at 9.58.01 AM

To get a copy of Delphix Express go to

and put “Express” for your title and I’ll send you the download info.

Here is a video on installing Delphix Express on VMware fusion on my Mac.

Delphix Express can also (more...)

Online Training Ad: Oracle Database 12c – New Performance Features

On 10 December 2015 I’ll give an online training entitled Oracle Database 12c – New Performance Features. This short post provides key information about it.


With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12.1 is no exception to the rule. Notably, it introduces key improvements in three areas.

  • The query optimizer has been enhanced not only by the introduction (more...)


Here’s a little note that I drafted (according to its date stamp) in January 2013 and then forgot to post. (Which adds a little irony to the title.)


Here’s an object lesson in (a) looking at what’s in front of you, and (b) how hard it is to remember all the details.

I ran a script today [ED: i.e. some time early Jan 2013] that I’ve have no problems with in earlier (more...)

Controlling Execution Plans Workshop

I did a workshop at ECO 2015 today. It was a lot of fun. I’ve done numerous presentations on SQL Profiles, SQL Patches and Baselines in the past, but this session was a no-slides, hands on demo of some of the scripts I use. I also showed some scripts that can be used to re-write SQL on the fly using a new feature of 12c called SQL Translation Framework. Here is a zip file that (more...)

OOW2015 is almost here!

Hard as it is to believe, yet again it is time for the biggest Oracle conference on the planet (or any other planet for that matter!) Yes, OOW2015 is just around the corner! Unfortunately I won’t be there this year, as I have my eldest daughter’s wedding shortly after it, but nevertheless having seen what’s coming up from the Enterprise Manager side of the house, there are a few sessions I can certainly recommend.


5 Years of Delphix

Wow – 5 years have flown by. Five years ago I joined Delphix and five years ago Delphix began the virtual data industry. Like all successful technologies many other vendors have come into the domain.  Delphix for me is amazing compared to other virtual data solutions. Delphix is easy, fast and powerful. Check out this video of linking to a RAC database and provisioning a thin clone RAC database. How much work would it take to do the (more...)

Result Cache

Yesterday I thought I’d spend half an hour before breakfast creating a little demonstration of a feature; some time about midnight I felt it was time to stop because I’d found enough bugs to drive me up the wall. Today’s short post is just little warning: be VERY careful what you do with the PL/SQL result cache – if you use the results of database queries in the cache you may end up with inconsistent (more...)

Troubleshoot Oracle GoldenGate Using Exception Handler

By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism. When this happens you need to troubleshoot the issue and correct it before the Replicat process can proceed. But this wouldn’t be easy, as sometimes it can take […]

The post Troubleshoot Oracle GoldenGate Using Exception Handler appeared first on VitalSoftTech.

Bundle Patch or PSU on Windows

Well, honestly, have forgotten working on Windows platform administering Oracle databases. Recently, installed Oracle Database 12c on Windows and wanted to apply the latest PSU. Could not find the PSU, but found the BP (Bundled Patch) – hoped it the same and included more than a PSU! Had some challenges installing… did not remember to run […]

Connection shortcuts with a wallet

I’m lazy when I connect to the database, especially on my laptop.  Anything that saves a few keystrokes I’m keen on Smile

So rather than type “sqlplus username/password@database” I like to take advantage of a wallet

In my private sqlnet.ora, or the global one if it makes sense to do so, I add the details of wallet


This tells Oracle, that when I begins a connection to the database, we will (more...)

RAM is the new disk – and how to measure its performance – Part 2 – Tools

In the previous article I explained that the main requirement for high-speed in-memory data scanning is column-oriented storage format for in-memory data. SIMD instruction processing is just icing on the cake. Let’s dig deeper. This is a long post, you’ve been warned.

Test Environment

I will cover full test results in the next article in this series. First, let’s look into the test setup, environment and what tools I used for peeking inside CPU hardware.

I (more...)

Oracle 12c RAC on Oracle Linux 7 using VirtualBox

virtualbox I’m a little late to the party here, but I’ve finally got round to updating the VirtualBox 12c RAC article for Oracle Linux 7.

It’s not hard to do these VirtualBox RAC installations, but I find the process of putting the articles together really tedious. There are so many screenshots. That’s why it’s taken a while to build up the motivation to (more...)

Site Maintenance (20th Sept 2015 22:00 GMT) : Update

DiagnosticsLast night was the big server move. According to my monitoring, the site went down at approximately 23:30 GMT last night and was back again by 01:30 GMT this morning, so the site was offline for about 2 hours.

Everything looks normal to me this morning, so it I guess the move of my server between the racks in their data centre went OK. :)



Site Maintenance (20th Sept 2015 22:00 GMT) : Update was (more...)

Automation for DBA – Vagrant part 2


In the last post I presented steps to create Virtual Machine using Vagrant with Virtual Box. It is a native combination but there are other possibilities as well. This post will cover an integration of Vagrant tool with KVM hypervisor and AWS EC2 cloud.

In both cases, an additional plugins has to be installed:
-    vagrant-libvirt plugin for KVM -
-    vagrant-aws plugin for EC2 -

If there is a (more...)

Site Maintenance (20th Sept 2015 22:00 GMT)

DiagnosticsJust a quick heads-up about some work going on tomorrow on the website.

My hosting provider has decided my server needs to be put into a new rack, so somewhere after 22:00 GMT tomorrow (20th Sept 2015) the server will be switched off, moved to a new rack and switched on. They say the process should be complete within 4 hours. I’m hoping this is a massive overestimate. :)

If you are trying to use the (more...)