Gather Schema Statistics
4 min readJul 4, 2022
This concurrent program gathers the specified schema level statistics
This program also creates histograms on the columns seeded in the FND_HISTOGRAM_COLS table
For a detailed description of the procedure used by this concurrent program, see information on the GATHER_SCHEMA_STATS procedure
Parameters
Schema Name
Schema for which statistics are to be gathered. Specify ALL for all Oracle E-Business Suite schemas (all schemas that have an entry in the FND_PRODUCT_INSTALLATIONS table).