How to begin troubleshooting Oracle Forms performance issues (client side with FSAL)
Oracle Forms 12.2.1.3 - server is running Oracle Linux 7. Database is 12.2.0.1.0
We have one form that seems particularly troublesome which cause the Java CPU and memory usage to climb significantly. I often need to kill the process altogether. I've tried the OpenJDK 1.8 JRE, OpenJDK 16 JDK, Oracle Java 1.8 JRE with the same results. Same for Windows and macOS clients.
I've been monitoring the server load on both the middleware server and database server, neither seem to be under any kind of load.
Since this issue occurs primarily on the client side (apparently) I don't know where to even begin troubleshooting this.
Any logs I should be looking at on client side or Linux server?