Customer Interface (RACUST) for a large number of records run extremely slow. Please do the followings, hopefully performance should improve.
1) Run "Gather Schema Statistics"/"Gather Table Statistics" program for AR from System Administrator Responsibility.
> You can use fnd_stats/dbms_stats to gather schema/table statistics if you want to do it from back end.
2) Set HZ: Gather Table Stats profile value to 'Yes' at site level
> Navigation: System Administrator > Profile > System
> query for profile 'HZ: Gather Table Stats'
3) Set the profile option 'HZ: Number of Workers Used by Customer Interface' to a high value like 6 at the Site level.
4) Run "Customer Interface Master Conc Program" (RACUSTMA) instead of "Customers Interface".
1) Run "Gather Schema Statistics"/"Gather Table Statistics" program for AR from System Administrator Responsibility.
> You can use fnd_stats/dbms_stats to gather schema/table statistics if you want to do it from back end.
2) Set HZ: Gather Table Stats profile value to 'Yes' at site level
> Navigation: System Administrator > Profile > System
> query for profile 'HZ: Gather Table Stats'
3) Set the profile option 'HZ: Number of Workers Used by Customer Interface' to a high value like 6 at the Site level.
4) Run "Customer Interface Master Conc Program" (RACUSTMA) instead of "Customers Interface".
No comments:
Post a Comment