Oracle E–Business Suite Forms–based applications allow you to set up SQL Trace under the Help > Diagnostics menu. The trace options allow you to have server and background processes write information to associated trace files. When a process detects an internal error, it writes information about the error to its trace file. For more information on trace files, see the Oracle database documentation.
Note: Enabling SQL Trace can have a severe performance impact. For more information, see the Oracle database documentation.
The following options are available:
No Trace – turns trace off.
Regular Trace – generates a regular SQL trace by performing the following statement:
ALTER SESSION SET SQL_TRACE = TRUE;
Trace with Binds - writes bind variable values in the SQL trace file
Trace with Waits - writes wait events in the SQL trace file
Trace with Binds and Waits - writes both bind variable values and wait events in the SQL trace file
Unlimited Trace File Size - allows an unlimited size for the trace file
Once SQL Trace is enabled using the Help >Diagnostics menu, the system enables trace for any form launched from the form in which trace was enabled. If trace is enabled while the Navigator is in focus, any subsequent form launched has trace enabled. When any subsequent forms are launched, the menu option indicates that trace is enabled.
A message is displayed at form startup indicating that trace is enabled.
Note: This capability should not be confused with the feature controlled by the profile option "Utilities: SQL Trace" that is used by concurrent processing.
Related Topics
Controlling Access to the Oracle Forms-based Applications Diagnostics Menu, Oracle E-Business Suite Maintenance Guide