Kicking the Tires on Delphix Live webcast: Jonathan Lewis  - An Oracle Expert's Look at the Delphix Technology Jonathan Lewis came out to the Delphix offices in Menlo Park, CA to kick the tires on our product for a week. Join Jonathan Lewis and myself for a discussion and sharing of first impressions of Delphix. Jonathan worked closely with the Delphix team investigating performance, comparing technologies, and testing community-requested use cases. In this chat, Jonathan  and I will have an informal discussion on the preliminary results of Jonathan's  first-hand experiences with Delphix, working closely with our team to learn about the functional aims, implementation ...

Kyle Hailey
Uncategorized

Introduction   When there is a disparity in reported I/O latency between the NFS server and Oracle database on the NFS client the question arises: Where does the difference in latency come from between NFS Server and Oracle’s timing of pread? One strategy is to take tcp traces on NFS server and NFS client at the same time, during a period of load that shows the disparity. The two trace files can then be analyzed to show latency at each side and the delta of latency between packets found in both traces   Files Required   Parsing script is ( thanks to Matt Amdur from Delphix for the  core ...

Kyle Hailey
Uncategorized

by Matt Hayward Given a description of gas dynamics and the atmosphere, you would be hard to pressed forecast tornadoes. The term emergence denotes the phenomena of surprising behaviors arising in complex systems.  Modern storage systems are complex, and full of emergent behavior that make forecasting application I/O performance fiendishly difficult. In collaboration with Kyle Hailey, Adam Leventhal, and others I've learned some rules of thumb for how to make accurate I/O performance forecasts.  I've also stepped on every rake imaginable along the way. For those of you who also may wish to forecast the storage performance an application will receive, this post summarizes some lessons ...

Kyle Hailey
Uncategorized

Delphix allows companies to make copies of Oracle databases in minutes with  almost no storage overhead by sharing all the duplicate data blocks between database copies. Sharing duplicate data blocks massively reduces storage consumption, frees DBAs up from the repetitive work of copying files , allowing them to concentrate on innovative work and most importantly accelerates project development by eliminating the time and resource consuming bottleneck of provisioning databases for development, QA and reporting. With Delphix the databases can be provisioned in  minutes to any point in time from the source database allowing one to easily go back before an ...

Kyle Hailey
Uncategorized

Mogens presenting in a bathrobe before 800 people Lots of good presentations, discussions and interactions with people at RMOUG. Kudos goes out to all the RMOUG team for putting on an awesome conference. Thanks to Tim Gorman, Kellyn Pot'vin  and all the dedicated volunteers. My favorite presentation  was by Jordan Meyer of Rittman Mead consulting. He did social media analysis with R.  His R source code is available at https://github.com/jordanmeyer/oracle-sna-hol Slides are available at http://www.rittmanmead.com/articles/, specifically RMOUG2013  20 20 SNA with Oracle.pdf He took as an example the speakers from RMOUG and looked at their relationships on Twitter. Using this data he illustrated different network relationships ...

Kyle Hailey
Uncategorized

I've mentioned lab 128 before but I have to mentioned it again. Every DBA should know about this tool. It's the fastest way to connect to an Oracle database and get some hard core performance information nicely visualized graphically. Lab 128 starts up in seconds, like 1 or 2 seconds. Its super fast and light weight but powerful.  My older version only took 10M of RAM. The newest version is about 47M but still as fast as ever. Lab128 can be used to monitor 15-20 instances. Lab 128 keeps  13-14 hours of performance data in memory, and last 60 days on the ...

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