The default is 256M what is the recommended settings based on? It is the size of the DB? number of connections?
If the DB has over 200GB of data and max connection of 400 then will I need to make this settings higher? Thanks.
-XMX settings recommendation
#1
Trianglehead
#2
support
There is no magic formula, but usually larger is better, as long as you have sufficient RAM.
You can track the actual heap size in production and see if it is sufficient.
If you have RAM constraints and the heap size is tight, you may have to reduce the sizes of the processing cache, the L2 data cache, and the query results cache.
ObjectDB Support