EBS Performance Tuning best practices using Excel & Pivot Tables (2/7)


Title: EBS Performance Tuning best practices using Excel & Pivot Tables

This session will show how our free Excel performance tuning toolbox for Oracle EBS allows much quicker performance analysis and problem resolution than Oracle’s standard tools, Enterprise Manager and AWR HTML reports. We will walk through a performance audit using our Blitz Report software, including an overall system configuration review (e.g. memory setup and IO figures), followed by a drill down into individual problematic SQLs (based on AWR and ASH data).
Also included in the session is an Excel pivot analysis of active session history data to quickly identify areas of concern. We will review information on specific user wait times, how many seconds a user spent running an SQL, and which Oracle EBS form or background program executed the problematic SQL. The analysis will also show if any application user or process blocked any other application user.
This Excel based performance analysis has consistently received very positive feedback for its speed and simplicity. We look forward to sharing this tool with all who attend.
Evening Catering Sponsors:
To RSVP for this meeting, click below. Please contact dougadministrative@gmail.com if your plans change, so we can order the right amount of food.
University of Dallas
1845 E. Northgate Dr. Irving, TX 75062
Gorman D Conference Room (no specific entrace, but destination is building 6)