Second wave of cloud migration

A second wave of cloud migration is now happening after the initial hiccups of


Reaction to Shadow IT

  • Misaligned Expectations
  • Increased Data Exposure and Administrative Surface Area of Risk
  • Choice of newer better cloud options now available after initial “wrong choice”
Reaction to Shadow IT: A significant amount of public cloud use over the past few years was done without IT oversight and approval. As companies develop their formal cloud (more...)

A blog related beer that I am currently enjoying

Currently drinking a bottle of this


I didn’t actually notice the name until I opened it tonight.

Tested 1000 Select Statements on New Exadata X5

I finished testing 1000 select statements on our new Exadata X5 to see if they would run faster or slower than on our older Exadata V2.  Our current production V2 has 12 nodes and the new X5 has only 2.  The memory and parallel server parameters on the X5 are 6 times are large as on the old one, since we have one sixth as many hosts and more than 6 times the memory and (more...)

JDBC connection samples in Oracle Enterprise Data Quality (OEDQ) to Oracle Service Name and MS SQL SSL

This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases.

First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name.


Fortunately, the JDBC connection option is available to take advantage of the connection string that can support Service Name and multiple hosts if needed.




Say DevOps one more time …

Screen Shot 2015-11-04 at 4.02.56 PM

Credit: Matthias Weinberger (CC2)

What is Devops?

As has been noted many of times, DevOps is a term that is hard to define.

DevOps is a term that is so easily misapplied in the enterprise that it’s popularity threatens adoption.

If you can’t define it for the bean counters – it might as well not exist at all.

 Tim O’Brien, Gleanster

Thus being able to clearly define DevOps is crucial to its success.


5 Things I wish I knew about APEX when I just started (part 5)

Using Advisor to increase the quality of your application.

For the last post in this series, I want to end with something that will help you improve the overall quality of your apex applications. That something is called: “advisor”.

The easiest way to access advisor is through the edit page. If you press the “utilities” button, and then select the option “check”, you will end up in an advisor report for the current page.

The (more...)

IDC report: Virtual Data 461% ROI over 5 years

read the full IDC report on Virtual Data here.



Here are some key sound bites from the report:

“Data has turned IT departments into business enablers. Data acts as a tax on IT operations when IT departments cannot do what businesses need them to do because they are too busy ‘keeping the lights on.’ ”

“When we bought Delphix, the original reason was all of the terabytes we were avoiding. But now, the main benefit for (more...)

Make it easy or die (software is eating the world)

Software is eating the world

  • We see taxis being beaten out by Uber and Lyft.
  • We see hotels being undercut by Airbnb.
  • We see brokerage firms undercut by Ameritrade and Etrade.
  • We see retailers under cut by Amazon.

Today it’s all about developing software that makes access to your product easier.

We are also seeing the same thing happen in IT where cloud such as AWS is undercutting industry hardware vendors like Oracle, Netapp, EMC


Steve Jobs : the journey of simplicity

Steve Jobs sets a great perspective on the journey of simplicity. It starts from simple, goes through complexity and ends up in simplicity. 

“When you start looking at a problem and it seems really simple, you don’t really understand the complexity of the problem. Then you get into the problem, and you see that it’s really complicated, and you come up with all these convoluted solutions. That’s sort of the middle, and that’s (more...)

Diff’ing AWR reports

I don’t know if you are ever asked to compare to AWR periods. AWR period comparison is pretty easy if you have access to the two periods in the same AWR repository. AWR in the same repository can be compared with

         [db_id ],
         [instance id],
         120, -- start snapshot id
         121, -- end snapshot id
         [db_id of target,
         [instance id] ,
         122, -- start snapshot id
         123  -- end  (more...)

The power of metaphor

We had a question on AskTom the other day, asking us to explain what a “latch” was.

A simple metaphor sometimes does the trick Smile




Here is a short video

D3 Show Reel from Mike Bostock on Vimeo.

Here is a longer tutorial video

Data-driven Documents from London Web Standards on Vimeo.

You can go through the actual presentation slides at
NOTE: these”slides” are active pages. You can click on the pages and interact with them.
They are in live d3. Try this page for example and click on one of the  points in the graph

OakTable video of myself and others

You can find the full length video of my Delphix talk that I did at OakTable World on Tuesday here: url

Also, the OakTable folks have updated the OakTable World agenda page with video of all the talks. This has lots of good material and for free. Scroll down to the bottom of the page to find the links to the videos.


Rittman Mead and Oracle Big Data Webcast Series – November 2015

We’re running a set of three webcasts together with Oracle on three popular use-cases for big data within an Oracle context – with the first one running tomorrow, November 3rd 2015 15:00 – 16:00 GMT / 16:00 – 17:00 CET on extending the data warehouse using Hadoop and NoSQL technologies.

The sessions are running over three weeks this month and look at ways we’re seeing Rittman Mead use big data technologies to extend the and capabilities of their (more...)

failed to create user while installing oracle 12c in windows server 2012 R2

When  I am trying to install oracle 12c software in windows server 2012 r2, Its asking the windows user credentials. So I had given the windows new user “Test” and password like ” Test@123″ . Oracle installer accepted this password but windows not accepted this password because of password poilcy.

  1. Atleast 8 characters inlcude letter, number, symbol
  2. Also Don’t put your password letter as same like user name. It should not be identical.

Example :

User (more...)

Webinar: Histograms: Pre-12c and Now

RSS content

To improve optimizer estimates in case of skewed data distribution , histograms can be created. Prior to 12c, based on No. of distinct values (NDV) in a column two types of histograms could be created :

if no. of buckets >= NDV, frequency histogram is created and the optimizer makes accurate estimates.

If no. of buckets < NDV, height balanced histogram is created and accuracy of optimizer estimates depends on whether a key value is (more...)

The Obligatory Post #oow15 Blog

I’m not much for non-technical posts, but @ThatJeffSmith told me I needed to blog more often and he has broad shoulders. Besides, OpenWorld was pretty good this year. Martin Widlake already blogged about how the user community makes OpenWorld a good experience. I second that, especially since I had the advantage over Martin of not […]

Final day – OpenWorld and Delphix Sync

This morning was my last day of Oracle OpenWorld sessions and this afternoon and evening finished off my day with Delphix Sync.

The first talk was my only NoSQL talk. It was interesting because the claim was that NoSQL was good for large numbers of simple transactions. This seems to be a theme across a couple of sessions. The funny thing is that the NoSQL code reminded me of my pre-SQL mainframe Datacom DB database (more...)

Wednesday OpenWorld

Well, it was a long day but it ended in a fun way.

Today I was back to the normal OpenWorld sessions starting with the general session. It was eye-opening because the speakers described a new CPU chip that they were using in their latest servers.  It had some custom elements to support database processing.  It was strange because I have recently been studying the latest Intel x86 documentation and it was interesting to compare (more...)

Tuesday OakTable World – brain fried!

Instead of going to the normal OpenWorld events today I went to OakTable World.  Now my brain is fried from information overload. :)

It started at 8 am with a nice talk about hash joins and Bloom filters.  Toon Koppelaars had some nice moving graphics showing how bloom filters work.  I’ve studied Bloom filters before but I’m not sure I understood it with the clarity that I had after this talk.

Then I did my talk (more...)