FORMS_CATCHTERM

What is FORMS60_CATCHTERM(R11)/FORMS_CATCHTERM(R12)?

FORMS60_CATCHTERM is an environment setting that enables (value = 1 by default) or
disables (value = 0) the Forms abnormal termination handler which catches middle tier crashes
and cleans up by removing temp files, closing db connections and
writing diagnostic info to the dump file or the forms server log file.
The Forms signal handler can be disabled to troubleshoot spinning/hanging f60webmx processes.

On R12,We may find forms process(frmweb) almost consumes 100% of the CPU.
Metalink Note (Doc ID:745711.1) provide a solution for this issues.
Subject:Forms Process (FRMWEB) Consumes 100% of CPU in Oracle Applications R12

the main steps of this solution are
1.change FORMS_CATCHTERM to zero
2.add FORMS_RECORD_GROUP_MAX in env template files
3.run autoconfig.

FORMS_CATCHTERM=0;

FORMS_RECORD_GROUP_MAX=10000
export FORMS_RECORD_GROUP_MAX

if we want to change it manually,related files are as below:
1.$ORACLE_CONFIG_HOME/forms/server/default.env
2.$ORACLE_CONFIG_HOME/forms/server/socket.env
3.$APPL_TOP/$APPLFENV

Related Notes:
Doc ID:744143.1 Subject:Tuning performance on eBusiness suite
Doc ID:294749.1 Subject:Troubleshooting WebForms Tuning / Performance /Time out Problems

-EOF-

posted @ 2010-07-19 14:18  dbblog  阅读(680)  评论(0编辑  收藏  举报