Further Reading - tech.E2SN

E2SN Virtual Conferences‎ > ‎

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

Out of Range predicates

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

Avoiding Tables

Bind variable problems

"Conditional" SQL

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.

Sign in|Report Abuse|Print Page|Remove Access|Powered By Google Sites