DBMS_STATS

This package allows you to view and modify optimizer statistics.

Procedures

The most relevant procedures are:

• GATHER_SCHEMA_STATS : gathers optimizer statistics for a schema class

• GATHER_DATABASE_STATS: gathers optimizer statistics for a database class

• GATHER_TABLE_STATS: gathers table statistics

• GATHER_INDEX_STATS: gathers index statistics

• CREATE_STAT_TABLE: creates the user statistics table

• DROP_STAT_TABLE : drops the user statistics table

• EXPORT_SCHEMA_STATS : exports schema statistics to a user statistics table

• IMPORT_SCHEMA_STATS : import schema statistics from a user statistics table