My Oracle Support Banner

How To Gather Statistics For Oracle Applications Prior to 11.5.10 (Doc ID 122371.1)

Last updated on AUGUST 09, 2023

Applies to:

Oracle Advanced Pricing - Version 11.5 to 11.5.9 [Release 11.5]
Information in this document applies to any platform.


Prior to Release 11i, Oracle Applications have defaulted to use the Rule-Based Optimizer. Oracle's Applications development team has reviewed SQL statements in 11i to tune them for use by the Cost-Based Optimizer (CBO). CBO uses statistics to decide the execution of SQL statements. FND_STATS is a vital part of collecting this data.

Proper configuration of your Oracle 8i/9i server requires that you gather statistics for the objects in your database. Recommendation is that you gather new statistics after the completion of an upgrade or installation, upon loading large amounts of data into the database, and thereafter gather statistics on a regular basis. Please not that objects with a high throughput and/or large data volumes may require that statistics are gathered more frequently, such as daily.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 Gathering Statistics Concurrent Requests
 Summary of FND_STATS Subprograms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.