Oracle Scratchpad

September 13, 2014


Filed under: Advertisements — Jonathan Lewis @ 10:29 pm BST Sep 13,2014

Update: I’ve been trying to embed the recording of the presentation in this note, but haven’t quite got there yet; however here’s a URL for the recording.


I’ve often found in my travels that I’ve come up with a (potential) solution to a problem and wanted to test it “right now” – only to run onto the horns of a dilemma. A typical client offers me one of two options:

  • Option 1: test it on the production system – which is generally frowned on, and sometimes I can’t even get access to the production system anyway.
  • Option 2: test it on something that looks nothing like the production system – and hope that that’s in some way a valid test.

The first option – when it’s offered – is quite stressful, especially if the original performance problem had involved updates; the second option – which is the commoner offer – is also quite stressful because it’s quite hard to prove that the fix is doing what it’s supposed and that it will do it at the expected speed when it gets promoted to production. What I’d really like to do is clone the production system and run tests and demonstrations on the clone. In fact, that’s exactly what does happen in some rare cases – but then it usually takes several hours (or couple of days) rather than the few minutes I’d prefer to wait.

This is why I like Delphix and why I’m prepared to say so whenever I see a need for it on a client site. It’s also why I’ve agreed to do a little on-line webinar about the product on Thursday 18th Sept at 10:00 am Pacific Time (6:00 pm UK time). The event is free, but you need to register to attend.


Disclosure:  The company paid me to visit their premises in Menlo Park CA last year so that I could experiment with their product and talk to their technical staff, without requesting any right to edit or limit any review I might subsequently publish about their product. The company has also paid me for my time for Thursday’s webinar but, again, has made no attempt to exercise editorial control over the content.




  1. From what I’ve read about it Delphix sounds like a very interesting technology.
    However, one should say that the scenario you described can be easily handled with Oracle-“On-Board-features”: Snapshot-Standby for example ( ) lets you have a test-system “cloned from production” within minutes, probably it is not widely-used ( and, yes, Delphix can do much more, so looking forward to attend the webinar )

    Comment by Matthias Rogel — September 15, 2014 @ 10:06 am BST Sep 15,2014 | Reply

    • Matthias,

      Indeed – and I have been on sites that have gone through multiple tests following cycles like:

      1. Switch standby to read-write
      2. Run test
      3. Flashback database to before test
      4. Repeat 2 and 3
      5. Switch back to standby

      In the case of Delphix, though, I can say: “I want to test it right now – but against the database as it was at 2:45 yesterday morning”.

      Comment by Jonathan Lewis — September 15, 2014 @ 5:26 pm BST Sep 15,2014 | Reply

  2. […] are Jonathan’s slides and recording of the […]

    Pingback by Kyle Hailey » Jonathan Lewis explains Delphix internals — September 22, 2014 @ 2:55 pm BST Sep 22,2014 | Reply

  3. Et tu Brute?

    Comment by mgogala — August 28, 2016 @ 8:25 am BST Aug 28,2016 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by