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.

Creating a self-tuning Oracle10g Database

Oracle started to create the mechanism for a self-tuning database with Oracle9i and has begun the automation of many tuning actions in Oracle10g.  This exciting presentation will show the Automated Storage Management (ASM) and Automated Memory Management (AMM) tools and describe their internal mechanisms for re-allocating RAM regions within the Oracle10g SGA.  

This presentation also shows how you can extend upon these automation features to make Oracle10g even more self-managing.  Using the existing data from the Automated Workload Repository and Active Session History tables, this presentation will show you how to create sophisticated scripts to detect anomalies and dynamically invoke the dbms_scheduler utility to automatically repair the process.  This is an indispensable presentation for any Oracle professional who wants to know how to automate their manual decision rules within the automation framework of Oracle10g.  This presentation will show working code from real-world Oracle10g databases.

Key Points:

- Understand how to spot repeating performance problems

- Understand the foundations of AMM and ASM

- See how to extend AWR to create your own self-tuning tasks with the new dbms_scheduler package

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.