7 Ways Data Virtualization Helps CIOs

August 28th, 2014
IDC study found that Delphix Pays for itself in 4.3 months ROI 461% over 5 years $1 Million storage and hardware savings $50 Millionannual  savings for companies over 75,000 employees $78,500 saved per year per 85 employees $85,000 annua lIT efficiency per 100 employees 98.6% storage reduction on a 2.42 TB database footprint Delphix_IDCReport_Infographic


Uncategorized

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.


Uncategorized

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 ...


Uncategorized

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:   [slideshare id=38107018&doc=aasoaktableworld2013-jb-140818153524-phpapp01]   [slideshare id=37554537&doc=averageactivesessionsrmoug2007-140731181514-phpapp01]   [slideshare id=36611678&doc=asharchitectureandadvancedusagermoug2014-140703192353-phpapp02]


Uncategorized

Can you justify your data ?

August 14th, 2014
People ask me to justify use of Delphix. I can understand. Delphix is pretty new and often, most of my friends who are DBAs respond with "I can copy a database, so what, I can do it a little faster with Delphix." Well that's missing the whole boat. The question won't be why you should use Delphix but "can you  justify working without Delphix?" I see Delphix as 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 ...


Uncategorized

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 : [slideshare id=36341765&doc=agiledata200rm607-140626102935-phpapp02] And here is a video of the presentation graciously recorded by KSCOPE:


Uncategorized

ASH visualized in R, ggplot2, Gephi, Jit, HighCharts, Excel ,SVG

July 29th, 2014
There is more and more happening in the world of visualization and visualizing Oracle performance specifically with v$active_session_history. Of these visualizations,  the one pushing the envelope the most is Marcin Przepiorowski. Marcin is responsible for writing S-ASH , ie Simulated ASH versions 2.1,2.2 and 2.3. See http://oracleprof.blogspot.com/2011/11/new-release-of-s-ash-v23.html https://github.com/pioro/orasash Here are some examples of what I have seen happening out there in the web with these visualizations grouped by the visualization tool. Gephi The first example is using Gephi. The coolest example of Gephi I’ve seen is Greg Rahn’s analysis of the voting for Oracle World mix sessions. Here is Marcin’s example using Gephi with ASH data: JIT Here are two more ...


Uncategorized

To subset or not to subset

July 28th, 2014
There was a problem at a customer in application development where using full copies for developers and QA was causing excessive storage usage and they wanted to reduce costs , so they decided to use subsets of the production development and QA Data growing, storage costs too high, decided to roll out subsetting App teams and IT Ops teams had to coordinate and manage the complexity of the  shift to subsets in dev/test Scripts had to be written to extract the correct and coherent data, such as correct date ranges and respect referential integrity It's difficult to get 50% of data 100% of skew instead ...


Uncategorized

Finding the blocking SQL in a lock wait

July 25th, 2014
One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the waiting user and their SQL with v$session by looking at v$session.event where the event is an “enqueue” (v8 and v9) or “enq: TX – row lock contention” and then looking up their SQL via the v$session.sql_hash_value which joins to v$sql.hash_value for the v$sql.sql_text. So far so good and easy. Second step of finding the blocker is really easy starting in 10g because Oracle has a new field v$session.blocking_session which can be joined back ...


Uncategorized

Excel connect to Oracle – 64bit and 32bit issues

July 24th, 2014
Wow, thanks to Process Monitor   http://technet.microsoft.com/en-us/sysinternals/bb896645 I was able track down why I couldn’t connect to Oracle from Excel. I had wanted to try some of the examples Charles Hooper has posted on connecting to and monitoring Oracle, for example http://hoopercharles.wordpress.com/2010/01/20/excel-scrolling-oracle-performance-charts/ I kept getting the error “Provider not found” Now what kind of trace info is there for an error like this in Excel? None AFAIK. Time to start guessing. I’m on windows 7 64 bit. I have the 64bit 11gR2 Oracle installed.  Excel shows up in task manager as “EXCEL.EXE  *32″. My first guess was, “oh, excel must want the 32bit libraries” so I got the ...


Uncategorized