When we are facing performance issues with frmweb sessions, below CONTEXT_FILE variables must be considered – FORMS_CATCHTERM – This variable decides enabling/disabling of forms abnormal termination handler(FATH). FATH basically writes diagnostic information into dumpfile or form server log. Default value is '1'. FORMS_RECORD_GROUP_MAX – This is a customized environment variable when using in servlet mode while we can directly set this in socket.env with socket mode. FORMS_MMAP – This is mainly monitored in socket mode. When set to 0 will not put .fmx files in shared memory mapped files resulting in more memory consumption. Recommended value for this variable is 1. Scenario - Common frmweb process issues are with high CPU and memory consumption. This results in slowing down application server where forms services are running. Whenever an end user is working LOVs fetching huge number of records, these records are loaded in memory and result in ...
Blog about Oracle, E-Business Suite, Cassandra, Oracle Cloud, Linux Administration ideal for system administrators, database administrators