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

VIEW: SYS.CDB_COL_PENDING_STATS

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

Pending statistics of tables, partitions, and subpartitions in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Table owner name
TABLE_NAME VARCHAR2 (30)
Table name
PARTITION_NAME VARCHAR2 (30)
Partition name
SUBPARTITION_NAME VARCHAR2 (30)
Subpartition 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 rows with value in the column
AVG_COL_LEN NUMBER

The average length of the column in bytes
SAMPLE_SIZE NUMBER

The sample size used in analyzing this column
LAST_ANALYZED DATE

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

container id
Query Text

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


SELECT OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      SUBPARTITION_NAME
,      COLUMN_NAME
,      NUM_DISTINCT
,      LOW_VALUE
,      HIGH_VALUE
,      DENSITY
,      NUM_NULLS
,      AVG_COL_LEN
,      SAMPLE_SIZE
,      LAST_ANALYZED
,      CON_ID
FROM SYS.CDB_COL_PENDING_STATS;

Dependencies

[top of page]

SYS.CDB_COL_PENDING_STATS does not reference any database object

SYS.CDB_COL_PENDING_STATS is referenced by following:

SchemaPUBLIC
SynonymCDB_COL_PENDING_STATS