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