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 |