How to gather statistics on Oracle eBS.

Don't use package DBMS_STATS to do that, using FND_STATS is a good command.

Also,don't use the ANALYZE command.

Eg.

Use the following command to gather schema statistics:
exec fnd_stats.gather_schema_statistics('PO')
exec fnd_stats.gather_schema_statistics('ALL')

Use the following command for gathering statistics on a temporary table
(ie: temporary tablename = temp1 in schema INV):
exec fnd_stats.gather_table_stats('INV','temp1');

[@more@]