Apologies to those of you getting this more than once, but we are trying to=
=0D
make as many people who are interested in Oracle internals aware of our=0D
meeting as possible. The better our attendance, the better chance we have=
=0D
of Oracle continuing to provide this caliber of people to speak at our=0D
meetings.=0D
=0D
The OAUG Database SIG (http://dbsig.oaug.org) is meeting on Sep 12 at 9AM=
=0D
as part of Connection Point 2004 (see http://www.oaug.org for details). You=
=0D
do not need to register for the conference to attend SIG meetings. =0D
=0D
Title: Oracle10g SQL Optimization=0D
=0D
Presenters: Mohamed Zait, Benoit Dageville=0D
=0D
Abstract: =0D
=0D
Oracle Database 10g features a sophisticated cost based optimizer (CBO) for=
=0D
efficient execution of even the most complex SQL statements. Since it was=
=0D
first introduced in Oracle7, the CBO has been substantially enhanced to=0D
support a comprehensive set of access paths, adaptive search technology,=0D
and, the most importantly, new database features introduced since Oracle7.=
=0D
A good testimonial of how mature this technology has become is the fact=0D
that the CBO is only supported optimizer mode in Oracle10g. This paper=0D
discusses the enhancements made to the CBO in Oracle10g and elaborates how=
=0D
its built-in knowledge and intelligence can be leveraged in Oracle10g to=0D
automatically tune problem SQL statements. In addition, the paper will also=
=0D
highlight some best practices that can make SQL Tuning task a lot more=0D
efficient and less time consuming. Finally, a step-by-step approach will be=
=0D
outlined for migrating an application from the RBO to the CBO.=0D
=0D
Presenter Bio:=0D
=0D
Mohamed Zait is the manager of the SQL optimizer development group at=0D
Oracle. He has been with Oracle for more than 8 years working in different=
=0D
areas such as SQL Execution Memory Management, Parallel Query Processing,=
=0D
and SQL Execution. Mohamed is also one of the leading architects of the=0D
Oracle10g=92s Automatic SQL Tuning feature. =0D
=0D
Benoit Dageville is a consulting member in the Oracle Database Server=0D
Technologies division at Oracle Corporation in Redwood Shores, California.=
=0D
His main areas of expertise include parallel query processing, ETL (Extract=
=0D
Transform and Load), large Data Warehouse benchmarks (e.g. TPC-H), SQL=0D
execution and optimization. Since 1999, he is one of the lead architects of=
=0D
the self-managing database initiative at Oracle.=0D
=0D
--=20
Michael Brown Phone: (336)586-1146=0D
Chairman, OAUG Database SIG Fax: (336)586-1382=0D
Glen Raven, Inc. E-Mail: mbrown_at_glenraven.com=0D
Information Services, 1831 N. Park Ave, Burlington NC 27217=0D
=0D
Contact the SIG Board: oaugdbsigboard_at_yahoogroups.com=0D
Join the SIG:
http://dbsig.oaug.org/join.shtml=0D
=0D
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Aug 03 2004 - 13:22:27 CDT
