Checklist for Forms Slowness

[VinodNN]

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

[ErmanArslansOracleBlog]

Check apps node's load too..
Ensure there are no forms process spinning on CPU --for a long time. (OS level check)

[VinodNN]

Thanks Erman!