Analyzing Database Objects

This section provides information about updating statistics, about the physical characteristics of a table, and the associated indexes. These characteristics include number of records, number of pages, and average record length. The optimizer uses these statistics while determining access paths to the data. The topics covered are:

Analyzing Entire CISDBA Schema
Analyzing all Classes
Analyzing all Indexes
Rebinding Packages