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