Saturday, November 06, 2010

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 > 



Regards,
Sukhwinder singh




.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget