Who's online

There are currently 0 users and 40 guests online.

Recent comments


Your Data Awakens : Delphix Express CloneAttack at OOW

Want a free version of Delphix Express installed on your computer with the assistance of Oracle and Delphix experts? We will be holding #CloneAttack again at Oracle Open World on Oct 27 from 1:30-4:30.

CloneAttack is a hands on labs to install a fully operation Delphix Express environment on your laptop.

The labs will be hosted at the Creativity Museum, which is at the corner of Howard St and 4th St above the carrousel,  on Tuesday Oct 27  1:30pm to 4:30pm.  Dell  and DBvisit will also beholding #ToadAttack and #RepAttack in the same location with us.


Delphix Express: rolling a VDB back

The following is an example of rolling a virtual database (VDB) back in time with Delphix Express, the free version of Delphix. Delphix by default keeps a 2 week window of changes for virtual databases (configurable to 2 months, 2 years etc). Thus we can go back in time to any point in that time window.

Why would we want to go back in time?

Maybe something went wrong. For example VDBs are typically used by developers who aren’t as versed in databases as a DBA.  What happens when a developer accidentally drops a table yet there was other work in the database that they want to keep. In the industry, half the time, developer databases are not backed up because they are “just development databases.” With Delphix those developer databases are always backed up and we can go back in time in a few minutes, so if a developer accidentally drops a table or updates the wrong column we can recover in minutes.

Delphix Express: refreshing a virtual database with source data

What if I’m a developer or QA person using a copy of production database to do my work. What if my copy of production is now out of date and I want to refresh my data with the data as it is on production.

Below is a video of how to refresh a virtual database to the freshest data from the source database:

This example uses the free version of Delphix called “Delphix Express” and  “Landshark” demo environment consisting of two VMs a source VM with a source database and a target VM with no database originally where we provision a virtual database.

Using DevOps Jetpack (a.k.a. Jet Stream)


photo by Chase Elliott Clark

Here a video on using Jetstream which I like to call “DevOps Jetpack for Developers” (Remember you can get Delphix Express and Jet Stream for free.) See previous blog post on how to set up Jet Stream.

DevOps Jetpack for Developers: Jetstream Setup

Delphix has a developer self service interface called “Jetstream.”  I like to call it the “DevOps Jetpack” for developers.

Jetstream is available both in the Delphix enterprise engine and also in the free Delphix Express engine.

See following blog post on users using Jet Stream.

Here is a video on how to setup Jetstream for two users, a developer (Joe Dev)  and a QA analyst (Jane QA). In a blog post to follow this one, we will see how Joe Dev and Jane QA can work together thanks to Jetstream which allows them to share versions of data (similar to how people can share versions of code with source control).

Passing parameters

I had an interesting question from a previous work colleague. She had a need to perform a query on attribute pairs. For the sake of discussion, we’ll assume that pairs are a shopping centre name, and a checkout aisle in that shopping centre.

So for example, on screen, a user may say:

Show me the sales coming through the following checkout aisles:


She had the beginnings of a package to solve the problem, but got stuck at when it come to referencing the two sets of attributes

Why I love working on AskTom

Today a question came in, and Swapnasis provided a nice simple test case, which makes my job so much easier.  Here’s a snippet from it

SQL> create table TTT(
  2    testid integer not null,
  3    value integer not null,
  4    time timestamp not null,
  5    unique(testid, time)
  6  );

Table created.

See line 5 ?

I’ve been working with Oracle for (well…I’d rather not say Smile) but lets just says “a number of years” dating back to version 6 of the database.  But in all of that time, I never knew that you could just write “unique”.  I have always done “constraint MY_CONSTRAINT unique (col1, col2)”.

IT operations made easier!

What kinds of things keep a IT ops person up at night?

What kinds of things make IT Ops people have to work over the weekends?

What keeps me up:

  • outages
  • performance problems
  • running out of disk space
  • corruption requiring recovery

These things are stressful.

One the most stressful things is recovering from corruption. Usually when there is a corruption, some important data and/or system is not accessible and won’t be until I recover the data. Now data recovery is not something I typically do everyday, so when I have to so it under pressure and using backups that probably haven’t even been tested for viability, then it’s a hugely stressful situation.

My sessions at OpenWorld 2015

OpenWorld is just around the corner, and I’m thrilled to be there again this year – it’s my first year as an Oracle employee, so it will be interesting to compare and contrast with previous years as an Ace Director.  I’ve got three conference sessions – I hope you can be there, and please feel free to come up and say “Hi”.

Click here if you’re using Schedule Builder, or just make a note of the details below



Virtualbox 5.0

I like it when stuff just “works”.

I’ve been using Virtual Box 4 for a long time now, and since my needs are relatively simple (ie, run a VM!) then I’ve not had any great cause to move to version 5.  But today I had a spare few minutes and thought “Well, its probably time”.

So the steps I followed were:

  • download
  • run the installer
  • start version 5

And .. well, all my stuff  (aka all my existing VM’s) worked just fine.  In fact, the only “error” I got was when I tried to start up too many of them at once and VirtualBox helpfully told me that I was either kidding myself or needed a better laptop.

This is how upgrades should be.  Simple and pain free.  Love it.

Downloads are here