Description of all object and relational tables owned by the user's
Columns
___________________________
NUM_FREELIST_BLOCKS
The number of blocks on the freelist
DEGREE
The number of threads per instance for scanning the table
INSTANCES
The number of instances across which the table is to be scanned
CACHE
Whether the table is to be cached in the buffer cache
TABLE_LOCK
Whether table locking is enabled or disabled
SAMPLE_SIZE
The sample size used in analyzing this table
LAST_ANALYZED
The date of the most recent time this table was analyzed
PARTITIONED
Is this table partitioned? YES or NO
IOT_TYPE
If index-only table,then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL
OBJECT_ID_TYPE
If user-defined OID,then USER-DEFINED,else if system generated OID,then SYSTEM GENERATED
TABLE_TYPE_OWNER
Owner of the type of the table if the table is an object table
TABLE_TYPE
Type of the table if the table is an object table
TEMPORARY
Can the current session only see data that it place in this object itself?
SECONDARY
Is this table object created as part of icreate for domain indexes?
NESTED
Is the table a nested table?
BUFFER_POOL
The default buffer pool to be used for table blocks
ROW_MOVEMENT
Whether partitioned row movement is enabled or disabled
GLOBAL_STATS
Are the statistics calculated without merging underlying partitions?
USER_STATS
Were the statistics entered directly by the user?
DURATION
If temporary table,then duration is sys$session or sys$transaction else NULL
SKIP_CORRUPT
Whether skip corrupt blocks is enabled or disabled
MONITORING
Should we keep track of the amount of modification?
CLUSTER_OWNER
Owner of the cluster,if any,to which the table belongs
DEPENDENCIES
Should we keep track of row level dependencies?
TABLE_NAME
Name of the table
TABLESPACE_NAME
Name of the tablespace containing the table
CLUSTER_NAME
Name of the cluster,if any,to which the table belongs
IOT_NAME
Name of the index-only table,if any,to which the overflow or mapping table entry belongs
PCT_FREE
Minimum percentage of free space in a block
PCT_USED
Minimum percentage of used space in a block
INI_TRANS
Initial number of transactions
MAX_TRANS
Maximum number of transactions
INITIAL_EXTENT
Size of the initial extent in bytes
NEXT_EXTENT
Size of secondary extents in bytes
MIN_EXTENTS
Minimum number of extents allowed in the segment
MAX_EXTENTS
Maximum number of extents allowed in the segment
PCT_INCREASE
Percentage increase in extent size
FREELISTS
Number of process freelists allocated in this segment
FREELIST_GROUPS
Number of freelist groups allocated in this segment
LOGGING
Logging attribute
BACKED_UP
Has table been backed up since last modification?
NUM_ROWS
The number of rows in the table
BLOCKS
The number of used blocks in the table
EMPTY_BLOCKS
The number of empty (never used) blocks in the table
AVG_SPACE
The average available free space in the table
CHAIN_CNT
The number of chained rows in the table
AVG_ROW_LEN
The average row length,including row overhead
AVG_SPACE_FREELIST_BLOCKS
The average freespace of all blocks on a freelist