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.

Extending the Power of the Oracle 10g Automated Workload Repository

Oracle’s new Automatic Workload Repository (AWR) component automatically places important Oracle performance data right at your fingertips.  The data structures are remarkably similar to the STATSPACK utility and this paper will show you how you can easily write custom AWR reports to gather important time-series performance information. 

This presentation will describe how to do custom exception reporting and show powerful predictive modeling and hypothesis testing techniques such as how to compare the behavior of several performance factors and how to compare two time periods together.  The presentation will also show how to write custom AWR scripts to examine past performance for “signatures” and use the new dbms_scheduler package to change your Oracle configuration just-in-time to meet an expected stress condition.  This presentation will use real-world examples from production 10g database to illustrate the power of AWR for the Oracle professional.

Key Points:

- Understand the AWR table structures

- See the similarities between AWR and STATSPACK

- Learn how to write AWR scripts

- See how to create time-series exception reports

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.