My Oracle Support Banner

FAQ: Common Tracing Techniques in Oracle E-Business Applications 11i and R12 (Doc ID 296559.1)

Last updated on AUGUST 22, 2023

Applies to:

Oracle E-Business Suite Performance - Version to 12.2 [Release 11.5.10 to 12.2]
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Bills of Material - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.


Here are some common questions or tips about Tracing, SQL Trace, TKProf, and Trace Analyzer related to the Oracle E-Business Applications 11i and R12.

Questions and Answers

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
Questions and Answers
 1a. What is a trace file?
 Example #1: ORA-Error
 Example #2: Rollback
 1b. What are bind variables?
 Example #1: Binds
 Example #2: Binds
 2. How to Enable Trace In...
 2a. Forms
 2b. Concurrent Program
 Debug Options Button! (Binds and Waits)
 SQL Program (Binds and Waits)
 2c. Trace ALL user actions
 2d. Web-based screen
 3. Finding Trace Files?
3a. In 11G:
 3b. Before 11G:
 4. Other Tools
 4a. Using TKPROF
 4b. Using TraceAnalyzer
 4c. SQLT
 4d. RDA
 4. Before 11i?
 5. Tracing API Calls

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