Further Reading

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

Cary Millsap

• 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

Tanel Poder

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

Kerry Osborne

• Finding unstable execution plans (and using the awr_plan_change.sql script demoed) - by Kerry Osborne

• 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:

    • 10g Upgrade Companion (Doc ID 466181.1)

    • 11gR1 Upgrade Companion (Doc ID 601807.1)

    • 11gR2 Upgrade Companion (Doc ID 785351.1)

Jonathan Lewis

Books

• Jonathan's Cost Based Oracle: Fundamentals book

System Statistics

• http://jonathanlewis.wordpress.com/2007/04/30/system-statistics/

• http://jonathanlewis.wordpress.com/2007/05/20/system-stats-strategy/

• http://jonathanlewis.wordpress.com/2007/10/17/system-statistics-3/

Out of Range predicates

• • http://jonathanlewis.wordpress.com/2009/11/29/cardinality/ (and read the comments)

Avoiding Tables

• http://jonathanlewis.wordpress.com/2010/05/18/double-trouble/

• http://jonathanlewis.wordpress.com/2010/10/08/manual-optimisation-4/

• http://jonathanlewis.wordpress.com/2010/11/26/index-join-2/

Bind variable problems

• http://jonathanlewis.wordpress.com/2009/05/06/philosophy-1/

• http://jonathanlewis.wordpress.com/2010/10/31/conditional-sql-3/

• http://jonathanlewis.wordpress.com/2010/05/03/cursor-sharing-3/

"Conditional" SQL

• http://jonathanlewis.wordpress.com/2007/01/09/conditional-sql/

• http://jonathanlewis.wordpress.com/2007/02/14/conditional-sql-2/

• http://jonathanlewis.wordpress.com/2010/10/31/conditional-sql-3/

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.