Kilo Two Bravo's Library tagged ebusiness →  View Popular

Practical guide in Troubleshooting Oracle Applications Performance Issues. Documents a systematic approach to gather information and files usually required to: categorize, research, troubleshoot, and eventually report to Oracle Support, an Apps Performance Issue. Documents how to use the CoE Scripts.

Scope & Application

This document has been registered as Note:169935.1. The expected audience is: Technical Analysts or DBAs involved in the process of reporting and/or solving an Apps Performance Issue. This document assumes the reader has an intermediate to advanced technical background, with a good understanding of RDBMS concepts, proficiency in SQL*Plus, and comfortable in the OS of the database server.

The main focus of this Note is on Oracle ERP Apps 11i, but references are made to earlier releases of Oracle Apps (11.0 and 10.7). Most of the techniques and tools explained can equally be used for earlier releases of Oracle Apps, as well as for the CRM modules.

This document can be used in several ways. It can be used as a check list to simply gather information and files usually requested by Oracle Support in order to report an Apps performance issue. Or it can be utilized as a process which walks the reader through common steps of the troubleshooting process of performance issues. It can also be used as a reference source of techniques and tools available to tune applications.

While following this process, you may solve your performance issue. If not, you will have gathered the standard information and files required to pursue its resolution. This document classifies the Apps Performance Issues into one of three categories. Once determined the category, it branches into the details of that respective category.

Read this document entirely before starting to react to the steps of the troubleshooting process.