Database Reference
In-Depth Information
Table 8-8.
Parameters of the Procedures Used for Deleting Object Statistics
Parameter
Database
Dictionary
Fixed Objects
Schema
Table
Column
Index
Target Objects
ownname
•
•
•
•
indname
•
tabname
•
•
colname
•
partname
•
•
•
cascade_parts
•
•
•
cascade_columns
•
cascade_indexes
•
stat_category
•
•
•
•
col_stat_type
•
force
•
•
•
•
•
•
•
Deleting Options
no_invalidate
•
•
•
•
•
•
•
Backup Table
stattab
•
•
•
•
•
•
•
statid
•
•
•
•
•
•
•
statown
•
•
•
•
•
•
•
The following call shows how to delete the histogram of one single column (a full example is found in the
delete_histogram.sql
script) without modifying the other statistics:
dbms_stats.delete_column_stats(ownname => user,
tabname => 'T',
colname => 'VAL',
col_stat_type => 'HISTOGRAM')
Exporting, Importing, Getting, and Setting Object Statistics
As illustrated earlier in Figure
8-1
, the
dbms_stats
package provides several procedures and functions that are
available in addition to those used for gathering statistics. I won't describe them here because they're not frequently
used in practice. For information about them, refer to the
Oracle Database PL/SQL Packages and Types Reference
manual. Nevertheless, I want to share the following piece of information that you don't find in the documentation.