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.

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.

Oracle SQL tuning is now more complex than ever before.  This presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle10g SQL tuning 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:

- 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

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.