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.
This opens a pop-up window as shown below which displays the trace file path. Note it down.
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.
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
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.