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 11.5.10.2 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.

Purpose

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...

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?

3b. Before 11G:

4a. Using TKPROF

4b. Using TraceAnalyzer

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.