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.

Predicting the benefit from an Oracle maintenance activity

There is a wealth of historical performance data inside the Oracle 10g Automated Workload Repository (and STATSPACK), but special techniques are needed to extract and analyze this valuable information.  Some say that AWR data can be used to see “how” a table or index is used, and this information allows the DBA to predict whether a table or index reorganization will save disk space or reduce I/O.

Others say that such a model is invalid and the practice of analyzing historical object usage patterns is not a worthwhile endeavor. This exciting presentation will examine both sides of the issue and examine the “real” predictive value of historical AWR data.

Key Points:

- See how to drill-down and see how your key tables are accessed

- Understand how to measure the storage and performance benefits of index rebuilds and table reorgs

- Learn how to use AWR and STATSPACK to predict future behavior based on historical data

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.