This is where we'll copy the answers to questions asked through the chat interface and also the URLs that speakers provided.
Virtual Conference 01 - Systematic SQL Optimization (18-19 Nov 2010)
Further reading recommended by Speakers
Managing Statistics for Optimal Query Performance - by Karen Morton
For Developers: Making Friends with the Oracle Database - by Cary Millsap
And everything else downloadable (for free) from Method-R website
A demo showing how the explain plan command may show you an incorrect execution plan - by Tanel Poder
Article about xm and xmsh scripts for querying V$SQL_PLAN directly, which also works on Oracle 9.2 - by Tanel Poder
Related article about other tools which use explain plan also possibly lying to you - by Charles Hooper
Read currently running SQL statement's bind variable values in Oracle 11.2 - by Tanel Poder
The most fundamental difference between HASH and NESTED LOOP joins - by Tanel Poder (read the comments, this topic isn't closed yet!)
A demo script showing that the bind variable peeking problem still exists in some cases even on Oracle 11.2 - by Tanel Poder
An example showing that an Oracle execution plan is just a bunch of C functions called in required order - by Tanel Poder
Oracle Support Sanctions Manually Created SQL Profiles! - by Kerry Osborne
Upgrading from Oracle Database 10g to 11g: What to expect from the Optimizer - Oracle Corp. whitepaper
My Oracle Support upgrade companion documents:
Jonathan's Cost Based Oracle: Fundamentals book
Out of Range predicates
http://jonathanlewis.wordpress.com/2009/11/29/cardinality/ (and read the comments)
Bind variable problems
Questions & Answers
I will gather & paste these here tomorrow (Tuesday)!
Update: I've ran out of time - and I'll paste the Q&A info here on the weekend. Sorry for delay!
Update2: Still working on retrieving the questions - apparently there are some issues with getting them out of Gotowebinar properly.