Success is about Imagination

ASH is now at 93 fields in 11gR2, starting from an original 30 in 10gR1 Here is a spread sheet across 10.1.0, 10.2.0.1, 10.2.0.3,11.1,...

dbms_xplan.display_cursor will output the hints for a plan. These hints can then be taken and used in an outline for plan stability:...

Nice table on http://www.psoug.org/reference/dbms_xplan.html and some more discussion on http://jonathanlewis.wordpress.com/2008/03/06/db...

Diff’ing explain plans is difficult and tedious.>Here is a new package function from Oracle for diff’ing explain plans...

Here’s some nice code for looking at multiple child cursors with the same plan hash and evaluating through hashing other parameters to...

ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT SELECTIVITY 0.1; ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT COST...

Explain Plans can be had via Explain Plan (version ? ancient) Trace Files (starting 7.3) Autotrace (starting 8.1.7) V$SQL_PLAN (starting...

Check out Tanel’s analysis and scripts for cache buffer chains latch contention analysis. Solid stuff: http://blog.tanelpoder.com/2009/08...

Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...

Growing up on Ansi 89 and working at Oracle for 10 years, some of the the cleaner SQL join notation seems new to me. Here is a great...

More videos from Stéphane Faroult I have yet to go through these videos but based on the previous two I posted from Stephane, these...

Interesting blog on how finding performance problems takes 80% of the mean time to resolution. Sybase ASE Performance and Tuning This is...

Types of subqueries (today I couldn’t think of the term “inline view”) subquery ( subselect used in where clause) correlated subquery...

One of the main things I do to tune SQL is to encourage the optimizer to take path. I often take the most important steps to do first and...

Starting in Oracle 10.2.0.3 (ie not 10.2.0.2 and below) it’s easy to track what package and/or procedure a SQL execution came from using...

I love this video on “getting dreadful database performance” by Stephan Faroult. The video is hilarious and infomative:...

I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an...

One complaint I’ve heard of a number times is how code gets tested with one user and it runs fine and then gets put into production and...

I’ve always had a natural aversion to pie charts. Pie charts seem all the less apealing when compared to bar charts.  I’ve wondered if it...

Another problematic wait event in Oracle is “SQL*Net break/reset to client”. This wait event typically happens when there is something...