Oracle EBS: Oracle E-Business Suite Performance Guide (Doc ID 1672174.1)

In This Document

• 1 Purpose
• 2 Introduction
• 3 Solution Flow Diagram
• 4 Where to Start
• 5 Reducing Iterations
• 6. Solution Process Overview
  • 6.1 SQL Trace / TKPROF
  • 6.2 AWR
  • 6.3 Display Cursor / SQL Monitor Report
  • 6.4 Most of the time spent in the application tier
  • 6.5 Applications Tier Diagnostics
  • 6.6 Most of the time spent in SQL Execution
  • 6.7 PL/SQL Profiler
  • 6.8 SQLHC or SQLT
  • 6.9 SQLHC
  • 6.10 SQLT with XTRACT Method
  • 6.11 Operating System Statistics
  • 6.12 SQL Tuning
  • 6.13 Performance Tuning
• 7 Display Cursor
• 8 SQL Monitor Report
• 9 Forms Trace and Forms Runtime Diagnostics
• 10 Reports Client Process Trace
• 11 Application Tier Operating System Statistics
• 12 PL/SQL Profiler
  • 12.7 PL/SQL Hierarchical profiler
• 13 SQLHC
• 14 SQLT
• 15 Operating System Statistics
  • 15.1 OS Watcher
  • 15.2 LTOM
• 16 Locking
  • 16.1 TX (Row Locks)
  • 16.2 TM (Table Locks)
  • 16.3 UL (User Lock)
  • 16.4 Identifying where locks are being held
  • 16.5 Identifying where locks were held
  • 16.6 "PL/SQL lock timer" waits
  • 16.7 Getting mode for TX Lock from SQL Trace or Active Session History (ASH)
• 17 Action Plan Templates
• 17.1 Display Cursor Report
• 17.2 SQL Monitor Report
• 17.3 Reports Client Process Trace
• 17.4 PL/SQL Profiler Report
• 17.5 PL/SQL Hierarchical Profiler Report
• 17.6 SQLHC
• 17.7 SQLT
• 17.8 Obtaining SQL ID
• Oracle Database Documentation Library Links
• Change Log

 

Ref:

1.Oracle E-Business Suite Performance Guide (Doc ID 1672174.1)