Try setting the environment variable DE_ALL_OBJECTS_HINT to YES and run adadmin again.
Thanks Bashar for your response. Please confirm if below steps can help :
1. Stop current adadmin using adctrl and ask workers to leave.
2. Set env variable on APPLICATION NODE
3. Start adadmin and resume with previous job.
4. Once adadmin completes, unset env variable for de_all_object_hint
Thanks & Regards,
They may help.
Give it a try and update us.
Thanks ! I will update you.
Is the issue with compiling forms only? Do you have same performance issue when running other jobs via adadmin?
Do you have 10g Forms/Report patchset applied as per (Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)) along with other patches mentioned in the doc?
Can you try and use OS tracing (strace or truss) and see if this collect more details about the issue?
Do you have all patches in (Oracle E-Business Suite Recommended Performance Patches (Doc ID 244040.1)) applied?
The correct env variable name is "DE_ALL_OBJECTS_HINT" -- It's OBJECTS not OBJECT.
1 person found this helpful
There was little bit of improvement with your solution , but below solution was really helpful: Oracle Applications DBA: Form Compilation Against a 11g Database Hangs or Takes a Very Long Time [ID 880660.1]