Tuesday, July 8, 2008

How to gather statistics in Oracle apps from backend

Use the following command to gather schema statistics:
exec fnd_stats.gather_schema_statistics('ONT') < For a specific schema >
exec fnd_stats.gather_schema_statistics('ALL') < For all schemas >

No comments: