Checklist for Forms Slowness

Posted by VinodNN on Oct 19, 2023; 10:09am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Checklist-for-Forms-Slowness-tp12125.html

Hi Erman,

I am trying to make a check list of things to do when users complain of forms slowness in EBS:

1. Check overall server health/load.
2. Check database session of the form (ORACLE_SESSION_ID column of FND_USER, joined with audsid from V$SESSION).
3. Check number of managed servers for forms and their heap size.
4. Check statistics of the database.
5. Enable forms trace and analyze the tracefile/s.

Please add to this list if I have missed some things.

Regards,
Vinod