Session ID: 10938
Abstract: This presentation shows best practices to analyze performance issues in a live Oracle E-Business Suite environment, using Excel pivot tables, to deliver quicker insights and results than is possible with SQL scripts or other tools.
Objective 1: Detect problematic SQLs including their application module display names, package and codeline number
Objective 2: Identify how much time application users spent on any particular SQL, including the forms or application module display names
Objective 3: Analyze overall system load and hardware speed and identify common system configuration issues
Audience: User Accounts, Help Desk, Trainer