本文档提供了DBMS_STATS包中子程序的详细说明，包括用于管理数据库统计信息的各种过程和函数，如收集、导出、导入统计信息等。
Summary of DBMS_STATS Subprograms
Table 141-2 DBMS_STATS Package Subprograms
| Subprogram | Description |
|---|---|
| Changes the statistics history retention value | |
| Convert the internal representation of a minimum or maximum value into a datatype-specific value | |
| Convert the internal representation of a minimum or maximum value into a datatype-specific value | |
| Convert the internal representation of a minimum or maximum value into a datatype-specific value | |
| Copies the statistics of the source [sub] partition to the destination [sub] partition after scaling | |
| Creates a virtual column for a user specified column group or an expression in a table | |
| Creates a table with name | |
| Deletes column-related statistics | |
| Deletes the statistics preferences of all the tables, excluding the tables owned by Oracle | |
| Deletes statistics for the entire database | |
| Deletes statistics for all dictionary schemas (' | |
| Deletes statistics of all fixed tables | |
| Deletes index-related statistics | |
| Deletes the private statistics that have been collected but have not been published | |
| Deletes the statistics preferences of all the tables owned by the specified owner name | |
| Deletes schema-related statistics | |
| Deletes system statistics | |
| Deletes statistics preferences of the specified table in the specified schema | |
| Deletes table-related statistics | |
| Compares statistics for a table from two timestamps in past and compare the statistics as of that timestamps | |
| Compares pending statistics and statistics as of a timestamp or statistics from dictionary | |
| Compares statistics for a table from two different sources | |
| Drops the statistics entry that is created for the user specified extension | |
| Drops a user statistics table created by | |
| Retrieves statistics for a particular column and stores them in the user statistics table identified by | |
| Exports the statistics preferences of all the tables, excluding the tables owned by Oracle | |
| Retrieves statistics for all objects in the database and stores them in the user statistics table identified by | |
| Retrieves statistics for all dictionary schemas (' | |
| Retrieves statistics for fixed tables and stores them in the user statistics table identified by | |
| Retrieves statistics for a particular index and stores them in the user statistics table identified by | |
| Exports the statistics gathered and stored as pending | |
| Exports the statistics preferences of all the tables owned by the specified owner name | |
| Retrieves statistics for all objects in the schema identified by ownname and stores them in the user statistics table identified by | |
| Retrieves system statistics and stores them in the user statistics table | |
| Exports statistics preferences of the specified table in the specified schema into the specified statistics table | |
| Retrieves statistics for a particular table and stores them in the user statistics table | |
| Flushes in-memory monitoring information for all the tables to the dictionary | |
| Gathers statistics for all objects in the database | |
| Gathers statistics for dictionary schemas ' | |
| Gathers statistics of fixed objects | |
| Gathers index statistics | |
| Gathers statistics for all objects in a schema | |
| Gathers system statistics | |
| Gathers table and column (and index) statistics | |
| Generates object statistics from previously collected statistics of related objects | |
| Gets all column-related information | |
| Gets all index-related information | |
| Gets the default value of parameters of | |
| Gets the default value of the specified preference | |
| Gets the oldest timestamp where statistics history is available | |
| Returns the current retention value | |
| Gets system statistics from stattab, or from the dictionary if stattab is | |
| Gets all table-related information | |
| Retrieves statistics for a particular column from the user statistics table identified by | |
| Imports the statistics preferences of all the tables, excluding the tables owned by Oracle | |
| Retrieves statistics for all objects in the database from the user statistics table and stores them in the dictionary | |
| Retrieves statistics for all dictionary schemas (' | |
| Retrieves statistics for fixed tables from the user statistics table identified by | |
| Retrieves statistics for a particular index from the user statistics table identified by | |
| Imports the statistics preferences of all the tables owned by the specified owner name | |
| Retrieves statistics for all objects in the schema identified by | |
| Retrieves system statistics from the user statistics table and stores them in the dictionary | |
| Sets the statistics preferences of the specified table in the specified schema | |
| Retrieves statistics for a particular table from the user statistics table identified by | |
| Locks statistics for a partition | |
| Locks the statistics of all tables of a schema | |
| Locks the statistics on the table | |
| Merges column usage information from a source database, by means of a dblink, into the local database | |
| Converts user-specified minimum, maximum, and histogram endpoint datatype-specific values into Oracle's internal representation for future storage using the SEED_COL_USAGE Procedure | |
| Converts user-specified minimum, maximum, and histogram endpoint datatype-specific values into Oracle's internal representation for future storage using the SEED_COL_USAGE Procedure | |
| Converts user-specified minimum, maximum, and histogram endpoint datatype-specific values into Oracle's internal representation for future storage using the SEED_COL_USAGE Procedure | |
| Publishes the statistics gathered and stored as pending | |
| Purges old versions of statistics saved in the dictionary | |
| Resets the default values of all parameters to Oracle recommended values | |
| Resets global preferences to default values [see Deprecated Subprograms ] | |
| Restores statistics of all dictionary tables (tables of ' | |
| Restores statistics of all fixed tables as of a specified timestamp | |
| Restores statistics of all tables of a schema as of a specified timestamp | |
| Restores statistics of all tables of a schema as of a specified timestamp | |
| Restores statistics of a table as of a specified timestamp (as_of_timestamp), as well as statistics of associated indexes and columns | |
| Iterates over the SQL statements in the specified SQL tuning set, compiles them and seeds column usage information for the columns that appear in these statements | |
| Sets column-related information | |
| Sets the statistics preferences of all the tables, excluding the tables owned by Oracle | |
| Sets the global statistics preferences | |
| Sets index-related information | |
| Sets default values for parameters of | |
| Sets the statistics preferences of all the tables owned by the specified owner name | |
| Sets system statistics | |
| Sets the statistics preferences of the specified table in the specified schema | |
| Sets table-related information | |
| Returns the name of the virtual column that is created for the user-specified extension | |
| Unlocks the statistics for a partition | |
| Unlocks the statistics on all the table in a schema | |
| Unlocks the statistics on the table | |
| Upgrades user statistics on an older table |
扫一扫
946
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
