Results for DBMS_STATS


1 to 20 of 3675 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Tuning Guide, Release 20c

Optimizer Statistics Concepts

10.3.1 DBMS_STATS PackageThe DBMS_STATS PL/SQL package collects and manages optimizer statistics. This package enables you … deprecated. Instead, use DBMS_STATS. Statistics gathered with the DBMS_STATS package are required … for the creation of accurate execution plans. For example, table statistics gathered by DBMS_STATS … automatic

SQL Tuning Guide, Release 20c

Configuring Options for Optimizer Statistics Gathering

12.2.1.3 DBMS_STATS Procedures for Setting Statistics Preferencesfollowing table summarizes the relevant DBMS_STATS procedures. Table 12-1 DBMS_STATS Procedures for … the DBMS_STATS procedures for setting optimizer statistics preferences

SQL Tuning Guide, Release 20c

Gathering Optimizer Statistics

13.3.1 About Manual Statistics Collection with DBMS_STATSUse the DBMS_STATS package to manipulate optimizer statistics. You can gather statistics on objects … statistics for the physical system. The following table summarizes the DBMS_STATS procedures for … can gather statistics on individual tables in a table cluster. Table 13-1 DBMS_STATS Procedures for … \" Oracle Database PL/SQL

SQL Tuning Guide, Release 20c

Managing Historical Optimizer Statistics

16.1.4 Restoring Optimizer Statistics Using DBMS_STATStime ( as_of_timestamp ). Table 16-1 DBMS_STATS Restore Procedures Procedure Description … operations performed at schema and database level using DBMS_STATS. The DBA_TAB_STATS_HISTORY views contains … /20 because DBMS_STATS restores statistics as of the specified time. See Also: Oracle Database PL

SQL Tuning Guide, Release 20c

Gathering Optimizer Statistics

13.3.8.2 How DBMS_STATS Derives Global Statistics for Partitioned tablesWhen incremental statistics maintenance is enabled, DBMS_STATS gathers statistics and creates … run times. Any operational procedures that manage partitions reduce run time. The DBMS_STATS

SQL Tuning Guide, Release 19c

Optimizer Statistics Concepts

