We are running into some performance issues around Forms 12.2.1.19.0 under Windows x64. I found this article.
Intermittent Slow Navigation Between Fields in Forms 12c
Wondering if this is still applicable for Forms 12.2.1.19.0 under FMW 12.2.1.4.0?
When I look behind it states this.
Oracle Forms - Version 12.2.1.3.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Symptoms
After upgrading Forms to 12.2.1.3, intermittent slow navigation between fields in forms. This can occur using the tab button or the mouse. There is a slight delay (instead of instantanious, it may take a second) and the hourglass may display briefly. It does not happen on every move, but could take many moves.
Changes
Upgrade to Forms 12.2.1.3
Cause
The issue is investigated by Bug 30223130 - INTERMITTENT SLOW NAVIGATION BETWEEN FIELDS IN FORMS
Solution
Add below setting to DOMAIN_HOME/config/config.xml for WLS_FORMS:
<self-tuning-thread-pool-size-min>100</self-tuning-thread-pool-size-min>
<self-tuning-thread-pool-size-max>200</self-tuning-thread-pool-size-max>
e.g
<server>
<name>WLS_FORMS</name>
<self-tuning-thread-pool-size-min>100</self-tuning-thread-pool-size-min>
<self-tuning-thread-pool-size-max>200</self-tuning-thread-pool-size-max>
This setting is a parameter that determines the maximum and minimum number of threads used by WebLogic Server. The number of active threads does not exceed this maximum, so the maximum affects the number of concurrent Forms connections. If you have a large number of simultaneous connections, please consider adjusting the max value to a larger value according to the usage conditions.