ALL_OBJECT_TABLES

Description of all object 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
   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:


© Copyright SS64.com 1999-2014
Some rights reserved