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.
Purpose
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
| Purpose |
| Troubleshooting Steps |
| Gathering Statistics Concurrent Requests |
| Summary of FND_STATS Subprograms |
| References |