Gather Schema Statistics Manual Script:

Please find the below reference Metalink Note ID: 190177.1 , part of Information is mentioned below :

OVERVIEW:
coe_stats.sql verifies the statistics in the data dictionary for all tables
owned by installed Oracle Apps modules. It generates a dynamic script
coe_fix_stats.sql and a report coe_stats.log.
The generated report coe_stats.log contains the list of tables that need
to be analyzed, including the actual (former) number of rows and the
suggested sample size for the next statistics gathering.
The dynamic script generated coe_fix_stats.sql includes the commands to
execute the FND_STATS packege to gather the statistics based on the number
of days since last analyzed and the size of the table.

INSTRUCTIONS:
Run coe_stats.sql with no parameters and review coe_stats.log file. If
output is approved, remove comment line on '-- @coe_fix_stats' at the end
of this script and run it again, or run coe_fix_stats.sql manually.
This coe_stats.sql script should be run once per week.

Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”