|
DBA_TAB_COL_STATISTICS
Columns of user's tables, views and clustersColumns ___________________________ USER_STATS Were the statistics entered directly by the user? COLUMN_NAME Column name NUM_DISTINCT The number of distinct values in the column LOW_VALUE The low value in the column HIGH_VALUE The high value in the column DENSITY The density of the column NUM_NULLS The number of nulls in the column GLOBAL_STATS Are the statistics calculated without merging underlying partitions? AVG_COL_LEN The average length of the column in bytes NUM_BUCKETS The number of buckets in histogram for the column TABLE_NAME Table, view or cluster name LAST_ANALYZED The date of the most recent time this column was analyzed SAMPLE_SIZE The sample size used in analyzing this column
Related Commands:
DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS