EBS Performance Tuning Best Practices Using Excel & Pivot Tables

Start
February 7, 2019 5:00 pm
End
February 7, 2019 7:00 pm
Address
Gorman Lecture Center, Room D, 1845 E. Northgate Dr. Irving, TX 75062   View map
Phone
972-721-5000

$0.00

Sponsors

Status

Event Details

Presentation
 
Title: EBS Performance Tuning best practices using Excel & Pivot Tables
 
Abstract:
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:
Enginatics
 
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.
 
Locations/Directions:
University of Dallas
1845 E. Northgate Dr. Irving, TX 75062
 
Gorman D Conference Room (no specific entrace, but destination is building 6)
https://udallas.edu/visitors/documents/Campus-Map_3-16-2018.pdf