Scaling Oracle Application Express for large systems projects Oracle Tips by Burleson Consulting

Click here for a list of all Oracle User Group Session Topics and here for past Oracle Speaker Sessions.  Just phone below to schedule this session for your Oracle users group.

Inside the Oracle 10g cost based SQL Optimizer

With each new release of Oracle, the cost-based SQL optimizer (CBO) becomes more intelligent and Oracle10g is no exception.  This presentation shows the major enhancements to the cost-based SQL optimizer in Oracle10g with a focus on the tuning tools that affect the behavior of the CBO.  Topics will include the CBO Oracle parameters, the use of schema statistics by the CBO, and how the CBO evaluates complex queries and derives the optimal execution plan.  We will also cover the use of the new 10g SQL profiles and discuss cursor sharing and automatic query re-write.

Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation is indispensable for all Oracle professionals who must understand how to adjust their CBO for optimal performance in their environment.

Key Points:

- Understand Oracle costing trees

- See the parameters that effect CBO behavior

- Learn about optimizing schema statistics

- See why histograms help the CBO make better decisions

- Understand SQL dynamic sampling

This has been a top-rated presentation and is very popular at local Oracle user groups.

Oracle Speaker Bio:

Don Burleson is considered one of the world’s top experts in Oracle.  He is very active in the Oracle community and has written 32 books, published more than 100 articles in National Magazines, a popular lecturer and teacher who is a frequent speaker at OracleWorld and other international database conferences.   As a corporate database consultant, Don has worked with numerous Fortune 500 corporations creating robust database architectures for mission-critical systems.  Don is also a noted expert on eCommerce systems, and has instrumental in the development of numerous Web-based systems that support thousands of concurrent users.

If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.