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

VIEW: SYS.CDB_TAB_COL_STATISTICS

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

Columns of user's tables, views and clusters in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Table, view or cluster owner
TABLE_NAME VARCHAR2 (30)
Table, view or cluster name
COLUMN_NAME VARCHAR2 (30)
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
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      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
,      CON_ID
FROM SYS.CDB_TAB_COL_STATISTICS;

Dependencies

[top of page]

SYS.CDB_TAB_COL_STATISTICS does not reference any database object

SYS.CDB_TAB_COL_STATISTICS is referenced by following:

SchemaPUBLIC
SynonymCDB_TAB_COL_STATISTICS