Who's online

There are currently 0 users and 20 guests online.

Recent comments



Alleviate load on SANs with Data Virtualization


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.

Supercharged performance at a fraction of the price


Virtual Flash Database  Delivers 10x Price/Performance Improvement

Screen Shot 2013-09-05 at 9.52.45 PM

See Press release at 

See Me at Oracle OpenWorld 2013

I’ll be in San Francisco next week, presenting about Hadoop and Big Data at the biggest conference. If you want to say “hi”,

you can attend one of my sessions:

Happy Birthday to Us !!!

King Training Resources celebrates our 25th year beginning this month. It’s gratifying to see that what began in 1988 is still going strong today. Thanks to all involved, especially to my wife Peggy without whom life would seem impossible.

Hope to see you at Oracle Open World 2013

I’m off to Oracle Open World next week where I’ll be talking about new features in the Oracle 12c Database for developers and Oracle ADF.  You can join me as ODTUG and the ADF EMG team up for a series of great sessions during User Group Sunday.

Here’s my Oracle Open World 2013 Speaking Schedule:

  • Sunday 9/22 – 8:00am-9:00am – Oracle ADF Task Flow Beyond the 10-Minute Demo – UGF700
  • Sunday 9/22 – 11:45am-12:45pm – The Next Generation of Oracle Database and 11gR2 New Features for Developers: What You Need to Know
  • Thursday 9/26 – 12:30pm-1:30pm – Oracle Database 12c New Features for Developers – CON6900

Been away too long

Sorry, it’s been a while since I posted to this blog. Thanks for coming back!

A lot has happened in the last year including new versions of Oracle’s database, ADF, JDeveloper, and SQL Developer. I now have many new features to explore and will share interesting tidbits as I discover them.

I was pleasantly surprised at Kscope 13 in New Orleans when Vikki Lira from Oracle Technology Network informed me that I had been accepted as an Ace Director; many thanks to all who were involved. Once Tim Gorman and Tim Tow taught me the “secret handshake” I was ready to go.

Lies, Damned Lies, and I/O Statistics



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.

My stuff at OpenWorld


Analytic Functions [UGF7455]

Analytics have been with us since Oracle8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions and how they can supercharge your SQL skill set.

SQL Tuning 101 [CON7457]

It’s the age-old problem: the SQL statement that needs to run in 5 seconds unfortunately runs in 10 seconds or 10 minutes, or 10 hours. A SQL statement is e-mailed to you with the simple subject line "Make it faster!". This presentation starts from this point in the process and looks at what you can do to tackle this common issue.

Optimizer Statistics: A Fresh Approach [CON7442]

Best Oracle Performance Tools


What tools do you use? What are your favorites and why? As someone who has been working  Oracle performance tools for the last 15 years, I’m always interested in what the best tools are.

For the past 4 blog posts I’ve reviewed some tools I like such as Method-R tools, Confio, Lab128 and EMlite.

There are other tools that I especially like and are totally free such as Tanel Poder’s Moats and snapper which are two important tools for a DBA to know about.

Here is my list of tools that I’m aware of (what other tools are out there?)