Success is about Imagination

See: Pythians Blog on Method-R tools Method R Tools MR Trace ($49.95) – automatically creates, collects and manages trace files for...

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

Video of webinar given on Data Control by myself and James Murtagh of Red Gate The most vital resource for applications can also be one...

Once in while I work on systems that are new to me and no one is around to explain the configuration to me. I can see databases running...

Database is getting high waits on buffer busy waits. Here is an example period where 5 sessions are completely blocked on buffer busy...

Oracle OEM 12c introduces a new feature that enables the creation of Oracle database thin clones by leveraging file system snapshot...

Here are  the tuning metrics tables (SQL  stats are not in “metric” tables per say) (*DBA_HIST_…_HISTORY views are sort of confusing....

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...