|
DBA_TABLES
Description of all relational tables in the databaseColumns ___________________________ NEXT_EXTENT Size of secondary extents in bytes BUFFER_POOL The default buffer pool to be used for table blocks ROW_MOVEMENT Whether partitioned row movement is enabled or disabled MAX_EXTENTS Maximum number of extents allowed in the segment 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? NESTED Is the table a nested table? MIN_EXTENTS Minimum number of extents allowed in the segment TABLE_NAME Name of the table INITIAL_EXTENT Size of the initial extent in bytes MAX_TRANS Maximum number of transactions INI_TRANS Initial number of transactions PCT_USED Minimum percentage of used space in a block SECONDARY Is this table object created as part of icreate for domain indexes? TABLESPACE_NAME Name of the tablespace containing the table IOT_NAME Name of the index-only table, if any, to which the overflow entry belongs OWNER Owner of the table PCT_FREE Minimum percentage of free space in a block IOT_TYPE If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL PCT_INCREASE Percentage increase in extent size 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 AVG_SPACE_FREELIST_BLOCKS The average freespace of all blocks on a freelist TEMPORARY Can the current session only see data that it place in this object itself? CLUSTER_NAME Name of the cluster, if any, to which the table belongs CHAIN_CNT The number of chained rows in the table AVG_SPACE The average available free space in the table EMPTY_BLOCKS The number of empty (never used) blocks in the table BLOCKS The number of used blocks in the table NUM_ROWS The number of rows in the table BACKED_UP Has table been backed up since last modification? LOGGING Logging attribute FREELIST_GROUPS Number of freelist groups allocated in this segment FREELISTS Number of process freelists allocated in this segment AVG_ROW_LEN The average row length, including row overhead
Related Commands:
DBA_TAB_COLUMNS