Success is about Imagination

Here is a quick table comparison of  different types of metrics views The first line of the table is the classic wait event and statistic...

Primary/Unique Key: inserting a unique key when  someone else has already inserted that key but not committed Foreign Key: Inserting a...

db file sequential read db file scattered read log file parallel write direct path reads direct path reads temp Of course it would be...

Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...

Does the query always execute in the same amount of  time? If some executions are slower, what is the slowest execution time? When did...

Image from Bertrand Drouvot UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more...

Here is my list and everything on this list is excellent. I’m sure I missed a few good ones, but maybe people can add them in the...

How do we know where latency comes from when  there is a disparity in reported I/O latency on  the I/O subsystem and that of the latency...

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

This is so cool ! The above is so cool. The graphic shows the latency heatmap of “log file sync” on Oracle displayed in SQL*Plus!...

A friend’s wordpress site just got hacked, so reposting this info which I have found useful a number of times. OK,  so wordpress got...

Saw a good posting on SQL joins today that echoes a classic image of SQL joins: I loved this graphic when I first saw it. Seeing the...

From the article “Facebook shares some secrets on making MySql scale” “800 million users and handling more than 60 million queries per...

Delphix  is a finalist for UKOUG partners of the year! See the finalist at UKOUG finalists for partner of the year Vote here : UKOUG...

My previous blog had out grown the limited area of just Oracle. The current blog will cover broader areas of data mobility, agility and...

This is a reposting with some updates of a post from a couple of years ago. It is a huge decision to make at the beginning of a project...

see more at: SQL tuning with VST Saw a good posting on SQL joins today that echoes a classic image of SQL joins: I loved this graphic...

SQL Tuning Methodology Wednesday, June 26th  Session 13, Bayside C from 11:15 – 12:15 on Giving way 2 free copies of DB Optimizer at...

Jonathan Lewis joins us for the 2nd webcast of 3 in his series on Delphix technology and his experiences. Jonathan came out to the...

The above is so cool. The graphic shows the latency heatmap of “log file sync”. I was running a swingbench load and at the same time...