|
I will be speaking at the
Georgia Oracle
Users Group on November 10, 2005 from 7:00 PM to 8:30
PM.
Atlanta location: MIRANT CORPORATION (stated that it is
near the Oracle offices in Atlanta). A map of
the location can be found at the following link:
http://www.gouser.org/MirantMap.pdf
Oracle 10g SQL Tuning Secrets
This presentation will focus on real-world
techniques for improving the speed of SQL queries
with a focus on the new Oracle10g features. The
topics will include the new Oracle parameters that
affect SQL performance, the use of hints to change
SQL execution plans, re-writing SQL queries in more
efficient forms and the use of advanced techniques
such as Materialized Views, replacing SQL with
PL/SQL, the new automated CBO statistics collection,
and using the new Oracle10g CPU costing approach.
Presented by the author of High-Performance SQL
Tuning by Oracle Press, this presentation will show
actual case studies to illustrate the performance
differences with these approaches to SQL tuning.
Best of all, the presenter will share his proven SQL
tuning secrets that ensure optimal SQL execution.
Key Points of the session:
- Learn about CPU costing vs. I/O costing
- Understand the new automated CBO statistics
collection
- See how SQL profiles are better than stored
outlines
- See the new 10g hints
- Look at the new SQL Tuning Advisor
Speaker bio:
Don Burleson is very active in the Oracle community
and has written 32 books, published more than 100
articles in National Magazines, and served as Senior
Consulting Editor for DBAZine and Series Editor for
Rampant TechPress. Don is a popular lecturer and
teacher and is a frequent speaker at OracleWorld and
other international database conferences.
|
