My Oracle Support Banner

Oracle E-Business Suite Applications Performance Triage Steps And Basic Skills Guide (Doc ID 1516355.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle E-Business Suite Performance - Version and later
Information in this document applies to any platform.


This document is intended to give basic technical skills to help in troubleshooting E-Business Performance issues.


 This document is informational and intended for any user.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 SQL Statements Overview
 Data Definition Language (DDL) Statements
 Data Manipulation Language (DML) Statements
 Transaction Control Statements
 Session Control Statements
 System Control Statement
 Embedded SQL Statements
 SELECT Statements
 Subqueries and Implicit Queries
 SQL Processing Overview
 Optimizer Overview
 Optimizer Components
 Access Paths
 Join Methods
 Optimizer Statistics
 Optimizer Hints
 Bind Variables
 Timed Statistics
 Wait Events
 Explain Plan
 Runtime Plan
 SQL Statement Execution Flow
 SQL Parsing
 SQL Binding
 SQL Optimization
 SQL Row Source Generation
 SQL Execution
 Applications Performance Troubleshooting Step
 Define the Problem
 Check Debug/Trace Profile Options
 Gather Schema Statistics
 Set initialization parameters for trace file management
 Enable the SQL Trace
 Interpret TRACE File
 Interpret TKPROF File
 Maximize EBS performance
 Case Studies
 Case Study 1: Tracing a long running program
 Case Study 2: Tracing an expensive SQL that has bind variables

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.