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 11.5.10.2 and laterInformation in this document applies to any platform.
Purpose
This document is intended to give basic technical skills to help in troubleshooting E-Business Performance issues.
Scope
This document is informational and intended for any user.
Details
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
| Purpose |
| Scope |
| Details |
| 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 |
| Joins |
| SQL Processing Overview |
| Optimizer Overview |
| Optimizer Components |
| Access Paths |
| Join Methods |
| Optimizer Statistics |
| Optimizer Hints |
| Bind Variables |
| Timed Statistics |
| Wait Events |
| Events |
| TRACE File |
| TKPROF File |
| 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 |
| Run TKPROF |
| 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 |
| References |