Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_COL_PENDING_STATS Pending statistics of tables, partitions, and subpartitions

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)YTable owner name
2TABLE_NAMEVARCHAR230(null)YTable name
3PARTITION_NAMEVARCHAR230(null)YPartition name
4SUBPARTITION_NAMEVARCHAR230(null)YSubpartition name
5COLUMN_NAMEVARCHAR230(null)YColumn name
6NUM_DISTINCTNUMBER22(null)YThe number of distinct values in the column
7LOW_VALUERAW32(null)YThe low value in the column
8HIGH_VALUERAW32(null)YThe high value in the column
9DENSITYNUMBER22(null)YThe density of the column
10NUM_NULLSNUMBER22(null)YThe number rows with value in the column
11AVG_COL_LENNUMBER22(null)YThe average length of the column in bytes
12SAMPLE_SIZENUMBER22(null)YThe sample size used in analyzing this column
13LAST_ANALYZEDDATE7(null)YThe date of the most recent time this column was analyzed

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:23
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here