10.3.1 DBMS_STATS PackageThe DBMS_STATS PL/SQL package collects and manages optimizer statistics. This package enables you … deprecated. Instead, use DBMS_STATS. Statistics gathered with the DBMS_STATS package are required … for the creation of accurate execution plans. For example, table statistics gathered by DBMS_STATS … automatic

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.70 IMPORT_DICTIONARY_STATS ProcedureThis procedure imports statistics for all data dictionary schemas ( SYS, SYSTEM, and RDBMS component schemas) from the user statistics table and stores them in the dictionary. Syntax DBMS_STATS.IMPORT_DICTIONARY_STATS ( stattab VARCHAR2, statid VARCHAR2 DEFAULT NULL, statown VARCHAR2 DEFAULT NULL, no_invalidate BOOLEAN DEFAULT to_no_invalidate_type( get_param('NO_INVALIDATE')), force BOOLEAN DEFAULT

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.75 IMPORT_SYSTEM_STATS ProcedureThis procedure retrieves system statistics from the user statistics table, identified by stattab, and stores the statistics in the dictionary. Syntax DBMS_STATS.IMPORT_SYSTEM_STATS ( stattab VARCHAR2, statid VARCHAR2 DEFAULT NULL, statown VARCHAR2 DEFAULT NULL); Parameters Table 168-79 IMPORT_SYSTEM_STATS Procedure Parameters Parameter Description stattab Identifier of the user statistics table where

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.39 EXPORT_INDEX_STATS ProcedureThis procedure retrieves statistics for a particular index and stores them in the user statistics table identified by stattab. Syntax DBMS_STATS.EXPORT_INDEX_STATS ( ownname VARCHAR2, indname VARCHAR2, partname VARCHAR2 DEFAULT NULL, stattab VARCHAR2, statid VARCHAR2 DEFAULT NULL, statown VARCHAR2 DEFAULT NULL); Parameters Table 168-45 EXPORT_INDEX_STATS Procedure Parameters Parameter Description

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.65 GET_TABLE_STATS ProcedureThis overloaded procedure gets all table-related statistics. Syntax DBMS_STATS.GET_TABLE_STATS ( ownname VARCHAR2, tabname VARCHAR2, partname VARCHAR2 DEFAULT NULL, stattab VARCHAR2 DEFAULT NULL, statid VARCHAR2 DEFAULT NULL, numrows OUT NUMBER, numblks OUT NUMBER, avgrlen OUT NUMBER, statown VARCHAR2 DEFAULT NULL, realtime_stats BOOLEAN DEFAULT TRUE); DBMS_STATS.GET_TABLE_STATS ( ownname VARCHAR2,

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.86 PUBLISH_PENDING_STATS Procedureprocedure invalidates the dependent cursors immediately if set to FALSE. Use DBMS_STATS. AUTO_INVALIDATE

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.52 GATHER_SCHEMA_STATS Procedures, or DEGREE=>DBMS_STATS.DEFAULT_DEGREE, the current implementation of DBMS_STATS may use serial … set to FALSE. Use DBMS_STATS. AUTO_INVALIDATE. to have Oracle decide when to invalidate dependent

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.12 CREATE_EXTENDED_STATS FunctionThis function creates a column statistics entry in the system for a user-specified column group or an expression in a table. The database gathers statistics for this extension when a user-initiated or automatic statistics gathering job gathers statistics for the table. Statistics for such an extension are called extended statistics. This function returns the name of this newly created entry for the

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.67 IMPORT_COLUMN_STATS ProcedureFALSE. Use DBMS_STATS. AUTO_INVALIDATE. to have Oracle decide when to invalidate dependent cursors

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.7 CONVERT_RAW_VALUE ProceduresThis procedure converts the internal representation of a minimum value, maximum value, or histogram endpoint actual value into a datatype-specific value. The minval, maxval, and eavals fields of the StatRec structure as filled in by GET_COLUMN_STATS or PREPARE_COLUMN_VALUES are appropriate values for input. Syntax DBMS_STATS.CONVERT_RAW_VALUE ( rawval RAW, resval OUT BINARY_FLOAT); DBMS_STATS.CONVERT_RAW_VALUE

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.90 REPORT_COL_USAGE FunctionThis function reports the recorded column (group) usage information. Syntax DBMS_STATS.REPORT_COL_USAGE ( ownname IN VARCHAR2, tabname IN VARCHAR2) RETURN CLOB; Parameters Table 168-99 REPORT_COL_USAGE Function Parameters Parameter Description ownname Owner name. If NULL it reports column usage information for tables in all schemas in the database. tabname Table name. If NULL it reports column usage

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.34 EXPORT_COLUMN_STATS ProcedureThis procedure exports statistics for a specified column and stores them in the user statistics table identified by stattab. Syntax DBMS_STATS.EXPORT_COLUMN_STATS ( ownname VARCHAR2, tabname VARCHAR2, colname VARCHAR2, partname VARCHAR2 DEFAULT NULL, stattab VARCHAR2, statid VARCHAR2 DEFAULT NULL, statown VARCHAR2 DEFAULT NULL); Parameters Table 168-40 EXPORT_COLUMN_STATS Procedure Parameters Parameter

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.14 DELETE_COLUMN_STATS Procedureimmediately if set to FALSE. Use DBMS_STATS. AUTO_INVALIDATE. to have Oracle decide when to invalidate

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.122 SET_TABLE_STATS Procedureinvalidates the dependent cursors immediately. Use DBMS_STATS. AUTO_INVALIDATE to let the database decide

Database PL/SQL Packages and Types Reference, Release 20c

DBMS_STATS

168.7.29 DIFF_TABLE_STATS_IN_STATTAB FunctionThis function compares table statistics from two sources. The function can obtain statistics from the following sources: Two user statistics tables A single user statistics table containing two sets of statistics that can be identified using statids A user statistics table and dictionary The function also compares the statistics of the dependent objects: indexes, columns, and partitions. It displays


Was this page helpful?