by Matt Hayward One of the less obvious advantages of database virtualization is a reduction in the read I/O issued against the underlying physical storage (henceforth called "the SAN") that ultimately stores the data for virtual databases. In practice, Delphix prevents around 60% of all non-production database I/O* from ever being issued to the SAN with the Delphix cache. This is possible because Delphix Server accommodates large amounts of RAM**, which is used as an auxiliary cache above and beyond the database buffer cache that resides on the database server.  When the database needs to read some data that is not present in ...

Kyle Hailey
Uncategorized

I'll be presenting twice at RMOUG next week on the subject of how to manage creating copies of Oracle databases and creating copies through thin provision cloning  as well as database virtualization. Feb 12, 2013 11:15 room 402 Feb 12, 2013   1:15 room 407 The first talk covers the technologies in the industry The second talk concentrates primarily on Delphix database virtualization but will hit on the other technologies as well. If you are going, I highly recommend the guidebook app for the conference. It's awesome. I wish Oracle had this at Open World. It makes browsing presentations and building a schedule a piece of ...

Kyle Hailey
Uncategorized

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