DBMS_STATS Package
The procedures in this package gather and manage statistics. Procedures are:
GATHER_ INDEX_STATS - get index stats.
GATHER_TABLE_STATS - get table, column, and index stats.
GATHER_SCHEMA_STATS - get stats for all objects in the schema.
GATHER_DATABASE_STATS - get stats for all objects in the database.
EXPORT_SCHEMA_STATS - extracts and saves the current stats.
IMPORT_SCHEMA_STATS - restores previously exported stats.
No comments:
Post a Comment