In our EBS R12 instance we have seen forms process consuming high CPU resources causing other applications processes to run slow.
Our EBS R12 application is running in servlet mode. Below solution has helped us in countering the situation.
A) Stop all services on the middle tier.
B) Set following forms environment variables using export Commnad:
- FORMS_RECORD_GROUP_MAX to 10000 or if that proves too restrictive, increase it to 20000 or 30000. The higher the value is set may impact existingresourses where that should be considered when changing it.
- FORMS_CATCHTERM=0
C) In order to set the above forms variables so next time autoconfig run does not override those values, do the following steps :
1. For Forms Variable “FORMS_CATCHTERM” the context vairable name is: “s_forms_catchterm” and you can update the context file located in
($INST_TOP/appl/admin/<SID_HOSTNAME.xml>)
2. For other forms variable “FORMS_RECORD_GROUP_MAX” there is no variable defined in Autoconfig for that one and have to customize the autoconfig for the forms variables to set that environment as following:
a- Go to the autoconfig Template folder:
$cd $AD_TOP/admin/template
b- Create new directory named (custom)
$ mkdir custom
c- Make sure that new directory has same file permissions as ($AD_TOP/admin/template)
d- Copy the following autoconfig template to the new custom directory:
$cp $AD_TOP/admin/template/APPLSYS_ux.env $AD_TOP/admin/template/custom/APPLSYS_ux.env
e- Edit the file copied file under custom directory and add the following 2
lines at the end of section:
f- Save and exit from the file.
g- Next time autoconfig run, it will read the custom directory and check for any customizations there.
D) . Run Autoconfig on the middle tier and make sure it is completed successfully.
E) Startup all services.
F) Monitor the forms process to see its CPU usage, and you will see that form process usage is reduced and not causing any more CPU consumption up to 100% as before.
G) Migrate the solution as appropriate to other environments.
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
Latest posts by Brijesh Gogia (see all)
- Oracle Multitenant DB 4 : Parameters/SGA/PGA management in CDB-PDB - July 18, 2021
- Oracle Multitenant DB 3 : Data Dictionary Architecture in CDB-PDB - March 20, 2021
- Oracle Multitenant DB 2 : Benefits of the Multitenant Architecture - March 19, 2021
Forms Process (FRMWEB) Consumes 100% of CPU issue above mentioned parameters only for EBS or we can use for weblogic fusion middle ware also