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.

Oracle10g Wait Event Tuning with the Automated Session History Tables

Oracle 10g has greatly improved the wait event information in Oracle10g, providing the Oracle professional with an unparalleled opportunity for detecting and correct database bottlenecks.  This presentation will show the internal structures of the ASH tables and highlight the important wait events within the tables.  The attendee will see simple scripts for identifying the top wait events over time, and see how to quickly drill-down to find the cause of the bottleneck.

Best of all, this presentation will show how to perform time-series wait event analysis.  Oracle bottlenecks are very transient and unique combinations of events create unique bottlenecks.  This paper shows working scripts that are used in real-world Oracle 10g databases to detect repeating patterns of bottlenecks and show hidden events that are often too transient to see with real-time monitors.  This presentation is indispensable for the Oracle professional who wants to know how to use ASH to automate the tedium of manual monitoring and repair of wait event conditions.

Key Points:

- See the internal structure of the ASH tables

- Understand the wait event collection process

- Learn to write custom ASH scripts

- See scripts to quickly locate database bottlenecks

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.