Ask Jonathan about Delphix at http://jonathanlewis.wordpress.com/2013/02/06/delphix/ Jonathan Lewis has graciously accepted an offer to come out to sunny California next month  and spend a few days at Delphix !  Jonathan will be putting  Delphix through it's paces.  I'm super excited to have Jonathan  test Delphix and then learn about what he discovers. We are planning on co-presenting a webinar on the findings as well as Jonathan will be blogging is findings. If you have questions for Jonathan about Delphix or scenarios you'd like him to test out then ask Jonathan to  test them out by commenting on  his blog post  on Delphix: Jonathan Lewis' ...

Kyle Hailey
Uncategorized

Every so often a DSS query that usually takes 10 minutes ends up taking over an hour.  (or one that takes an hour never seems to finish) Why would this happen? When investigating the DSS query, perhaps with wait event tracing,  one finds that the query which is doing full table scans and should be doing large multi-block reads and waiting for "db file scattered read" is instead waiting for single block reads, ie "db file sequential read".  What the heck is going on? Sequential reads during a  full table scan scattered read query is a classic sign of reading rollback and reading ...

Kyle Hailey
Uncategorized

Slides available at: Database Virtualization and Instant Cloning Thanks to Marcin Przepiorowski  for editing videos and Tim Gorman for funding the videos. For a full list of Oaktable World 2013 videos see http://dboptimizer.com/oaktable-world/ A completely new and totally different database virtualization presentation will be given at RMOUG  Feb 12, 2013 11:15 room 402 "technical"  and 1:15  rm 407  "marketing" with technical information NoCOUG Feb 21, 2013 HOTSOS Mar 5, 2013   What is Database Virtualization?  Perhaps the single largest storage consolidation opportunity in history By Kyle Hailey, Delphix http://delphix.com January, 2013 Brief How would you like to Double development output Lighten DBA work load Reduce storage Existing database cloning technologies allow increased development output, fewer bugs ...

Kyle Hailey
Uncategorized

One thing that I have found sorely missing in the performance pages of Enterprise Manager is latency values for various types of I/O. The performance page or top activity may show high I/O waits but it won't indicated if the latency of I/O is unusually high or not. Thus I put together a shell script that shows latency for the main I/O waits db file sequential read db file scattered read log file parallel write direct path reads direct path reads temp Of course it would be nice to add a few others like direct path writes, direct path writes temp and log file sync but ...

Kyle Hailey
Uncategorized

This past year I joined up on the board of the Northern California Users Group (NoCOUG) and am excited to help the NoCOUG team bring great conferenes to the Bay Area. Our new conference director Ben Prusinski has scheduled a whole slew of NoSQL and Big Data presentations at Conference 105 on February 21. Has NoCOUG abandoned SQL? You can bet your bottom dollar it hasn’t! In fact, it was Oracle’s own idea to have so many NoSQL and Big Data presentations at Conference 105. Dave Rubin, Director of NoSQL Database Development at Oracle will explain why NoSQL Database and Oracle Database ...

Kyle Hailey
Uncategorized

Live webcast: Realize Massive ROI with Database Virtualization Date: Wednesday Jan 30, 2013 @12pm ET/9am PT Click Here to Register If you could create as many copies as you wanted of production databases for development, reporting and QA, how many would you create? 10,20, a 100? It is possible in the space of a single copy of the production database using thin provision cloning. Thin provision cloning give enormous disk savings by sharing the majority of source database data blocks. Thin provision cloning is one technology of database virtualization. Database virtualization goes beyond thin provision cloning technology to provide agile corporate data management. Virtual databases can ...

Kyle Hailey
Uncategorized

Nicer formating at https://sites.google.com/site/oraclemonitor/r-slicing-and-dicing-data R data types Converting columns into vectors Extracting Rows and converting Rows to numeric vectors Entering data Vectorwise maximum/minimum Column Sums and Row Sums R can do some awesome data visualizations: http://gallery.r-enthusiasts.com/thumbs.php Instead of doing one off data visualizations like with Excel, R can automate the process allowing one to visualize many sets of data with the same visualizations. Installing R is pretty easy http://scs.math.yorku.ca/index.php/R:_Getting_started_with_R There are lots of blogs out there on getting started with R. The one thing that I didn't find explained well was slicing and dicing data. Lets take some data that I want to visualize.  The following data shows the performance of ...

Kyle Hailey
Uncategorized

  I wanted to plot a set of data by 3 dimensions. I wanted to plot I/O read latency by MB/s throughput by number of concurrent readers. Seemed simple. Well it turns out there is no good way to do it in Excel. Sure Excel has 3d charts but, attention, the z axis is treated like rows and not values. For example Note that the z axis, "users" had 3 values marked  on the axis. Those 3 values are 1,16 and 64. Notice that  16 is as far from 1 as 64 is from 16, ie the distance is not proportional to the ...

Kyle Hailey
Uncategorized

What is database virtualization? Database virtualization, as opposed to operating system virtualization, is sharing a read only copy of a source database  duplicate blocks between all clones of  a source databases.  Where VMware shares the compute tier between multiple virtual machines, virtual databases share the duplicate datablocks between the virtual databases. The clone databases are called virtual databases (also called thin provision clones as distinct from full physical copy clones).   The virtual databases appear as full size copes of the source databases.  Database changes made by a virtual database are only seen by that virtual database as if the virtual ...

Kyle Hailey
Delphix

2012 marked the beginning of a fundamental shift in the responsibilities of the CIO. As Gartner analyst Mark McDonald recently wrote on his blog, after years of delivering ‘more for less’, CIOs began to refocus on delivering growth through innovation - building the business rather than putting it on a diet. However, most CIOs know they won’t suddenly see their treasure chest filled with new cash, and will have to look for other ways to deliver innovation. One of the most effective ways to free up time and money is to remove the complexity and duplication that has been created over the years ...

Kyle Hailey
Uncategorized