Success is about Imagination

ZFS doesn’t have direct I/O. Solaris dd doesn’t have a iflag= direct. Thus for I/O benchmarking it requires mounting and umounting the...

It’s not about technology. It’s about people and stories.  – Dean Kamen A friend recently ask what are the best Ted Talks, and I  thought...

Oracle 10 added the awesome procedure dbms_xplan.display_cursor but unfortunately the documentation of the package is a bit lacking and...

When mounting NFS file systems there is an option to set the max rsize requested. For example: mount -o rsize=1048576,wsize=1048576,proto...

People are frequently asking me what I’m doing at Delphix after all the years I spent at Oracle, Quest and Embarcadero working on...

Anyone want to look through the following JSON and spot the problem? {{“o_w_ms”:[[1313412960000 , 1.71 ],[1313413020000 , 2 ]],...

Any intelligent fool can make things bigger and more complex. It takes a touch of genius – and a lot of courage – to move in the opposite...

Interview appears in  www.oracle-class.com: 1- Why did you choose to specialize in Oracle databases? I wanted to live in San Francisco...

People often ask me what I work on now after having been at Oracle, Embarcardero and Quest. I’m now at a company called Delphix where I...

Thursday, July 28 11:00am PDT  :  Register Here Last post I talked about the  Method R performance tuning tools for Oracle.  The creation...

It’s rare to find professional level tools  that are written by the people who use them. Most professional tools are written by teams of...

Dates are a surprising pain for correlating data an at the same time being understandable to the human reader. For a generic form we can...

There are 3 kinds of CPU in the Oracle stats. Oracle CPU used System CPU used Oracle demand for CPU Starting in 10g Oracle records both...

Oracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight forward...

This post is a followup to the first metric post on statistics: http://dboptimizer.com/2011/07/07/mining-awr-statistics-metrics-verses-st...

When testing the read and write speed to an NFS mounted file system it’s often unclear if the bottleneck is the speed of the network...

I must admit, I’m a sqlnet hack.  I never really sat down to figure it out. If I have problems getting a database to register with a...

Just and interesting image on the relative orders of magnitude of different latencies.

General ***rule of thumb*** I’ve heard and buy into is that decent log file syncs times should be 3ms or under. Well “log file sync”...

Thought I had blogged about this before but couldn’t find the reference. Tanel Poder put together a nifty tool that takes an explain plan...