Skip to content
Home » How to Enable Trace for Forms in Oracle Apps R12/11i

How to Enable Trace for Forms in Oracle Apps R12/11i

Oracle Forms runs SQL Queries, call package/procedures as per the business logic against Oracle Database. Sometimes, you find forms are running slow, taking time to perform the transaction. In this case, you can enable a trace of the form and generate TKPROF.

This TKPROF helps you to identify the query which is the bottleneck and takes time to execute. You can use this information to take corrective action by fine-tuning respective queries.

Steps to Enable Trace for forms

Log in to Oracle Apps and open the form. Now, go to Help–>Diagnostics–>Trace and select the Trace with Binds and Waits option to enable trace.

Additional tracing options,

  • No Trace
  • Regular Trace
  • Trace with Binds
  • Trace with Waits
  • Trace with Binds and Waits.

oracle apps forms enable trace

This opens a pop-up window as shown below which displays the trace file path. Note it down.

oracle forms trace enabled trace path

Now perform required transactions on the forms which are taking time like querying form, inserting records, or updating.

Oracle apps log all these transactions in the trace file. Now, here trace is enabled till the time it is not explicitly disabled. Whatever action you do, it will get recorded in the Trace file.

Do not open any other form when the trace is on.

Steps to Disable Trace

Click on Help–>Diagnostics–>Trace and select No Trace option to disable trace. Oracle Apps confirms back that trace is disabled and shows the trace file name and location.

oracle apps forms trace disabled

Generate Tkprof

Now login to Unix or Linux tier and navigate to that path. Run tkprof command to generate a readable trace file as shown below.

tkprof abc.trc abc.tx sys=no explain=apps/<apps password> sort=prsela,exeela,fchela

Summary

Tracing forms is a good utility that can help to identify performance issues inform and fine-tune them.

I hope you liked this article. Please share and subscribe.