Delete_table_prefs
is a procedure that deletes statistics preferences for the table
specified. The valid values for the
pname parameter are CASCADE, DEGREE, ESTIMATE_PERCENT,
METHOD_OPT, NO_INVALIDATE, GRANULARITY, PUBLISH, INCREMENTAL and
STALE_PERCENT.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PNAME
|
VARCHAR2
|
IN
|
|
Table 7.83:
Delete_table_prefs Parameters
Delete_table_stats
is a procedure that drops table level statistics for the specified
table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
NULL
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
CASCADE_PARTS
|
BOOLEAN
|
IN
|
TRUE
|
|
CASCADE_COLUMNS
|
BOOLEAN
|
IN
|
TRUE
|
|
CASCADE_INDEXES
|
BOOLEAN
|
IN
|
TRUE
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
NO_INVALIDATE
|
BOOLEAN
|
IN
|
AUTO_INVALIDATE
|
|
FORCE
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.84:
Delete_table_stats Parameters
Diff_table_stats_in_history
is a function that compares the collected statistics from two
different historical time periods and reports on the differences. It
returns those differences as multiple occurrences of type DiffRepTab
(refer to data types section above).
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
TIME1
|
TIMESTAMP WITH TIME ZONE
|
IN
|
|
|
TIME2
|
TIMESTAMP WITH TIME ZONE
|
IN
|
NULL
|
|
PCTTHRESHOLD
|
NUMBER
|
IN
|
10
|
Table 7.85:
Diff_table_stats_in_history Parameters
Diff_table_stats_in_pending
is a function that compares the pending statistics with collected
statistics from the current period and reports on the differences. It
returns those differences as multiple occurrences of type DiffRepTab.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
TIMESTAMP
|
VARCHAR2
|
IN
|
NULL
|
|
PCTTHRESHOLD
|
NUMBER
|
IN
|
10
|
Table 7.86:
Diff_table_stats_in_pending Parameters
Diff_table_stats_in_stattab
is a function that compares statistics from two different sources
where those sources can be two different statistics tables: a single
statistics table but for different STATID references, or a statistics
table and the data dictionary. It returns those differences as
multiple occurrences of type DiffRepTab (refer to data types section
above).
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
STATTAB1
|
VARCHAR2
|
IN
|
|
|
STATTAB2
|
VARCHAR2
|
IN
|
NULL
|
|
PCTTHRESHOLD
|
NUMBER
|
IN
|
10
|
|
STATIS1
|
|
IN
|
NULL
|
|
STATID2
|
|
IN
|
NULL
|
|
STATTAB1OWN
|
|
IN
|
NULL
|
|
STATTAB2OWN
|
|
IN
|
NULL
|
Table 7.87:
Diff_table_stats_in_stattab Parameters
Drop_extended_stats
is a procedure that drops a column level statistics entry for either a
user specified column, column group, or an expression of columns in a
table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
EXTENSION
|
VARCHAR2
|
IN
|
|
Table 7.88:
Drop_extended_stats Parameters
Drop_stat_table
is a procedure that drops user specified statistics table STATTAB
which can be used to hold statistics generated by procedures and
functions in the
DBMS_STATS package.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
Table 7.89:
Drop_stat_table Parameters
Export_column_stats
is a procedure that copies column level statistics for the specified
column, column group or column expression to a user defined statistics
table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
OWNNAME
|
VARCHAR2
|
IN
|
|
|
TABNAME
|
VARCHAR2
|
IN
|
|
|
COLNAME
|
VARCHAR2
|
IN
|
|
|
PARTNAME
|
VARCHAR2
|
IN
|
NULL
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.90:
Export_column_stats Parameters
Export_database_prefs
is a procedure that exports the statistics preferences of all the
tables, except those owned by Oracle such as SYS and SYSTEM.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
|
ADD_SYS
|
BOOLEAN
|
IN
|
FALSE
|
Table 7.91:
Export_database_prefs Parameters
Export_database_stats
is a procedure that copies the statistics of all the tables, except
those owned by Oracle such as SYS and SYSTEM, into the user specified
statistics table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.92:
Export_database_stats Parameters
Export_dictionary_stats
is a procedure that copies the statistics of all the data dictionary
tables, except those owned by Oracle such as SYS and SYSTEM,
into the user specified statistics table.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
STATTAB
|
VARCHAR2
|
IN
|
|
|
STATID
|
VARCHAR2
|
IN
|
NULL
|
|
STATOWN
|
VARCHAR2
|
IN
|
NULL
|
Table 7.93:
Export_dictionary_stats Parameters
and include the URL for the page.
