Forms Trace Files
To generate a trace file for a Form, be sure to have the profile options
Utilities: Diagnostics set to Yes
Hide Diagnostics Menu Entry set to No.
Log on to the application, and select the
Help ➤Diagnostic ➤Trace ➤ Trace with Binds and Waits menu option.
After this, you should set the trace size to unlimited by selecting the following menu option:
Help ➤Diagnostics ➤Trace ➤Unlimited Trace File Size.
The resulting trace file will be written to the udump directory located on the Database Node.
Self Service Trace Files
Self Service Tracing can be implemented by navigating to
Security ➤Profile ➤User.
Enter the user name.
Query the profile FND: Diagnostics.
Set FND: Diagnostics to Yes.
Log in to the application as the user for which the diagnostics profile was set. Click the diagnostics icon, select Set Trace Level, and click Go. On the next page, select Trace with Binds and Waits, and click Save. Perform the steps required to duplicate the problem. When this has been completed, there will be a trace file generated. This file can be located and analyzed using the techniques explained in the next section.
Analyzing Trace Files
Once the raw trace file has been generated, execute the tkprof or trcanlzr utilities to translate it into a readable format. Descriptions for using theseutilities are provided in the following sections.
In order to run tkprof on the raw trace file, obtain the name of the generated trace file. Note that tkprof may only be executed in the database from which the trace file was originally generated. Execute tkprof as the instance owner in a directory with write permissions as follows:
$tkprof <raw trace file name> <output filename> \ explain=apps/<apps password>
The file generated by tkprof will contain important information regarding the SQL statement, as well as diagnostics that include CPU and elapsed time, disk and logical reads, and the number of rows returned in the query, as well as the SQL execution plan. Most likely, this file will need to be uploaded to Oracle Support for assistance in resolving the underlying performance issue.
The Trace Analyzer utility (trcanlzr) reads a raw trace and generates an HTML report that includes tkprof analysis data as well as other statistics. The HTML file that is generated can be used by Oracle Support to assist in resolving performance issues.
To generate the HTML file, the trcanlzr utility must be downloaded from Oracle Support. It is available by referencing MetaLink Note 224270.1.
Once the utility has been downloaded, you will need to install it by following the instructions in the download.