DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.USER_TAB_COL_STATISTICS

Object Details
Object Name: USER_TAB_COL_STATISTICS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Columns of user's tables, views and clusters

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (128)
Table, view or cluster name
COLUMN_NAME VARCHAR2 (128)
Column name
NUM_DISTINCT NUMBER

The number of distinct values in the column
LOW_VALUE RAW (1000)
The low value in the column
HIGH_VALUE RAW (1000)
The high value in the column
DENSITY NUMBER

The density of the column
NUM_NULLS NUMBER

The number of nulls in the column
NUM_BUCKETS NUMBER

The number of buckets in histogram for the column
LAST_ANALYZED DATE

The date of the most recent time this column was analyzed
SAMPLE_SIZE NUMBER

The sample size used in analyzing this column
GLOBAL_STATS VARCHAR2 (3)
Are the statistics calculated without merging underlying partitions?
USER_STATS VARCHAR2 (3)
Were the statistics entered directly by the user?
NOTES VARCHAR2 (63)
Notes regarding special properties of the stats
AVG_COL_LEN NUMBER

The average length of the column in bytes
HISTOGRAM VARCHAR2 (15)
SCOPE VARCHAR2 (7)
whether statistics for the object is shared or session
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLE_NAME
,      COLUMN_NAME
,      NUM_DISTINCT
,      LOW_VALUE
,      HIGH_VALUE
,      DENSITY
,      NUM_NULLS
,      NUM_BUCKETS
,      LAST_ANALYZED
,      SAMPLE_SIZE
,      GLOBAL_STATS
,      USER_STATS
,      NOTES
,      AVG_COL_LEN
,      HISTOGRAM
,      SCOPE
FROM SYS.USER_TAB_COL_STATISTICS;

Dependencies

[top of page]

SYS.USER_TAB_COL_STATISTICS references the following:

SchemaSYS
TableCOL$
TableFIXED_OBJ$
TableHISTGRM$
TableHIST_HEAD$
TableOBJ$
ViewUSER_TABLES
ViewUSER_TAB_COLS_V$
SYS.USER_TAB_COL_STATISTICS is referenced by following:

SchemaPUBLIC
SynonymUSER_TAB_COL_STATISTICS