USER_ALL_TABLES

Columns
   ___________________________
 
   NESTED
      Is the table a nested table?
   SECONDARY
      Is this table object created as part of icreate for domain indexes?
   TEMPORARY
      Can the current session only see data that it place in this object itself?
   TABLE_TYPE
      Type of the table if the table is an object table
   TABLE_TYPE_OWNER
      Owner of the type of the table if the table is an object table
   OBJECT_ID_TYPE
      If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
   IOT_TYPE
      If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
   BUFFER_POOL
      The default buffer pool to be used for table blocks
   LAST_ANALYZED
      The date of the most recent time this table was analyzed
   TABLESPACE_NAME
      Name of the tablespace containing the table
   PARTITIONED
      Is this table partitioned? YES or NO
   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
   TABLE_NAME
      Name of 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 entry belongs
   PCT_FREE
      Minimum percentage of free space in a block
   PCT_USED
      Minimum percentage of used space in a block
   SAMPLE_SIZE
      The sample size used in analyzing this table
   MONITORING
      Should we keep track of the amount of modification?
   PCT_INCREASE
      Percentage increase in extent size
   MAX_TRANS
      Maximum number of transactions
   TABLE_LOCK
      Whether table locking is enabled or disabled
   INI_TRANS
      Initial number of transactions
   INITIAL_EXTENT
      Size of the initial extent in bytes
   NEXT_EXTENT
      Size of secondary extents in bytes
   MAX_EXTENTS
      Maximum number of extents allowed in the segment
   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?
   AVG_SPACE_FREELIST_BLOCKS
      The average freespace of all blocks on a freelist
   CACHE
      Whether the table is to be cached in the buffer cache
   INSTANCES
      The number of instances across which the table is to be scanned
   MIN_EXTENTS
      Minimum number of extents allowed in the segment
   NUM_ROWS
      The number of rows in the table
   NUM_FREELIST_BLOCKS
      The number of blocks on the freelist
   DEGREE
      The number of threads per instance for scanning the table
   AVG_ROW_LEN
      The average row length, including row overhead
   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

Related Commands: