Gather Schema Statistics

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).

Percent

The sampling percentage. If left blank, the default value of 10 is used. The valid range is from 0 to 100.

Degree

The degree of parallelism to be used for gathering statistics. If a Degree is not provided, it defaults to the minimum of parallel_max_servers and cpu_count

Backup Flag

The backup flag indicates whether to backup statistics. Set this flag to BACKUP if you wish to back up the current statistics into the FND_STATTAB table. If NOBACKUP is used, then the GATHER_SCHEMA_STATS procedure will not backup the current statistics. This way the GATHER_SCHEMA_STATS procedure will run faster.

Restart Request ID

In the case where the Gather Schema Statistics run fails due to whatever reasons, the concurrent request can be re-submitted and it will pick up where the failed run left…