Success is about Imagination

Thanks to the valient work of James Morle there is a awesome new website aggregating the work and postings of the members of the Oaktable...

http://www.visual-literacy.org/periodic_table/periodic_table.html

This really cool: http://www.slaviks-blog.com/2010/03/30/oracle-sql_id-and-hash-value/ he explains a how to calculate the sql_id from the...

blue numbers are the percent of the table returned after the predicate filters have been applied red numbers are the two table join sizes...

If you saw my presentation at HOTSOS 2010 or attended one of my recent Oracle 10g Performance Tuning course, you know I’m excited about...

The best methods for managing statistics in general on Oracle is an area that has yet to well ironed out but when it comes to partitions...

Anjo use to do statspack analysis at oraperf.com which has been out of order every time I’ve looked over the past few years. Tim Gorman...

Nice example of using Wireshark to monitor what’s getting run on MySQL. http://feedblog.org/2008/07/29/debugging-mysql-applications-with-...

I love this little cartoon comes from http://www.oraclealchemist.com/oracle/this-bug-brought-to-you-by-the-letter-u/ which is a funny...

Check out this query by Kerry Osborne via Oracle-L (archives at Oracle-l Archives) for getting the peeked bind variable values from...

very nice analysis of tracking down who has a dblink open on another database http://jkstill.blogspot.com/2010/03/whos-using-database-lin...

In case you have seen this free tool: http://www.oracledba.ru/orasrp/ It’s pretty cool. Takes 10046 trace files and analyzes and formats...

Here is an interesting discussion on stopping long running queries by Tanel Poder: http://blog.tanelpoder.com/2010/02/17/how-to-cancel-a-...

cool stuff: Guy Harrison explains how to set up flash caching on Linux for Oracle without Exatata http://guyharrison.squarespace.com/blog...

Check this out – SQL Plan visualization by Tanel Poder: http://tech.e2sn.com/apps/planviz

Better formatted at http://tinyurl.com/yfrjbwx Query 2 The VST diagram looks like There are two interesting things about this diagram....

article better formatted at http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits Introduction...

Tuning Example in 3 parts part 1 – “The Database is hanging!” AKA “the application has problems, good grief” I wonder if you can...

I can be exasperating when the database is slow or hanging and I can’t even connect to see what’s happening. In those cases, here is a...

from http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-io-waits Standard I/O select parameter1, parameter2, parameter3...