Performance Problems – Forms

When an end user says that whenever they use a certain form a certain way, they have a performance problems
Have the user show you exactly which form runs slow.
Have the user select Help | Diagnostics | Trace and click in the “Trace With Binds
and Waits” box right before they do the part of the transaction that runs slow.

When the trace first starts, a pop-up screen will tell you where to look for the trace
file and what it is called

Next, have the user do the slow part of the transaction. Then have the user select
Help | Diagnostics | Trace and turn trace off by clicking on “No Trace.”

Go to the below directory and check whether trace file is created
cd $ORACLE_HOME/admin/<$CONTEXT_NAME>/udump.

Now you can run either tkprof or Trace Analyzer, using the command:
tkprof filename.trc filename.prf explain=apps/<apps_pwd> sort=prsela,exeela,fchela

To run Trace Analyzer:
sqlplus apps/<apps_pwd>
SQL> START TRCANLZR.sql UDUMP test_ora_12345.trc;