Databases Reference
In-Depth Information
Procedures
The most relevant procedures are:
F
GATHER_SCHEMA_STATS
: gathers optimizer statistics for a schema class
F
GATHER_DATABASE_STATS
: gathers optimizer statistics for a database class
F
GATHER_TABLE_STATS
: gathers table statistics
F
GATHER_INDEX_STATS
: gathers index statistics
F
CREATE_STAT_TABLE
: creates the user statistics table
F
DROP_STAT_TABLE
: drops the user statistics table
F
EXPORT_SCHEMA_STATS
: exports schema statistics to a user statistics table
F
IMPORT_SCHEMA_STATS
: import schema statistics from a user statistics table
DBMS_UTILITY
This package provides various utility subprograms.
Procedures
The most relevant procedures are:
F
ANALYZE_SCHEMA
: analyzes all the tables, indexes, and clusters in a schema
F
ANALYZE_DATABASE
: analyzes all the tables, indexes, and clusters in a database
F
GET_TIME
: returns the current time in hundredths of a second
DBMS_WORKLOAD_REPOSITORY
This package allows management of Workload Repository.
Procedures
The most relevant procedures are:
F
CREATE_SNAPSHOT
: creates a manual snapshot
F
MODIFY_SNAPSHOT_SETTINGS
: modifies the snapshot settings
F
CREATE_BASELINE
: creates a single baseline