Best Practices for JVM and Memory Management Setting on Forms 12c?

Jessica Boggia

Hello all,

We have a set of oracle forms and reports servers that run with about 250 users at peak. Recently, we had to up the ulimit parameters server side to fix an issue where the server would become overloaded and node manager would crash.

The server runs RHEL7 and has 64GB of ram. Through the Admin Console I have set heap size on WLS_FORMS to have xmx of 16gb, WLS_REPORTS to have xmx of 12GB and I upped Node Manager to 2GB from the default of 500MB. But I really do not have a clear methodology as to what these should all ideally be set to for our load.

I was wondering if anyone had any resources on how to determine what these parameters should be set to for optimal performance for our configuration. We would like to prevent any crashing from occurring again.

Thank you!

Matthew D.

You can find here some details:

Oracle Forms & Reports 12.2.1.2.0: Create and Configure on the OEL 7.2 Server | The Cattle Crew Blog

Regards

Jessica Boggia

Hey Matthew,

Thanks for the link. However, that seems to be going over installation and initial config which we have already done. I see the modifications on setuserOveride.sh and it is good to know we can do that.

However, I am inquiring about what these values should be ideally. Does oracle have any recommendations on what the xmx parameters should be set to there and on other pages? Or what % of ram should be allocated to each for best performance?

Thank you

Dan Andro-Oracle

Hi Jessica,

There is no recommendation per se, this needs to be tested and adjusted based on the results of the tests. The principles are covered here: https://www.oracle.com/technetwork/developer-tools/forms/forms904capacityplanning-130985.pdf

The document was written for an old version, but, as I said, the principles are the same.

In regards to the values that you mentioned, those are too high; WLS_FORMS and WLS_REPORTS are just the containers for the application; in addition to those, each user session will create their own forms process, frmweb, on the server, which will consume memory. So you might want to take a look at How to Decrease Memory Usage in Forms 12c Using JVM Controllers (JVMControllers) (Doc ID 2343804.1).

Also, what Forms version do you have? If you're not already on the latest 12.2.1.4, then you should upgrade to that.

Regards,

Dan