Success is about Imagination

Someone recently asked me what’s the ratio of redo generation to datablock writes, and of course I answered it depends, but like so many...

The new release of  DB Optimizer , version 3.0, from Embarcadero has awesome new feature : explain plan overlay onto VST diagrams! Let’s...

Update: second posting on wait event metrics at: http://dboptimizer.com/2011/07/20/wait-event-and-wait-class-metrics-vs-vsystem_event/ In...

UPDATE: July 12, 2011  I just noticed (!) that the DBA_HIST_EVENT_HISTOGRAM is only on 11g, so for 10g, it requires collecting the...

Update: nice query from Jonathan Lewis on AWR: http://jonathanlewis.wordpress.com/awr-sys-stats/ I found this while  looking for how to...

Oracle has opened Suggest-a-Session on Oracle Mix. Suggest-a-Session is your opportunity to both submit your own presentation ideas as...

For everything you ever wanted to know about Block Change Tracking (BCT) and were afraid to ask, check out the awesome presentation from ...

I’m always surprised at how hard it is to track down graphics from OEM when I want time. Here is a cool snippit of OEM 11G RAC. (click to...

UPDATE July 9, 2011: README.TXT 10046.pl NEW INFO: more trace file analyzer tools at  http://ba6.us/node/177 Often when I have a 10046...

On http://dboptimizer.com/2011/04/27/envisioning-nfs-performance/ I showed some code that displayed the send and receive sizes and times...

GUI gets a bad rep because a lot of neophytes can get away with half managing systems via graphics. A lot of graphics are completely...

I don’t have an answer to the following TCP performance difference between two machines, but thought I’d post about what I’ve seen as I...

One thing I’ve been wishing was more prominent in OEM or other tools is the displays of the fluctuation in I/O times for Oracle. I/O...

in the last two SQL ASH timing posts we looked at average, max, min execution times plus count histogram of execution times all three...

http://dboptimizer.com/2011/05/04/sql-execution-times-from-ash/ http://dboptimizer.com/2011/05/06/sql-timings-for-ash-ii/...

I’ve been wondering what kind of impact BCT has on databases and had the opportunity to talk to Vinay Srihari.* Kyle: Vinay, what kind of...

http://dboptimizer.com/2011/05/04/sql-execution-times-from-ash/ http://dboptimizer.com/2011/05/06/sql-timings-for-ash-ii/...

Another way to look at the latency times from Envisioning NFS performance is looking at the different layers of the stack we go through....

One thing I’ve failed to clearly document is that my tool ASHMON not only graphs ASH data but graphs v$sysstat as well. To access...

What happens with I/O requests over NFS and more specifically with Oracle? How does NFS affect performance and what things can be done to...