Archive for August, 2014

7 Ways Data Virtualization Helps CIOs

August 28th, 2014

IDC study found that Delphix

  1. Pays for itself in 4.3 months
  2. ROI 461% over 5 years
  3. $1 Million storage and hardware savings
  4. $50 Millionannual  savings for companies over 75,000 employees
  5. $78,500 saved per year per 85 employees
  6. $85,000 annua lIT efficiency per 100 employees
  7. 98.6% storage reduction on a 2.42 TB database footprint


Screen Shot 2014-08-12 at 10.26.54 AM

Screen Shot 2014-08-12 at 10.27.20 AMScreen Shot 2014-08-12 at 10.27.29 AM


Oracle performance video library

August 27th, 2014

Here is a series of Oracle performance tuning videos that I put together recently at Delphix. All the presentations are free and open to the public, just have to register.



Successfully managing a modern organization’s complex data estate requires careful work at multiple layers, from the implementation of organization-wide data policies and platforms to the careful tuning of particular databases. Only with optimization at every level can data achieve its full potential, enabling the organization.
In this webinar series, Kyle Hailey demonstrates field-proven best practices to measure and optimize database performance, and to present compelling results to end users.

Other Videos

ECO database virtualization 2013

Databases and Instant Cloning 2012

Delphix and Pure Storage 2013

Denver DevOps 2014

ASHmasters OOW 2014

Lies, Damn Lies and I/O statistics

Visual SQL Tuning NoCOUG 2014

Visual SQL Tuning 2014 @ Delphix

Virtual Data Platform : Kscope 2014





Greening of Storage

August 26th, 2014

By Tim Gorman

I recall that the Dec 1999 or Jan 2000 issues of Nat’l Geographic magazine had a “Letters From The Editor” column that speculated, in jest, that the rate at which humans were saving back-issues of Nat’l Geographic magazine, would by the year 2100 result in the total accumulation of yellow magazines outweighing planet Earth.

Anyway, that statement resonated with me, because although I change residences every few years, it has only been recently that I hadn’t packed and carried my decades of accumulated Nat’l Geographic magazines with me.  Now that I’m free of them, I have no idea why I schlepped them with me for so long.  Worse, it cost real money to do so;  movers charge by weight. One mover commented that he was certain that two-thirds of the weight of all my possessions were books and Nat’l Geographic magazines, as he handed me an $8,000 bill for the move.

I now collect books on Kindle.  And I dropped off my boxes of yellow Nat’l Geographic magazines at the Goodwill store, in the middle of a dark and shameful night, almost a decade ago.  I don’t know if it was a particularly “green” decision, but I know that my recent moves have been the easiest since I was an undergraduate.

Likewise in data centers.  If we keep doing business in data centers as we have for the past 30 years, quite soon the planet would tilt off it’s axis due to the sheer weight of data storage hardware.

The advent of virtual machines has had a profound impact on provisioning environments.  Instead of unpacking, racking, wiring, powering, and cooling physical servers, data centers can now create virtual machines by the hundreds by pointing and clicking.  All of these new virtual machines share the previously under-utilized CPU and RAM resources of physical servers, making the ROI on CPU and RAM resources sky high.

So, virtual machine technology has allowed data centers to provision several million virtual servers without having to power and cool several millions of physical servers.  They use the existing physical servers far more efficiently.  That is “green”.

Not so with disk storage.

Each virtual machine still requires a full image of storage.  So, as several million virtual servers have been spun up, each has required a full complement of disk storage, thus driving the already overheated computer storage industry into supernova.

I’ve said it before and say it again:  if you have money to invest, do so in either energy or data storage.  We’re never going to use less of either.

So how does Delphix fit in?

Delphix virtualizes data, just as VMware and their competitors virtualize servers.  Delphix data virtualization makes more efficient use of existing storage, and slows the rate of growth of storage in data centers.

Data virtualization leapfrogs and multiplies the incremental improvements in storage, introducing real agility and increasing the tempo of development operations, ultimately utilizing storage resources more efficiently.

Server virtualization has been a huge initial step, but data virtualization is the final step to fully deliver on the promise of infrastructure virtualization.

Fast, good, cheap. 

That is “green”.




photo by John P Clare


ASH presentations from John Beresniewicz

August 25th, 2014


John Beresniewicz and I worked hand in hand on developing the performance pages in Oracle Enterprise Manager. John is one of the foremost experts on active session history (ASH) queries and he has recently posted some of his presentations on ASH to slideshare:





Can you justify your data ?

August 14th, 2014

People ask me to justify use of Delphix. I can understand. Delphix is new and often, most of my friends who are DBAs respond with “I can copy a database myself. So Delphix can copy 10 TB in 10 minutes with 0.0001 TB space. That’s a neat parlor game magic trick, so what?”  Well that’s missing the whole boat. The question won’t be why you should use Delphix but “can you  justify working without Delphix?”

Delphix is amazingly positioned at nexus of data concerns right now – the right place at the right time :

  • Data is exploding
  • Big Data is hyped up
  • Data management is getting harder
  • Compliance issues are mounting
  • Security issues are mounting
  • Consumerization of IT is pivotal

Delphix makes managing data  easy and efficient which means people get access to data faster, easier and cheaper which is what people are all wanting with the big data hype but rarely getting with big data “solutions”. Before people try to harness “big data”, which in my mind is the data that people haven’t even tried to harness yet, it would make more sense that people harness the data they understand. As an analyst I want fresh copies of data immediately. I don’t want it a weeks old. I also want to work freely on it with out worrying about corrupting it for others or impacting others usage of the data. With Delphix, analysts can get data for themselves, fresh data, immediately and do what they want with it and then throw it away.

This has an enormous impact on application development where the biggest bottlenck is creating and refreshing databases for developers and QA.

This has enormous implications for compliance where companies are under more and more compliance pressure and may be called upon at any time to supply past versions of data for audits. Delphix makes it easy, cheap and fast to keep old versions of data and then to provision those versions in minutes.

This has implications in financial closes where identifying and correcting general ledger errors on live systems can be prohibitive. Delphix allows fast easy sandboxes.

Security is a huge issue. With all the copies of production databases in Dev, QA, UAT, Reporting, testing, sandboxes etc it can be extremely difficult to track. On the other hand if all those copies point back to the data on Delphix it’s easy to guarantee that it is all masked and to track chain of custody.

As UIs, hardware and software languages and frameworks advance and as more and more people have access to technology, technology is exploding in areas where the UI is user friendly. The Web browser itself is a powerful example of that.  People are demanding more and more consumerized interfaces. It makes sense. Why have arcane, obfuscated, difficult interfaces that are the domain of experts only and because the interfaces are clunky they lead to human error. Instead we are demanding and benefiting from the power of clear, fast, task oriented UIs that are easy to use and guide and protect the user during the interactions. On the UI front, Delphix has just been added to

Boys Telling Secrets


What is Delphix ? (video presentation)

August 12th, 2014

According to a recent IDC study, on average Delphix

  • pays for itself in 4.3 months
  • 461% ROI over 5 years
  • 96.8% reduction in database storage
  • $50 Million predicted annual benefit for organizations over 75,000 employees

Delphix is used by over 100 of the Fortune 500.

What is Delphix? Why is Delphix important? What problems does Delphix solve in the industry?

Here is a slide deck I put together for KSCOPE :

And here is a video of the presentation graciously recorded by KSCOPE: