Why is my Forms 12c Application so slow?

Posted in: Technical Track

After a recent upgrade

Users cannot work with the forms application anymore; it has been a few weeks since an upgrade to Forms 12c.
The usual suspects have been investigated.

  • The database is not waiting on forms transactions
  • The application server is not in any distress, and yes, we have fluctuations in server CPU usage, but well within limits
  • The user PCs (running the forms in a Browser) are not seeing any issues like CPU/memory limitations
  • The forms are very slow in navigation and at odd times during the day they “freeze”

What next?

Re-visit the basics

The forms application started life as “thick client” that would connect directly to the database. Today, it is a very different implementation (OHS, Weblogic, Listener Servlets, frmweb processes, Applets).

When a form is written, it is likely to use “triggers” and “program-units” to carry out application logic and displays rows of data in data blocks that are tied to a query involving one or more database tables. These triggers may be “fired” when the user navigates from one item to another, when the forms instance starts, when a new row of data is inserted, or in countless other ways. In a well-designed form, triggers would typically call program units. Users can also use shortcut keys to add new rows, delete rows, commit or rollback data.

If you have used a forms application, you will understand its simplicity and complexity. You (usually) do not scroll up or down the page like when viewing a spreadsheet, but you view a subset of the rows of data and the rows move up or down in response to keystrokes.

A common misconception of forms applications is that since they work in a browser, they are built with HTML/javascript much like the web page on this blog. Unlike other applications, forms do use the browser, but all their work is actually done inside a forms applet that runs on a Java virtual machine provided by the browser.

In Forms 12c, there is now a stand-alone client that can be used to start the applet.

The forms applet is able to display the screen, capture the users’ keystrokes, show the form icons, status bar menus and is a fixed view. It is able to respond to basic OS events and relies on its much smarter companion the frmweb process that lives on the forms server to actually talk with the database and process the logic of the form. So the forms applet sends small chunks of info every few milliseconds and receives responses from the frmweb process. They chatter a lot!

A colleague of mine was incredulous when he looked at the network traffic ( the application with about 50 users logged in pings the forms server 200 times in a second !)

So why is it slow?

In essence, if the application is not responding quickly we have these classical areas to review

  • The applet is slow to respond to the user input
  • The frmweb process is slow to respond to the events received from the Applet
  • The frmweb process is waiting on the database to provide it data
  • Other unknown reasons

Instead of us guessing our way through this, let’s get some data. Oracle provides an easy way to trace the forms sessions as they are running.
The trace files are written on the Forms server and are labelled with the frmweb process ID.

The trace location in Forms 12c is


[[email protected] karun]$ ls -ltr $DOMAIN_HOME/system_components/FORMS/forms1/trace | tail -3
-rw-r----- 1 oracle dba 5882480 May 6 10:50 forms_26737.trc
-rw-r----- 1 oracle dba  759326 May 6 18:00 forms_17824.trc
-rw-r----- 1 oracle dba 1209818 May 6 18:15 forms_16979.trc
[[email protected] karun]$

The easy way to start a trace

Use the Enterprise Manager Control:
Select a session and click on Enable Tracing

Choose the tracegroup (I usually choose to run with debug as this has all the details).
After a few minutes of tracing you can click on Disable Tracing button.
And EM can also show you the trace file contents.

The other easy way to start a trace

This is what we can also do when the EM is not accessible ( or you do not really like the pointy-clicky stuff)
Start the form on the client PC with this URL:



Work for a few minutes and close the application.
Having generated trace files, we now have to read them on the forms application server after we translate them to text.

$JAVA_HOME/bin/java -classpath $ORACLE_HOME/jlib/frmxlate.jar oracle.forms.diagnostics.Xlate datafile=$DOMAIN_HOME/system_components/FORMS/forms1/trace/forms_17824.trc outputfile=trace_my_session_20180506.txt outputclass=WriteOutTEXT

I can also use different options if I want to translate the trace file to HTML or XML with





What can traces tell us

A typical trace file is an engineer’s delight. To give you an idea, this is a snippet

9615 [BUILTIN.END,3] Timestamp=53160, StartEvent=9614, Duration=0
9616 [BUILTIN.START,3] Timestamp=53160, EndEvent=9617, Name=SET_ITEM_INSTANCE_PROPERTY
 Type=In Position=1 DataType=INTEGER Value=131081
 Type=In Position=2 DataType=NUMBER Value=0
 Type=In Position=3 DataType=NUMBER Value=1526
 Type=In Position=4 DataType=STRING Value=BACKGROUND
 Type=In Position=5 DataType=STRING Value=NULL
9617 [BUILTIN.END,3] Timestamp=53160, StartEvent=9616, Duration=0
9618 [Local_PU.END,2] Timestamp=53160, StartEvent=9613, Duration=0
9619 [TRIGGER.END,1] Timestamp=53160, StartEvent=9612, Duration=0

9620 [NETWORK.WRITE] Timestamp=53160, StartEvent=9601, Duration=0, Packets=1, Bytes=742

9621 [NETWORK.READ] Timestamp=53220, EndEvent=9625, Duration=0, Packets=1, Bytes=270

9622 [ECID] Timestamp=53220, Value=XXXXXXXXXX
#9623 [Key] Timestamp=53220, FormName=XXX__YYY(3), KeyPressed=Up
9624 [ERROR] Timestamp=53220, Msg=
Error Message: FRM-40100: At first record.
9625 [NETWORK.WRITE] Timestamp=53220, StartEvent=9621, Duration=0, Packets=1, Bytes=94

Fun with traces

  • I extracted the NETWORK events timestamps.
[[email protected] karun]$

grep “NETWORK” trace_my_session_20180506.txt | tail -200

13378 [NETWORK.READ] Timestamp=185260, EndEvent=13397, Duration=0, Packets=1, Bytes=312
13397 [NETWORK.WRITE] Timestamp=185260, StartEvent=13378, Duration=0, Packets=1, Bytes=650
13398 [NETWORK.READ] Timestamp=185390, EndEvent=13417, Duration=0, Packets=1, Bytes=315
13417 [NETWORK.WRITE] Timestamp=185390, StartEvent=13398, Duration=0, Packets=1, Bytes=704
13418 [NETWORK.READ] Timestamp=185520, EndEvent=13437, Duration=0, Packets=1, Bytes=318
  • I graphed the timestamp data. I am interested in the timestamp intervals.

I am showing the timestamp in the X-axis and (Timestamp Next – Timestamp previous) on the Y-axis.

Notice the typical network timestamp interval is definitely above 100ms with spikes. In my head, this is telling us that the frmweb process on the server is idle for ~100ms while the next payload from the applet is yet to reach it!

Yes, it correlates with reality — the users are really complaining about the application being unresponsive to the keyboard input when they use this machine. It “freezes” too!

As a comparison, we ran the same form and gathered a trace from another machine in a different part of the network.

Here the network timestamp interval is around 50ms and it does spike a few times to be around 75ms.

On this machine the Users are able to work, but they do see a bit of freezing off and on. We are getting somewhere!
The traces point to yet another (previously overlooked) contributor to the slow response.

In conclusion

After some more digging, we found that the “slow” machines (running the applet) are in the network segments with really high latency.

TL&DR: Forms 12c  traces are a valuable source of information, easy to gather!
Instead of guessing why your form applications are slow and applying arbitrary fixes, please consider using the trace data next time.

Call us at Pythian anytime you need us to help with slow Forms 12c applications.

My apologies to the folks using windows as their forms server — I am sure you get the idea. The windows commands and file locations are very similar.

ps: In case you are wondering what is an acceptable network timestamp interval?

I would welcome your actual test results in your responses and if I hear more we could build another blog post.
For the people interested in keyboard latency numbers, I could find this.
Open question: Is the keyboard + ~10ms is the lowest possible network timestamp interval?


From our Readers

Thanks to Muhannad for posting a valuable suggestion!
If you are seeing for the version Forms 12c

Intermittent Slow Navigation Between Fields in Forms 12c (Doc ID 2712105.1)

Edit the $DOMAIN_HOME/config/config.xml and modify the WLS_FORMS server section to include:


Restart Forms Managed server after making this change.

The fix is published here as well:  Slow Navigation Between Items/Buttons Using Tab Key or Using Mouse (Doc ID 2720510.1)

… Looking forward to more comments from all of you

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I am a Solution Architect and a Google certified Data Engineer. My interests areas include IoT, Serverless functions, Bigdata Analytics, Oracle Middleware (OBIEE, ODI, SOA, Weblogic) and Oracle Database.

13 Comments. Leave new

Need your help with form slowness when migrated to db 12c from 11g.

CALL_FORM request takes approx 1-4 minutes as against 10 secs on 11g DB.


Hi Atif,

A few thoughts/suggestions
I am assuming your forms installation is Forms12c as that is the subject of the blog.

1. You say the DB is migrated from 11g –> 12c. I am not aware of anything that would affect the CALL_FORM built-in if the underlying DB is upgraded. In any case, you could use the steps in the blog and trace the forms session and look at the timings in the trace — that will be the first thing I would do.

2. You should also look at FORMS_PATH typically set in default.env. I am sure the target form lives in a directory under the setting for FORMS_PATH — because eventually, it does open. Is the FORMS_PATH set to a few other directories as well?

3. What memory settings are you using to run forms? Do you have enough memory (RAM) on the server where forms are running?

A CALL_FORM should not take 10 seconds! — That is already a sign of something not quite OK



Hi Karun

When I installed forms 12c patch set 3 in windows server 2016, I experience intermittent slowness in Curson navigation between items. What I should do to fix this issue


Hi Muhannad ( I hope I am spelling it right)

You should trace the form as shown in the blog while navigating and look at what the trace is telling you.
I am thinking block level triggers that call database queries or something longer than usual…


Muhannad Abdo
October 15, 2020 4:42 pm

Hi Karun,

it is bug
Intermittent Slow Navigation Between Fields in Forms 12c (Doc ID 2712105.1)

Oracle support has fixed it for us:

Edit the DOMAIN_HOME/config/config.xml and modify the WLS_FORMS server section to include:


for example:


Restart Forms Managed server after making this change.

Best Regards,
Muhannad Abdo


Hi Muhannad

Many Thanks! The Oracle Support Note : Intermittent Slow Navigation Between Fields in Forms 12c (Doc ID 2712105.1) does not have any workarounds published yet. If you could add a snippet of the config.xml that works — I can update the Original Blog also giving you attribution. Once again many thanks for sharing!


Muhannad Abdo
October 20, 2020 2:32 pm

Hi Karun,

you are welcome my friend,

the copy and past does not show the actual text, because it is XML format,

How can I put the screenshot?

Best Regards,



You can change the XML to use Square Brackets [ ] instead on < / >
It will then show up in the comments here.

I have already sent an email to you directly on your gmail account — so you could reply to that with a screenshot.


Muhannad Abdo
October 20, 2020 2:52 pm

Intermittent Slow Navigation Between Fields in Forms 12c (Doc ID 2712105.1)

Edit the DOMAIN_HOME/config/config.xml and modify the WLS_FORMS server section to add only 2 lines:


for example:


Restart Forms Managed server after making this change.

Note: the above [ ] should be replaced with < >

Best Regards,


Thank you Muhannad — updated the Blog to add your valuable suggestion!
Best Wishes



Hi Karun,

the fix is published by Oracle in here

Slow Navigation Between Items/Buttons Using Tab Key or Using Mouse (Doc ID 2720510.1)

Best Regards,


Hi Karun,
I am working in services team for the project Forms &Reports (jdk 1.8_241) as Tech consultant.
we are experiencing slowness in jnlp download for Oracle Forms Webstart based. This is happening in Edge browser and our client use Edge only. For other browsers Firefox and chrome first luanch it is taking time and next subsequent runs jnlp download is faster. But with edge is always slow (taking around 40 sec which is not acceptable)
Have you ever faced this kind of issue? if yes, please advice how to solve it.



Hi Jayaram

1. Look at this : https://www.oracle.com/a/tech/docs/fsal-usage-12214.pdf
2. Check in Edge tools : what is it doing to take that extra time

3. Engage us ;-)



Leave a Reply

Your email address will not be published. Required fields are marked *