Tag Archives: Gathering Statistics in Release 11i and R12

Gathering Statistics in Release 11i and R12

In order to use Cost Based Optimizer effectively, the statistics must be current. Fortunately, Oracle has provided some scripts and concurrent programs to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous functions that will assist in this administrative task. This package can be invoked either from a seeded Concurrent Program, or directly from SQL*Plus. It is not … Continue reading Gathering Statistics in Release 11i and R12 »