Success is about Imagination

Two interesting links 1. Overtime working at Flickr during startup days probably was ineffectual: http://www.fastcompany.com/blog/cliff-k...

for all questions on the site ashmasters.com, please asked them in the comment section on this blog post. Due to the enormously high...

DB Optimizer makes powerful use of graphics to communicate data faster , clearer and with less effort by the user than text...

Visual SQL Tuning (VST) is a ground breaking technology that we are aggressively developing and improving every verison. In this first...

Where are there good discussions on GUI and Information Visualization on the web? Decent discussion group on web site of Stephen Few:...

Some quick rules of thumb for visual design http://www.presentationzen.com/presentationzen/2008/08/learning-from-the-design-around-you-ik...

Interesting discussion of GUI verses Scripts on Jared Still’s Blog http://jkstill.blogspot.com/2009/10/oracle-open-world-report-for-octob...

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