home - keyword index

Table: DBA_TABLES

Description of all relational tables in the database

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

home - keyword index

Comment on this page: