Pre-conference Workshop
Monday, October 26
Troubleshooting or Tuning given by Jonathan Lewis
For more information on the agenda, click here.

Keynote Presentation
Optimizing through Understanding—Investigating One SQL Statement, Jonathan Lewis

Once you start to write more complex statements, it's fairly common to see the optimizer making mistakes. In such cases, you need to review the data, understand what should happen, and force the relevant access path. But unless you know what can be done, and why it needs to be done, that's not an easy task. In this presentation, we examine a single SQL statement and show that the optimum
execution path depends entirely on a good understanding of the data volumes, the data relationships, and the available indexes. In the course of the presentation, we will see several different execution paths for that one statement. One is a path the optimizer will never find; one is a path a human being would (probably) never think of; each of the paths would be correct path for a specific set of circumstances. After seeing this presentation, you will be better  equipped to deal with the problems
of analyzing and optimizing complex SQL.

Oracle Keynote Presentation
Lower Costs with Oracle Database 11g Release 2

Oracle Database 11g is helping organizations across the world reduce  their computing costs through consolidation on enterprise grids,  reduced storage requirements and eliminating idle redundancy. Oracle  Database 11g Release 2 includes major new ease of use features that  make Grid computing more accessible, compression enhancements that  can deliver up to 20x compression ratios, and another industry first  that now makes it possible to upgrade database applications while  users remain online. Oracle Exadata revolutionized data warehouse  query performance, and further advances in Oracle Database 11g  Release 2 parallel query technology will run querys even faster.  Join us and learn why Oracle Database 11g Release 2 is the  compelling choice for your organization.

2009 Conference Schedule (Subject to Change)

Monday, October 26
Workshop by Jonathan Lewis, Troubleshooting or Tuning, 9:00 a.m. - 5:00 p.m.
Please check in for the conference from 8:30 a.m. - 9:00 a.m.

Tuesday, October 27