Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_TABLES

Description of all relational tables in the database

Columns
   ___________________________
 
   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



Back to the Top

Simon Sheppard
SS64.com