Description of relational tables accessible to the user
Columns
___________________________
OWNER
Owner of the table
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
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
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?
Related:
DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES DBA_PARTIAL_DROP_TABS ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS DBA_PART_TABLES ALL_PART_TABLES USER_PART_TABLES DBA_TABLES ALL_TABLES USER_TABLES TAB DBA_TABLESPACES USER_TABLESPACES DBA_TAB_COLUMNS ALL_TAB_COLUMNS USER_TAB_COLUMNS DBA_TAB_COLS ALL_TAB_COLS USER_TAB_COLS DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS DBA_TAB_HISTOGRAMS ALL_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS DBA_TAB_PARTITIONS ALL_TAB_PARTITIONS USER_TAB_PARTITIONS DBA_CONSTRAINTS