Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_ALL_TABLES

Description of all object and relational tables in the database

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
   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?

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 



Simon Sheppard
SS64.com