Collecting Diagnostic Data for Performance Issues in Oracle E-Business Suite
(Doc ID 1121043.1)
Last updated on FEBRUARY 20, 2023
Applies to:Oracle E-Business Suite Performance - Version 18.104.22.168 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
This document outlines the most common performance diagnostic data used by development for analyzing and resolving performance issues in Oracle E-Business Suite from version 11.5.10 to R12.2.X and DB from version 10.2.X to 11.2.X. . It describes how to produce, collect, and format this data.
The following topics are discussed:
- What data to collect when diagnosing performance issues in Oracle E-Business Suite
- How to collect this data correctly, and avoid common mistakes
- Step-by-step instructions on using SQL Trace in Forms and Self-Service based applications, Concurrent Processing, and SQL*Plus
- Steps to obtain in-memory runtime execution plans (with row source counts/statistics) when tracing does not show this data
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!